| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
This one is tricky....Macro to save file as cell value x in di
Thankyou very much for your help this worked well...
"JE McGimpsey" wrote: This is rather an FAQ if you look in the archives: http://groups.google.com/advanced_gr...=group:*excel* One way: Public Sub SaveInB2AsA2() Const sPATH As String = "R:/SALES/Team 318/" ThisWorkbook.SaveAs _ Filename:=sPATH & Range("B2").Text & _ Application.PathSeparator & Range("A2").Text & ".xls" End Sub In article , "Andy" wrote: Two cells A1 & B2 I am trying to create a Macro to attach to a button to Save an .xls as "A1".xls in directory R:/SALES/Team 318/"B2" instead of typing it in all of the time.... Any helpers? Past attempts at this have failed.....the winner will get a big MVP vote! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding file name in a Cell | Links and Linking in Excel | |||
| File asks to update when no links were created | Links and Linking in Excel | |||
Threaded Mode
