Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell to MSAccess
Hi my original file was built in Excel 97 we have now
moved to Excel 2002, now the code that shell to Access wont work. the error I get is that the database is not recognized the Database has been converted, has anybody had this problem before if so can you please help. I am using the code below which worked ok in excel 97. Charles. Public Const DatabasePath = "S:\Vqship1\VinTracking.mdb" Public Const DatabasePath2 = "MSACCESS.EXE S:\Vqship1 \VinTracking.mdb" netAccess = Shell(DatabasePath2, vbMaximizedFocus) Set objAccess = GetObject(DatabasePath) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Start Excel inside MSaccess with a makro | Setting up and Configuration of Excel | |||
Hyperlink to specific Form in MSAccess | Excel Discussion (Misc queries) | |||
using linest excel function from msaccess with multidimensional ar | Excel Worksheet Functions | |||
Shell to MSAccess | Excel Programming | |||
Shell | Excel Programming |