open and save as

[victorcl]

hello,all
I am using Excel2003, now I have a question during my work. I want to use excel vbs to solve a problem, so I used the record mode to get a macro, the question is:
How can I change the vbs code so that when I run the marco, it popup some window message to let me to browse and choose the xls (for I have to deal with many different .xls in the same way) I need, at the end of code, I want a same window popup to ask me to save as. Can you provide me with an example? Thanks very much.

[royUK]

This is code that will enable you to opn a file

Please Login or Register  to view this content.

This will open the save as dialog

Please Login or Register  to view this content.

You could ry

Please Login or Register  to view this content.