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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top