If / Then help in Starting Excel from Access 1

[pdldavis]

Hi, I have an option group in Access where the first Select Case statement starts Excel and opens a specific file. The problem I'm having is depending on the version of Office, Excel can be in a different subdirectory.

I would like to include an If/Then statement that says if Excel doesn't exist in this folder, look for it in another folder, else error message. Or if there's a better way....

Existing:
Case 1
Call Shell("C:\Program Files\Microsoft Office\Office10\Excel.exe C:\Export\CableTransferSheet.xls", 1)

Would like to change to:
Case 1
If(Call Shell.....A)= not found,(Call Shell....B),"Error"

Any help would be appreciated.

Thanks

 

[DreamerZ]

You shouldn't need the exact location for Excel. It's a base program and will run when called with just "excel.exe"

So you should just be able to take out the path information like:

Call Shell("excel.exe C:\...", 1)

and it'll find Excel and start it.

DreamerZ

 

[pdldavis]

Thank you very much! That never occured to me. Works like a champ.
Dan