Use VBA to create a new plan and automatically input the Start Dat

P

Peter Rooney

I am filtering data and copying it into a new plan via a VBA macro.
I create a new plan with the following line of code,

FileNew SummaryInfo:=True, Template:="", FileNewDialog:=False

Thus, the dialog box asking me which type of new file I want to create is
not displayed, but I still have to enter the start date. Is there any way in
which I can use VBA to automatically feed the start date into the new plan as
it is created?

Cheers

Pete
 
Top