Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Saving Files - Date

Status
Not open for further replies.
arv1111

arv1111

MIS
May 25, 2008
6
AU
Hi
I was wondering if someone might be able to help out.

1. I'm wanting to create a macro to save a file with todays date.

File Name - AAA.xls
In one of the cells, I have the formula =now() that basically shows current date whenever you open the file.

I will set the directory for the files to be saved and it will all be in the same directory and folder.

Thanks.
Regards,
arv1111
 
Status
Not open for further replies.

Similar threads

techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
618
SkipVought
S
Andrzejek
  • Locked
  • Question
Word - Combine files
Replies
13
Views
297
Andrzejek
Andrzejek
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
306
ladyck3
ladyck3
Tropometer
  • Locked
  • Question
Help with dates
Replies
1
Views
282
SkipVought
S
ladyck3
  • Locked
  • Question
Excel 365: [SOLVED ]Data Dump Date: "Jul 12 20:27:14 CDT 2022" convert to 07/12/2022 2
Replies
8
Views
191
ladyck3
ladyck3

Part and Inventory Search

Sponsor

Back
Top