querytable connection fails in Excel 2007

K

kk45

I have an Excel file which contains a Workbook Open event that uses
querytable to query a text file and refreshes the data in the querytable in
the workbook. I have a shortcut on my desktop which opens this Excel file in
Excel. This method of opening the Excel file via a shortcut worked in Excel
2002 but not in Excel 2007. If I open the file in Excel 2007 via a shortcut,
I get the following error: "Method "connection" of object "_QueryTable
Failed". However, if I open Excel 2007 first and then open the file, I do
not get the error. Any thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shortcuts in OneDrive 0
Working outlook via vba code with xlsx - error 0
Excel freezing after sharing document by Email 0
help to understand 'querytable' 1
Embedded Excel into Word with Tables 0
REINSTALLING MS OFFICE PRO PLUS 2019 0
UPDATE through a QueryTable? Or? 0
inlineShape.OLEFormat.Activate() command fails for excel file 0

Top