Mr excel team and all users thank you for the support and abundant knowledge transfer.
![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Any better ideas ?
This is Workbook A (name keeps changing)
Sub SavMe()
Application.EnableCancelKey = xlDisabled
Dim newFile As String, fName As String
fName = Range("p1").Value
newFile = "Cashup" & fName
ChDrive "C:\test\"
ChDir _
"C:\test\"
ActiveWorkbook.SaveAs Filename:=newFile
End Sub
This work perfect,
But is there any way I can automate entry of 40 numbers by macro with a break after each entry till data refresh?
Thank you guys.
Any better ideas ?
This is Workbook A (name keeps changing)
- I got a number 404 in P1. (total 404,504,604... 40 numbers)
- Once i change the number data is updated in all sheets.
- Then user click Ctlr+Q to run Savme.
Sub SavMe()
Application.EnableCancelKey = xlDisabled
Dim newFile As String, fName As String
fName = Range("p1").Value
newFile = "Cashup" & fName
ChDrive "C:\test\"
ChDir _
"C:\test\"
ActiveWorkbook.SaveAs Filename:=newFile
End Sub
This work perfect,
But is there any way I can automate entry of 40 numbers by macro with a break after each entry till data refresh?
Thank you guys.