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 :)

Private Sub YourButton_Click()

FollowHyperlink "C:\MyDocuments\YourExcelBook.xls"

End Sub

Code is more flexible than a macro.

HTH
IMO

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!

Originally posted by comadee
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.