Save Workbook Under Custom Name

  • Thread starter Thread starter Tobie Hanekom
  • Start date Start date
T

Tobie Hanekom

I have came across assistance to save a workbook using a macro which will
save a workbook with a name typed in a specific cell. It works nicely, but I
want to specify also the path and sub-directory in which the file must be
saved.

I have used the following code

ActiveWorkbook.SaveAs Range("Name").Value

The contents in Range "Name" will be the file name, but it will safe the
workbook under the new name in the same directory in which the master file
is allocated.

Once I am able to specify the path, I want to expand my macro to clear all
ranges as well, then the master will remain a master.

Tobie
 
Tobie,

Use:
ActiveWorkbook.SaveAs "C:\Folder\" & Range("Name").Value

To clear ranges, specify the ranges, with worksheet names if
necessary:

ThisWorkbook.Worksheets("SheetName").Range("A2:C5").ClearContents

HTH,
Bernie
MS Excel MVP
 
Bernie

Thank you very much, it works

Tobie

Bernie Deitrick said:
Tobie,

Use:
ActiveWorkbook.SaveAs "C:\Folder\" & Range("Name").Value

To clear ranges, specify the ranges, with worksheet names if
necessary:

ThisWorkbook.Worksheets("SheetName").Range("A2:C5").ClearContents

HTH,
Bernie
MS Excel MVP
Click to expand...
 
Back
Top