Recreating the Windows file tree.....

D

david

you can try this and Arg1 would be your concatinated name,
but they could change the name then.

Application.Dialogs(xlDialogSaveWorkbook).Show Arg1:="GV
MFG Transactions.XLS", Arg2:="1"

to find the list of avail dialogs
goto excel help and selct the answer wizard tab and key in
the following

Built-In Dialog Box Argument Lists

hope this helps.

David
 
Top