I would like to be able to open an Excel97 Workbook using a macro in Access97.
Is there a way of doing this?
Ive tried using the command RunApp but it doesnt work! Here is what i put in:
"Excel.exe C:\Bill to Disk\Testing\Ericsson\Control.xls"
It opened Excel but didnt recognise the file.
Help me please!