Macro to export to Excel. How do I ask for current date?

[Brian Bonner]

I have a macro that exports Project to Excel. In the macro it calculates
whether or not something is past due based on the date the macro is run. I
want to be able to report as of a date entered by the user. Can someone point
me to a reference where I could find a discussion of asking for input from
the user in a Project macro?

 

[John]

I have a macro that exports Project to Excel. In the macro it calculates
whether or not something is past due based on the date the macro is run. I
want to be able to report as of a date entered by the user. Can someone point
me to a reference where I could find a discussion of asking for input from
the user in a Project macro?

Brian,
What you want to use is the InputBox Function. You can find the syntax
in the object browser.

I do use the inputbox function but only when necessary. I prefer to
calculate or develop the necessary data in order to keep user input
requirements to a minimum.

John
Project MVP

 

[Jack Dahlgren]

The code here shows a couple of examples of using an input box to prompt for
user input.
http://zo-d.com/blog/archives/microsoft-project/microsoft-project-performance-limitations.html