transfer spreadsheet and view

[briank]

I am using the docmd.transferspreadsheet code from a
command button on my form. The Excel spreadsheet is now
being saved at a a specific location on the network
drive. However, what I really would like to do is to
give the user the option to place this file anywhere they
want and then to automatically pull up the Excel file to
view. Can this be done?

 

[Chris Nebinger]

One possible way:

If MsgBox("Do you want to view the file?",vbYesNo") =
vbYes Then
FollowHyperlink strExcelFileName
End If


Chris Nebinger

 

[John Nurick]

Hi Brian,

You can use the code at http://www.mvps.org/access/api/api0001.htm to
invoke the standard Save As dialog and let the user put the file where
they want. (If you want them to select the folder but not the filename,
use the Browse Folder code at
http://www.mvps.org/access/api/api0002.htm)

Once the file is saved, you can do as Chris suggests and call
Application.FollowHyperlink to launch the file in Excel.