Thread: Macro that saves Excel worksheet with value in C4 as the file name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
moon[_7_] moon[_7_] is offline
external usenet poster
  
Posts: 53
Default Macro that saves Excel worksheet with value in C4 as the file name

"Benedikt F" schreef in bericht
...
Hi

I have been asked to create an Excel invoice form and I want to create
macro that saves the worksheet. I want the macro to use the value in C4
(invoice number) as the name for the Excel invoice. I hope someone can
help me with this.

best regards,
Benedikt F.
Iceland Seafood Int.




Public Sub SaveAsC4()
ThisWorkbook.SaveAs Cells(4, 3).Value
End Sub



Reply With QuoteReply With Quote