|
Saving as variable file name
I have the following code but it doesn't work as it should, can anyone advise
where I'm going wrong. Dim Filename Workbooks.Add Filename = "Report Week 1.xls" ' Name Workbook ActiveWorkbook.SaveAs Filename:="D:\Store Returns\Reports\Filename", _ FileFormat:=xlNormal, CreateBackup:=False Application.DisplayAlerts = False This will save the file with the name of "Filename" how can I change this code to reflect the variable name - Filename Regards Lee |
Saving as variable file name
strFilename = "Report Week 1"
ActiveWorkbook.SaveAs Filename:="D:\Store Returns\Reports\" & strFilename, _ FileFormat:=xlNormal, CreateBackup:=False Not tested, but better to avoid using Excel keywords as variable names! Regards, Stefi €˛leerem€¯ ezt Ć*rta: I have the following code but it doesn't work as it should, can anyone advise where I'm going wrong. Dim Filename Workbooks.Add Filename = "Report Week 1.xls" ' Name Workbook ActiveWorkbook.SaveAs Filename:="D:\Store Returns\Reports\Filename", _ FileFormat:=xlNormal, CreateBackup:=False Application.DisplayAlerts = False This will save the file with the name of "Filename" how can I change this code to reflect the variable name - Filename Regards Lee |
| All times are GMT +1. The time now is 04:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com