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
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