Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 21st 21, 04:09 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 47
Default Save file with date from cell

Hello

I have a macro that saves my workbook to a location on the network, but I would like to add the date to the filename, with that date coming from the value in cell F2. The current format for that cell is Data, but the filename will not accept "/". I would want the date format to be mmddyy. Any ideas?

Thanks

  #2   Report Post  
Old May 21st 21, 05:14 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 47
Default Save file with date from cell

On Friday, May 21, 2021 at 8:09:18 AM UTC-7, Sabosis wrote:
Hello

I have a macro that saves my workbook to a location on the network, but I would like to add the date to the filename, with that date coming from the value in cell F2. The current format for that cell is Data, but the filename will not accept "/". I would want the date format to be mmddyy. Any ideas?

Thanks

Sorry, meant the cell format is DATE
  #3   Report Post  
Old May 21st 21, 07:30 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 88
Default Save file with date from cell

"Sabosis"
On Friday, May 21, 2021 at 8:09:18 AM UTC-7, Sabosis wrote:
Hello

I have a macro that saves my workbook to a location on the network, but I
would like to add the date to the filename, with that date coming from the
value in cell F2. The current format for that cell is Data, but the
filename will not accept "/". I would want the date format to be mmddyy.
Any ideas?

Thanks

'Sorry, meant the cell format is DATE

Just one of many ways -

MsgBox Date & " = " & Format(Date, "yymmdd")

I add dates to files like that for sorting, but adapt to your mmddyy. This
of course assumes your cell value really is a numeric date, or can be
coerced to a date.

Peter T




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recovering File Info Specifically Save Date or Print Date Gadgetgw Excel Discussion (Misc queries) 4 October 6th 08 08:43 PM
Save text file with value from Excel Cell stamped with date and time Rushna Excel Programming 4 July 27th 08 06:22 PM
formula to get the file save date in a cell? Gummby Excel Programming 7 March 11th 08 04:04 AM
SAVE OR SAVE-AS with a file name derived from a cell on the spreadsheet... KLZA Excel Programming 0 July 31st 07 03:52 PM
Macro to save Excel file with date and time in the file name? sonic_d_hog Excel Programming 2 January 5th 06 05:57 PM


All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017