How to automatically insert the dates into filters by using a Macro

[SiriChan]

Every week I need to run 10 to 15 customized reports from MSP by using various filters and dates.

I have written a macro for these and it is meeting only part of my requirements. Whenever I run macro, I need to enter dates for every filter.

Is there a method, which allows the program by itself insert the date into the Filter pop up boxes.

Example: Let us say 1/30/04 is report date. The method should automatically insert the system fetched date into the Filter pop up box and generate reports.

I would appreciate each one of yours valuable tips on this.

thanks

Siri ...

 

[SBendBuckeye]

Hello Siri,

Can you post the code you currently have? Maybe that will serve as a starting point so someone to help you. Good Luck!

Have a great day!

j2consulting@yahoo.com

 

[SiriChan]

Hi SBendBuckeye
Here is the code to start with

For example, if you run the following Macro you will get pop up box like "Date Range" and you need to enter date in the pop-up box manually.

Sub Run_a_Filter()

FilterApply Name:="Date &Range"

End Sub

My requirement
I am going to fetch the date programatically from the system and manipulate the same for various reports.

My program should able to enter this manipulated date automatically into the Pop up boxes (generated by the filters) to get the desired results.

But unfortunately I can not make the program to enter the date into the Pop-up box directly. I need to enter the date manually while executing the Macro.

So I am wondering is there a way to resolve this issue.

thanks

siri ...