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.
Bookmarks