Opening Excel from Access

[scottydel]

Hello,

Wasn't sure where to drop this question.

I'm using Access 2003. After I dump a bunch of data to an Excel file, and
save it off, I'd like to give the user the prompt to open the Excel file the
app just created for them. I did a little digging, and found out that the
FileDialog object does not support the Open file dialog type in MS Access, or
as MSDN puts it:

msoFileDialogOpen Not supported in Microsoft Access.

So, anyone know of a workaround or a different approach to be able to prompt
the user to open an Excel file from within Access?

Thanks,

Scott

 

[fredg]

Hello,

Wasn't sure where to drop this question.

I'm using Access 2003. After I dump a bunch of data to an Excel file, and
save it off, I'd like to give the user the prompt to open the Excel file the
app just created for them. I did a little digging, and found out that the
FileDialog object does not support the Open file dialog type in MS Access, or
as MSDN puts it:

msoFileDialogOpen Not supported in Microsoft Access.

So, anyone know of a workaround or a different approach to be able to prompt
the user to open an Excel file from within Access?

Thanks,

Scott

If MsgBox("Open the Excel file?",vbYesNo) = vbYes then
Application.FollowHyperlink "PathToFile\FileName.xls"
End If

 

[scottydel]

Thank you....

If MsgBox("Open the Excel file?",vbYesNo) = vbYes then
Application.FollowHyperlink "PathToFile\FileName.xls"
End If