Opening Excel from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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