T Trent Argante Feb 24, 2004 #1 Dumb question, but I forgot how to programmincally create a workbook and I can't find it in Help, so...help! =;O) Trent
Dumb question, but I forgot how to programmincally create a workbook and I can't find it in Help, so...help! =;O) Trent
B Bob Phillips Feb 24, 2004 #2 Trent, It's pretty simple workbooks.Add -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Trent, It's pretty simple workbooks.Add -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
C Chip Pearson Feb 24, 2004 #3 Trent, Use the Add method of the Workbooks collection. E.g., Dim WB As Workbook Set WB = Workbooks.Add() -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Trent, Use the Add method of the Workbooks collection. E.g., Dim WB As Workbook Set WB = Workbooks.Add() -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
T Trent Argante Feb 24, 2004 #4 Thanks, Bob. I was ASSuMEing that the workbook had to exist prior to .ADDing it to the collection, so I didn't even bpther trying it...uh, hello, McFly? Trent Argante
Thanks, Bob. I was ASSuMEing that the workbook had to exist prior to .ADDing it to the collection, so I didn't even bpther trying it...uh, hello, McFly? Trent Argante
