I am looking for a macro that will create a popup to put the number in S8 cell
what need is popup will occur & i will put the data(number) in that popup & that data will be in S8 & save and close the file
Code: Select all
Sub STEP3()
Dim Wb1 As Workbook
Set Wb1 = Workbooks.Open("C:UsersWolfieeeStyleDesktop1.xls")
Dim Ws1 As Worksheet
Set Ws1 = Wb1.Worksheets.Item(1)
(code for the process)
Wb1.Close SaveChanges:=True
End Sub