Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get External Data
Office 97 Pro
Excel file written 2005 and run daily for about a year. The Excel file gets external data from an Access data base. Tried to run the Excel file today. Error message: [Microsoft][ODBC Microsoft Access Driver] Invalid procedure call. Macro in Excel file: Sub GetMDBdata() ' ' GetMDBdata Macro ' Macro recorded 2/2/2005 by Chuck ' ' Keyboard Shortcut: Ctrl+o ' With ActiveSheet.QueryTables.Add(Connection:= _ "FINDER;C:\Program Files\Microsoft Office\Queries\Get Data from mdb.dqy", _ Destination:=Range("A1")) .FieldNames = True .RefreshStyle = xlInsertDeleteCells .RowNumbers = False .FillAdjacentFormulas = False .RefreshOnFileOpen = False .HasAutoFormat = True .BackgroundQuery = True .TablesOnlyFromHTML = True .Refresh BackgroundQuery:=False { *** The line above is where the sub hangs.} .SavePassword = True .SaveData = True End With End Sub I made a new blank Excel file and established a new get external query. Same error message as before. Examined the original Get Data from mdb.dqy file and the new Get Data2 from mdb.dqy. They were identical. Re-installed Office97. Did not help If it makes any difference - I had Office 2000 pro installed (in a different directory from Office97 so I could run either program) for some time. Didn't like Access 2000 so I removed all of Office 2000. Cleaned up registry and directories. I'll be very greatful for any suggestion for getting any Access data into any Excel file. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data | Excel Programming | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
Need advice : consolidating data from multiple CSV files in Excel - External data handling | Excel Programming |