+ Reply to Thread
Results 1 to 3 of 3

Batch .iqy to xlsx conversion

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    3

    Batch .iqy to xlsx conversion

    Hello,

    I need to retrieve some data using web query function. I got some tips from this great forum. I have created a lot of .iqy files that I can convert to xlsx by running them one by one. Now, it would be great if I can have a macro to automate the processes.
    I have recorded a macro (using Excel 2013) for the first file.
    Please Login or Register  to view this content.
    I would be grateful if some one can make a macro to convert a folder of .iqy files to .xlsx with the worksheet and file names same as the .iqy files.

    Thanks a lot in advance.

    Nick
    Last edited by nickfan; 04-13-2013 at 06:57 PM. Reason: Add Excel Version

  2. #2
    Registered User
    Join Date
    04-11-2013
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Batch .iqy to xlsx conversion

    Hello,

    I find it easier to insert the query directly into excel. The data imported will take less than 30 rows. So I insert the query every 30 rows. I have recorded a macro for 3 insertions. The parameters of the query is "date" and "page". The date is discrete that I can input manually. Page is continuous, say 01-50. How can I have a loop of macro for the page from 01 to a specified number?

    Please Login or Register  to view this content.
    Best Regards,

    Nick

  3. #3
    Registered User
    Join Date
    04-11-2013
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Batch .iqy to xlsx conversion

    any one can help me?

    Thanks in advance

    Nick

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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