Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Question
ActiveWorkbook.SaveAs Filename:="C:\" & Sheet1!Cells(1, 2) & "_" &
Sheet2!Cells(2, 1) -- HTH ijb Remove nospam from my e-mail address to talk direct Not MCSD just experienced "dayton" wrote in message ... I have a macro that takes a .csv file and puts certain date into specific sheets. Can I have the macro save and name the spreadsheet with the value of specific cells? Example: Sheet1 Cell B2 = 802922 Sheet2 Cell A2 = 0589513 I want to save it with the name: 802922_0589513 with the underscore T.I.A. Dayton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Macro question | Excel Discussion (Misc queries) | |||
Macro Question | Excel Discussion (Misc queries) | |||
Macro Question | Excel Worksheet Functions | |||
Macro Question | Excel Worksheet Functions |