Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2010
    Location
    Texas
    Posts
    54
    Thanks
    9
    Thanked 0 Times in 0 Posts
    I recorded several macros that created a DATABASE field. The ones access a tab delineated txt file worked fine. However, the macro that used an XLSX file introduced the Select Data Source dialog box, which requires the user to find the file and then click OPEN before continuing.

    Why does this superfluous dialog box appear, and more importantly, how do I make it not appear?

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts
    ForEach,

    Lack of responses indicates this may be an unfamiliar area, but it may help if you can list the steps that you take as you record the macro, as well as the resultant macro code. Also, does the unwanted dialog box appear in the user interface as you record the macro, or are you saying it only appears when you run the recorded macro? Also, is this in Word 2007?

    Gary

Posting Permissions

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