+ Reply to Thread
Results 1 to 3 of 3

Macro to open .dqy connection instead of manual way

  1. #1
    Registered User
    Join Date
    07-26-2012
    Location
    florida
    MS-Off Ver
    excel 2007
    Posts
    13

    Macro to open .dqy connection instead of manual way

    is there a way to open a .dqy file using a macro instead of Going to Data - Existing connections - etc etc using the file saved on a folder on my PC ? thank you. Trying to have few MS queries into a macro workbook to have quick access to them.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Macro to open .dqy connection instead of manual way

    Record the steps in a macro. If you want something adjusted in the recorded macro, post your code and describe the change.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    07-26-2012
    Location
    florida
    MS-Off Ver
    excel 2007
    Posts
    13

    Re: Macro to open .dqy connection instead of manual way

    Quote Originally Posted by AlphaFrog View Post
    Record the steps in a macro. If you want something adjusted in the recorded macro, post your code and describe the change.
    tried but opening manually doesnt record anything on macro, it stays blank like a new macro

+ 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. Replies: 2
    Last Post: 05-15-2015, 04:12 PM
  2. Enabling manual calculation on one specific workbook but all other open worbooks remain on
    By teo.paranoid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-25-2014, 06:39 AM
  3. [SOLVED] Leave OLEDB connection open
    By ngirrens in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-09-2012, 02:30 PM
  4. On open set calculation to manual not working all the time
    By matt260384 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-03-2009, 12:47 AM
  5. Replies: 0
    Last Post: 07-25-2006, 04:30 PM
  6. Excel Calculations Open in Manual Occasionally
    By rich32822 in forum Excel General
    Replies: 1
    Last Post: 02-18-2005, 10:06 AM
  7. Workbook_Open(): scheduled vs. manual open
    By steelerzfan36 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2005, 12:10 PM

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