opening and saving a file using an interactive form?

[hatebyproxy]

Hello all - been forever since I used VBA - Is there a way to use a form to open and save a file? It needs to be interactive as the file the user will open will have a different name every month, then she will have to save it under a different name (again, according to the month). For example she will need to open testMarch 2013.xls, delete all data in 17 sheets, copy new data into same sheets then save as testApril 2013. So I was thinking an interactive form.

Hope I explained well enough. Thx for any help.

 

[PHV]

Have a look at the Application.GetOpenFilename method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886