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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top