VB Script to save excel file appending Month and Year in the filename

**alexgempesaw** · 02-21-2014, 02:12 AM

Hi,

Need assistance in creating VB script for saving an excel file that appends month and year.

Say my filename is: Sales Report + (January 2014).

Filename when saved should look like this: Sales Report (January 2014)

Thanks!

**ajryan88** · 02-21-2014, 02:29 AM

Hi,

Try this workbook. The required code is in the ThisWorkbook module. This will duplicate the file and not delete the old one, but let me know if you would like the file to REPLACE the existing file and I will edit my code.

Hope this helps

VB Script to save excel file appending Month and Year in the filename

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

VB Script to save excel file appending Month and Year in the filename

Re: VB Script to save excel file appending Month and Year in the filename

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VB Script for saving excel file appending weekend's date to the filename

Save .csv file as an Excel file while allowing user to choose directory and filename

Appending current year as i type day and month in a column

VBA script- save file with current filename

macro save file for current year and month with a file name SHReportddmmyy.xls

Bookmarks

Bookmarks

Posting Permissions