Have a macro running in Excel 2007 that simply copies a specific worksheet to a new file and saves it.
I would like the new file to be saved using a combination of our company name "MediaSTAR PO" plus the text located in cell ("E1").
Below is the current macro with just the company name. Need help with adding cell text.
Sheets("Pyramid Purchase Order").Select
Sheets("Pyramid Purchase Order").Copy
"X:\Hank\Business\Financial, Sales & Performance Data\Sales\Weekly Purchase Orders\Pyramid"
ActiveWorkbook.SaveAs Filename:= _
"X:\Hank\Business\Financial, Sales & Performance Data\Sales\Weekly Purchase Orders\Pyramid\MediaSTAR_PO.xlsx" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False