Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Save to a CSV file and close that file

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Matthew
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone help me, I am running a macro that run's an odbc query and then saves the file in CSV format, this then loops for a set number of time at a set time period. My problem is that I need to close this file, i.e. the CSV file (so another programme can use it) and continue running the macro. When I use the close command the macro stops running.

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    Midlands, UK
    Posts
    217
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried putting the macro in your personal.xls file & running it from there ?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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