Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing Inactive Workbook Cells
Good morning all
Hope someone can provide some help here. I have created a macro that takes a specific worksheet from the workbook and saves it as its own workbook (code shown below) referencing 2 cells in the worksheet as the filename. Sub Savefile() 'opening workbook ActiveSheet.Copy ' Copies active sheet to a new workbook ActiveWorkbook.SaveAs Range("H6").Value & Range("H7") End Sub However, as part of the filename, I would also like to include a cell from a different worksheet in the original workbook (location shown below) workbook name: version2.xls worksheet: MasterDMA cell: E6 Please could someone provide advise on how to reference that cell as well within the filename. Thanks so much Regards, PVANS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Cells in another worksheet in same workbook | Excel Programming | |||
Referencing Cells of Different Workbook | Excel Programming | |||
How do I save an Excel workbook so that cells referencing another. | Excel Discussion (Misc queries) | |||
Referencing cells in another workbook | Excel Programming | |||
Referencing cells in another workbook | Excel Programming |