| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
excel - create a macro to use cell text as part of a file name
I am trying to write a macro to save a excel spreadsheet and use a cell that
contains text like a customer name. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
excel - create a macro to use cell text as part of a file name
Record your macro to include the File SaveAs, then edit that line of code.
Instead of ... Filename:="\\FinancialReporting\FY2006" ..., you might use .... Filename:="\\FinancialReporting\FY" & range("B2").value ... "bossman tv" wrote: I am trying to write a macro to save a excel spreadsheet and use a cell that contains text like a customer name. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| How to create a UTF-8 text file from excel VBA | Excel Discussion (Misc queries) | |||
| Create an Excel file using a macro | Excel Discussion (Misc queries) | |||
| Create a pick list to use to go to a text cell in Excel | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
