PC Review

Thread Tools Rate Thread

Export table to txt file with a variable filename

New Member
Join Date: May 2011
Posts: 2
      10th Jul 2012
Hello, I tried doing some searching on this but wasn't finding much. I am very comfortable with Excel and so-so at creating macros in Excel with VBA but when it comes to Access I am much more of a rookie.

My current setup - Access 2007-2010, win7 64bit
I have a macro that does the following
- runs saved import to import excel file to table ("Table_Import")
- runs a make table query ("Query 1") to make new table ("Table 1")
- runs a make table query ("Query 2") to make new table ("Table 2")
- runs saved export to export Table 2 as text file ("Export File").

My dilemma: Query 2 gives the user a prompt [Enter date] where users will enter the date of the records they want to include (ex: 7/10 or 7/10/12) in the final output. What I would like to do is have the name of the txt "Export File" include the variable the user entered (ex: Export File_07.10.12).

Thanks in advance for any help!
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
HttpPostedFile.saveas(filename) issue when the filename is used "-" as a part of the filename. Ken Microsoft Dot NET Framework 0 25th Feb 2009 11:58 PM
testing mime 1 (ignore) - "myfile3.txt", "myfile1.txt", "myfile2.txt" as@somewher.com Microsoft Access 0 10th Sep 2006 08:10 AM
Converting a Variable Filename to a Constant Filename =?Utf-8?B?TWFnbml2eQ==?= Microsoft Excel Programming 2 15th Aug 2006 06:13 PM
saving file with new filename based on current filename Michael J. Malinsky Microsoft Excel Programming 5 18th Mar 2004 01:34 PM
Export to TXT - Export Specification & Headers Ray Microsoft Access External Data 1 11th Jan 2004 06:54 PM




All times are GMT +1. The time now is 04:49 AM.