Results 1 to 2 of 2
  1. #1
    GraemeG is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Feb 2011
    Posts
    152

    Output tables to an excel file on a network drive

    Hello.

    I am currently using a macro to output tables to an excel file on a network drive.
    This all works great but I was wondering whether I could use VBA to do this but incorporate a date into the file.
    I.e. currently the file goes to the drive and sits there but next time it is run it tries to overwrite. So i was wondering if incorporating a date into the extract (File name which includes date of extraction) could be done?

    Any help much appreciated!

  2. #2
    kennejd is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    188
    Yes, it can be done. Just add a formatted date to the file name that you export to. I would format the date to something like format(date,"yyyymmdd").

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 17
    Last Post: 06-04-2012, 05:11 PM
  2. How would you output an XML file with an Ole Attachment?
    By techneophyte in forum Programming
    Replies: 7
    Last Post: 09-09-2010, 09:09 AM
  3. Replies: 0
    Last Post: 07-14-2010, 04:01 PM
  4. Splitting an Excel File into Multiple Access Tables on Import
    By TheWolfster in forum Import/Export Data
    Replies: 4
    Last Post: 04-29-2010, 04:52 AM
  5. Replies: 0
    Last Post: 04-29-2009, 04:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums