Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
saveas calling a variable
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calling name of Sheet as a Variable? | Excel Worksheet Functions | |||
calling a value from another file using a variable in the file nam | Excel Worksheet Functions | |||
Calling a Userform from a Predefined Variable | Excel Worksheet Functions | |||
Calling a procudure through variable name | Excel Discussion (Misc queries) | |||
calling variable within string | Excel Worksheet Functions |