+ Reply to Thread
Results 1 to 2 of 2

Update Querytable linked to CSV file without having to select the file manually

  1. #1
    Registered User
    Join Date
    02-10-2011
    Location
    Copenhagen, DK
    MS-Off Ver
    Excel 2007
    Posts
    30

    Smile Update Querytable linked to CSV file without having to select the file manually

    Hi All,

    I have a querytable linked to a CSV file. I want the querytable to update automatically. So far I have used this code:
    Please Login or Register  to view this content.
    The problem with this code is, that I have to select the file manually from a pop-up window. How can i programme it to link to one specifik CSV file every time without asking me?

    I think I need to add a path somewhere in the code?

    THanks for your help!

    Kind Regards KRAND
    Last edited by KRAND; 05-09-2011 at 09:24 AM.

  2. #2
    Registered User
    Join Date
    02-10-2011
    Location
    Copenhagen, DK
    MS-Off Ver
    Excel 2007
    Posts
    30

    Re: Update Querytable linked to CSV file without having to select the file manually

    Solved it on my own.

    RIght click on the table.
    select attributes and edit it from the menu.

    See you. :-)

+ 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