I wrote a VBA code that converts my .IQy files to .xlsx files because eventually I want to merge these excel files together. But every time the code goes through one I get an "Import Data" prompt (as shown in the image attached). I have over 40 files and was wondering if there was a way to automate the ok button click. Ive tried using
but I still get the box. Any advice or solution would be appreciated.
Capture.PNG
Ive also tried to mimic the enter key from my keyboard but the prompt will not go away
Am I putting the sendkeys in the wrong place?
Bookmarks