All,
I am receiving an error from the Microsoft Query wizard when I try and create a query of an xlsx or xlsm file. The error is "External table is not in the expected format."
Can anyone tell me why this error is coming up and how I can correct the file so that I can write a query to pull info from a Named Range in the file.
I have written some code to duplicate the Microsoft query using ADODB but get the same error message when the Open connection line runs.
I have been using this method with these files for a while now but curiously it has quit working as of late. This is very frustrating as this is a critical method of my workflow.
Thanks for any help you can provide.
John M.
I am receiving an error from the Microsoft Query wizard when I try and create a query of an xlsx or xlsm file. The error is "External table is not in the expected format."
Can anyone tell me why this error is coming up and how I can correct the file so that I can write a query to pull info from a Named Range in the file.
I have written some code to duplicate the Microsoft query using ADODB but get the same error message when the Open connection line runs.
I have been using this method with these files for a while now but curiously it has quit working as of late. This is very frustrating as this is a critical method of my workflow.
Thanks for any help you can provide.
John M.