Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error opening external xls
My name is Pieter and I am sure you can assist me with a problem I experience with my project. I work in Excel 2003 and trying to open a .xls file from Excel using Workbooks.Open statement. All files open accept a .xls file that was exported from Access 97 with the “Output To” statement. I think that I must use a “connection string” to connect but is not familiar with this and not sure if that is the problem. If I open this file from within Excel 2003 it opens but gives me a error telling me it renamed a invalid sheet. Can you please assist me in solving this problem Thank you, Pieter Grobbelaar -- pietgrob ------------------------------------------------------------------------ pietgrob's Profile: http://www.excelforum.com/member.php...o&userid=33960 View this thread: http://www.excelforum.com/showthread...hreadid=537352 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening An External File | Excel Discussion (Misc queries) | |||
how do I activate links without opening external workbooks? | Excel Discussion (Misc queries) | |||
Code to select 'Disable Macro' when opening an EXTERNAL FILE | Excel Programming | |||
Opening an external file | Excel Programming | |||
Autorefreshing excell external data while opening from VBA code | Excel Programming |