+ Reply to Thread
Results 1 to 2 of 2

Using userform fetch data from close workbook using SQL Query

  1. 09-21-2016, 07:36 AM #1
    xlhelp7
    xlhelp7 is offline
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Using userform fetch data from close workbook using SQL Query

    Hi All,

    I Have a userform by which i want to fetch data using SQL Query from closed workbook from my desktop to this workbook in sheet1.

    Please find the attached sample file.

    Thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-22-2016, 01:06 AM #2
    xlhelp7
    xlhelp7 is offline
    Forum Contributor
    Join Date
    11-19-2015
    Location
    India
    MS-Off Ver
    excel 2013
    Posts
    124

    Re: Using userform fetch data from close workbook using SQL Query

    bump pls, can somebody help!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fetch data from a workbook and split into tabs
    By Bilbash123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2015, 12:56 PM
  2. [SOLVED] VLOOKUP: is it really unable to fetch data from another closed workbook?
    By alice2011 in forum Excel General
    Replies: 8
    Last Post: 02-09-2015, 11:52 AM
  3. How to close current Workbook in a Userform
    By Bridge1969 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2013, 11:38 AM
  4. [SOLVED] Close workbook when unloading a userform
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2013, 07:21 AM
  5. Populating VBA userform and Fetch previously entered data edit and make new entry
    By vijaynadiad in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-07-2013, 11:59 AM
  6. How to Open 2nd workbook from userform, then close 2nd Userform
    By bigfoot007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2012, 02:03 PM
  7. close workbook and open userform
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2009, 06:46 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1