Sorry folks, as "intuitive" as I think I am, this one I'm totally lost on. Did a Google referencing
how to generate a filename for a new workbook based on information in 2 cells in the active worksheet.
When I found a possible solution under Excel Forum's, the answer says, "Login or Register to view the content"
So, I login and am taken to what I suppose is the home screen with no reference whatsoever to the location
of the response I wish to view.
Am sure there is a simplistic answer. If someone wouldn't mind sharing, I would most appreciate how to access
the answer to that question. If this has been answered before, apologize, just point me in the right direction.
My issue is trying to name a new workbook to which I am saving a worksheet with the SaveAs command.
Works beautifully if I stick in a name. However, need to make the code more versatile. I want to use
the name that is in a cell on the worksheet to save the workbook as. I may want to concatenate names in
a couple of cells. Something on the order of:
code, ...[Test_Copy_ChemicalToWorkbook.xlsm]Threshold!Range("C2").Value.xlsx",
Where [ ] is workbook name
Threshold is name of worksheet
C2 is the cell that has a name I want to use?
Most courteous...
Sgt Rock in a HOT Dallas
Bookmarks