Selecting Date mm.dd.yyyy in Column A for new file name mm.dd

**Jim15** · 06-28-2019, 04:45 PM

Can someone tell me how to extract a date in column A (multiple rows but same date) and use this date for a new file name that is appended with mm.dd?

For example, file is titled FILE and new name would be FILE mm.dd.

**Marc L** · 06-28-2019, 06:11 PM

Use the Format function, to see in VBA inner help …

**dangelor** · 06-28-2019, 08:38 PM

Something along the lines of...

Please Login or Register  to view this content.

Selecting Date mm.dd.yyyy in Column A for new file name mm.dd

LinkBack

Thread Tools

Rate This Thread

Display

Selecting Date mm.dd.yyyy in Column A for new file name mm.dd

Re: Selecting Date mm.dd.yyyy in Column A for new file name mm.dd

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Multi Column Listbox returning date as mm-dd-yyyy instead of dd-dmm-yyyy

[SOLVED] Change existing date from mm/dd/yyyy to dd/mm/yyyy format without changing the position

[SOLVED] Macro to Save As a file with a date in dd-monthname-yyyy

Macro to open csv file converts dd/mm/yyyy to mm/dd/yyyy

[SOLVED] Imported data contains strings dd.mm.yyyy how can I convert to date format dd/mm/yyyy inVB

Saving a file by referencing a cell with a date and formatting the date to yyyy mm dd

opening excel file -> date format problem: DD/MM/YYYY vs MM/DD/YYYY

Bookmarks

Bookmarks

Posting Permissions