+ Reply to Thread
Results 1 to 2 of 2

How to import IQY file without "Import Data" Dialogue Box?

  1. #1
    Registered User
    Join Date
    08-28-2018
    Location
    NJ
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    1

    How to import IQY file without "Import Data" Dialogue Box?

    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
    Please Login or Register  to view this content.
    but I still get the box. Any advice or solution would be appreciated.

    Capture.PNG

    Please Login or Register  to view this content.

    Ive also tried to mimic the enter key from my keyboard but the prompt will not go away
    Please Login or Register  to view this content.
    Am I putting the sendkeys in the wrong place?
    Last edited by cheeks23; 08-28-2018 at 02:34 PM. Reason: clarified title

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: How to import IQY file without "Import Data" Dialogue Box?

    Did you try using the macro recorder to see what code was generated. I wondering if you need to use the OpenDatabase method rather than Open.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Code to import worksheet using dialogue box
    By cs0rpc in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2017, 12:18 PM
  2. [SOLVED] Power Pivot SQL Data Import - How to update import filter
    By minnesotaart in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-29-2013, 12:39 PM
  3. Import Macro sometimes adding data to end of last import
    By himynameisiain in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2013, 07:06 AM
  4. [SOLVED] Macro - Master file to import data from another open file with variable file name
    By jdodz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2012, 10:56 PM
  5. File import - select file and import sheet(1) from closed workbook
    By Armitage2k in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2011, 03:15 AM
  6. Import External Data doesn't import
    By JakeAy in forum Excel General
    Replies: 7
    Last Post: 01-26-2010, 03:58 AM
  7. Dialogue box to select folder >files for import?
    By firebladejr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2008, 08:38 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1