Versions of Office

[Michael]

A new computer has come with Office 2003 Standard. Because
the user needs Access, he installed Access from the Office
2000 Pro which was on his old computer. Now when running
an Access database that calls Excel from code, Excel does
not start. The error is to the effect that it cannot find
the file. The line where it stops is:
Call Shell("Excel.exe /r " & cstExcelPath
& "MarginFlash.xls", 1)
(cstExcelPath is the path as a constant). This has been
working for months on the old computer (Office2000Pro)
Has something changed in the way Office2003 works?
Thinking it may be a problem with file type association, I
checked in Explorer double-clicking on "MarginFlash.xls",
and it starts Excel and runs the sheet correctly; but it
doesn't work from code in Access2000. Don't understand
it...
Many thanks
Michael

 

[Rob Schneider]

A hunch ... installing an older Office program on top of the newer
Office program confused Office.

Try: un-install both Access and Office 2003. Then install Office 2000
Pro (only chose Access), then install Office 2003 Standard.

Hope this is useful to you. Let us know.

rms

 

[DL]

I believe that Office2003 will have a different path to Excell than
Office2k.
I dont know if youve updated the cstExcellPath constant
This may be the route of the problem.
MS altered the Office Bin Folder name, to make it unique for each version,
after Office2K
David

 

[Michael]

Hi
cstExcelPath is the path to the shreadsheet - there is,
and never has been, no path to excel.exe. I assume it used
the file type association to run the correct application
(Excel here), but this doesn't happen now, even though it
works just opening a spreadsheet from Explorer (even when
Excel is not open).

I'll try Rob's suggestion next time I'm over there. But
who pays for the time?
Maybe there is a correct order for installing versions of
Office now - the opposite to installing service patches
where one has to reinstall the latest last!! Why am I
confused?

Michael

 

[Rifleman]

Hi
cstExcelPath is the path to the shreadsheet - there is,
and never has been, no path to excel.exe. I assume it used
the file type association to run the correct application
(Excel here), but this doesn't happen now, even though it
works just opening a spreadsheet from Explorer (even when
Excel is not open).

I'll try Rob's suggestion next time I'm over there. But
who pays for the time?
Maybe there is a correct order for installing versions of
Office now - the opposite to installing service patches
where one has to reinstall the latest last!! Why am I
confused?

Michael

have a look at this:
http://support.microsoft.com/default.aspx?kbid=828956

 

[Beth Melton]

Hi Michael,

It could be that you need to include the full path to Excel.exe in the
Shell command.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/