PDA

View Full Version : [SOLVED] Altering closed workbooks.



The Tamer
11-17-2004, 07:44 AM
Hi all,

Can I, using VBA, move or delete sheets in a workbook without opening it? It's a question from MrE, but it's one that would be very handy to know the answer to.

Regards

CBrine
11-17-2004, 07:50 AM
Hey Tamer,

I know that it is possible to modify a cells contents without opening the workbook, but I don't believe it's possible to delete or move the worksheets within a closed workbook.

The Tamer
11-17-2004, 08:59 AM
Damn!