Hi everyone
The story so far - I am utilising web queries (.iqy files) downloaded from an ERP system and then uploaded into worksheets in Excel. Trouble is there are 50 individual reports so 50 sheets, each with a web query .iqy file embedded.
Recently, I started getting an error after copying or saving the file as xlsb so that next time the file was opened Excel would display the worksheet but an error message on open would say that a formula in one of the files in \xl path was corrupted for sheet1. Well a sheet1 does not exist so it's all very strange.
So I reverted back to previous versions when I didn't receive such an error. In those previous versions, I only had 10 web query iqy files, and I never had this error on open.
I tried to put back in the web queries one by one.....I got the same error message again when the 50 were input. I have decided that this is an issue with too many web queries so I am examining another approach.
What I'd like to do is have VBA import only the minimal amount of web queries needed (I can manage with 2). I was thinking of centralising all the iqy files on the network and have VBA auto load them as and when required.
So I recorded the macro and lmported a iqy file. The problem is that when you do this manually, your email address is asked for in a small popup window. How do I overcome this popup message from appearing? If it helps, part of the connection string in the iqy file contains the following:
...........webquery.nl?compid=4201333&entity=32222&email=["emailaddress","Please enter your email address:"]&role=1026&cr......
Bookmarks