Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Reverse naming of file
Hi,
I'm copying data relating to an engineered part into a sheet. The format is constant and the name of the client and part appear in specified cells. Is it possible now to rename the xls file as (constant+ partname)? I mean automatically, not cutting and pasting. thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Reverse naming of file
Via macro, you could do something like this (modify to suit)
Sub ReName() xConstant = Range("A2") xPartName = Range("B2") ThisWorkbook.SaveAs xConstant & xPartName End Sub -- Best Regards, Luke M "kenppy" wrote in message om... Hi, I'm copying data relating to an engineered part into a sheet. The format is constant and the name of the client and part appear in specified cells. Is it possible now to rename the xls file as (constant+ partname)? I mean automatically, not cutting and pasting. thanks |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Reverse naming of file
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto file naming | Excel Discussion (Misc queries) | |||
Importing Word file and Naming of Worksheets | Excel Worksheet Functions | |||
Can I reverse a saved file to the previous file in Excel? | Excel Discussion (Misc queries) | |||
File naming conventions | Excel Discussion (Misc queries) | |||
naming .xls file based on a cell in excel | Excel Discussion (Misc queries) |