Access to excel problem

[cornishteeth]

I have a report that needs to be viewed in an excel
spreadsheet. I want to create a macro that opens the
report as an excel spreadsheet for viewing, and then sends
that object via outlook once I allow it to go. I know how
to send object, its just a problem with getting the
spreadsheet to open for viewing. I can get it to save on
my desktop, but not automatically open. Can anyone help.

Frank

 

[Norie]

You could try the following VBA code:

Dim retval

retval = Shell("C:\Program Files\Microsoft Office\Office\Excel.exe c:\newarrivals.xls", vbNormalFocus)

You might need to change the path to Excel.exe.