Open a xls file from access

[pancho13]

Hello Access Gurus of the world!!

Any one could help me with this little problem....

How can I open a xls file from access, using some sort of commands or a macro.....actually a macro will be the go.

Ho can I open a xls file using a macro in access

thanks for your help

 

[IMO]

Private Sub YourButton_Click()

  FollowHyperlink "C:\MyDocuments\YourExcelBook.xls"

End Sub

Code is more flexible than a macro.

HTH
IMO

 

[comadee]

...but I really need to use a macro...

I agree, code is more flexible than a macro.

However, I'm using a macro to transfer data to a spreadsheet, then I'd like to launch the Excel spreadsheet automatically.

Any suggestions would be great. Thanks!

 

[Mile-O]

Re: ...but I really need to use a macro...

However, I'm using a macro to transfer data to a spreadsheet, then I'd like to launch the Excel spreadsheet automatically.

There is no however.

If you use a macro, what happens if someone deletes/moves the spreadsheet? Yes, your database 'crashes'.

Macros don't allow for error-trapping and handling.