Forum Home
Press F1
 
Thread ID: 15027 2002-01-26 10:32:00 Opening multiple files Guest (0) Press F1
Post ID Timestamp Content User
32947 2002-01-26 10:32:00 Hi,

I use multiple word and excel files on a daily basis, and spend about 5 minutes each morning opening them up individually.....

Does anyone know if you can, somehow, create something to open all the files at once?

I use office 97 at wk, and would like to know the same of office 2k if possible....

Thanks

Kerry
Guest (0)
32948 2002-01-26 10:58:00 You could use visual Basic for applications (VBA) to do what you want. The easiest way is to go to Tools-Macro-Record and then open up the files you want and then stop recording. You can then put an icon on the toolbar. Guest (0)
32949 2002-01-26 11:15:00 Thanks Mike,

Didn't think of that.....

Works well.....

:)
Guest (0)
1