open save as dialog box

[Guest]

I am exporting information from a table to an Excel file. I can open the
Excel file for the user but now I want to open the Save As dialog box so they
can save the file to a location and name of their choice and NOT what I named
the file programmatically. Any suggestions on how to do this is appreciated.

Following is the code I am using to open the file:

With ExcelApp
.Visible = True
.Application.WindowState = xlMaximized
.Workbooks.Open (TargetFile)

End With

 

[chris.nebinger]

Get the code from here:

http://www.mvps.org/access/api/api0001.htm

Prompt for the box, get the file name, save the file (checking
overwrites, of course).

However, I'm thinking Excel should have a .SaveAs method with a prompt.
I can't seem to recall of the top of my head.