View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JHB JHB is offline
external usenet poster
 
Posts: 30
Default Opening excel 2010 spreadsheet from Access

Hi:

We have an application (operarting on Windows 7, originally developed
for Access 2000 and now running under Access 2007 in compatability
mode), which was originally programed to open an Excel file
(TASCSpreadGen.xls) in Excel 2007, using the following command line:

C:\Program Files (x86)\Microsoft Office\Office12\Excel.exe /e C:\TASC
\apps\TASCSpredGen.xls

For my sins, the user has now user has converted to office 2010! I
have the Access side running fine, but the call to Excel is wrong
because Office 2010 appears to put Excel somewhere different from
where Office 2007 put it. Can someone tell me the correct call to open
Excel 2010 from within Access and execute a spreadsheet?

Thanks

John Baker