D
Douvid
HI,
I need to use an inputbox to get the user name of the user
and then save the workbook to a specific location. This
location where I need to reinsert the user name as a
variable. I try this but something is wrong with the
argument. I haven't succeed to writte the synthaxe to
insert my variable in the location.
Thanks for your advices
Application.ThisWorkbook.SaveAs D:\The Documents and
Settings/<user name>/Application Data/Microsoft/AddIns
I need to use an inputbox to get the user name of the user
and then save the workbook to a specific location. This
location where I need to reinsert the user name as a
variable. I try this but something is wrong with the
argument. I haven't succeed to writte the synthaxe to
insert my variable in the location.
Thanks for your advices
Application.ThisWorkbook.SaveAs D:\The Documents and
Settings/<user name>/Application Data/Microsoft/AddIns