Hi all,
I hav ethe following macro that saves my workbook to my desktop, but is there a way to save it to anyones desktop
ie whoever open the workbook?
Many thanks
I hav ethe following macro that saves my workbook to my desktop, but is there a way to save it to anyones desktop
ie whoever open the workbook?
Code:
Option Explicit
Sub Save()
Dim newFile As String, fName As String
fName = Range("GL15").Value
ChDir _
"C:\Users\Bob Mahon\Desktop"
ActiveWorkbook.SaveAs Filename:=fName
End Sub
Many thanks
Last edited: