By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,285 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,285 IT Pros & Developers. It's quick & easy.

showcurrent date in export txt file name

P: 9
I'm using a macro to transfer a table to txt file, which is fine but I want to run it each day (as the table contents change) and include the date in the filename without having to manually rename each time. It's infuriatingly simple but beyond my beginner's grasp. Can anyone help?
Aug 10 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,392
I don't use macro's much so you'll have to help me out here. How/Where do you tell it which filename to use?
Aug 10 '07 #2

P: 9
thanks rabbit,
Got an excellent reply from linq which has given me the solution and also a opportunity to start exploring the VB options in access.
Aug 14 '07 #3

P: 31
thanks rabbit,
Got an excellent reply from linq which has given me the solution and also a opportunity to start exploring the VB options in access.
I need this and it will work for me to
Oct 19 '07 #4

missinglinq
Expert 2.5K+
P: 3,532
Here's the post Neil99 was referring to:

Click Here and You're Off!

Let us know if you have problems.

Welcome to TheScripts, Wayne!

Linq ;0)>
Oct 19 '07 #5

P: 1
Thanks missinglinq. This is a gift that keeps on giving... 5 years after you provided it.

rx

@missinglinq
Feb 6 '12 #6

Post your reply

Sign in to post your reply or Sign up for a free account.