Skip to Content
0
Aug 13, 2015 at 11:03 AM

VBA program to force the change in variable

20 Views

Hi All,

I have recently started working in Finance reporting. We have around more then 100 reports that we need to refresh once every month. This involves lot of manual work and its inefficient.

Through some online research i got to know that you can use VBA program to force the change in variable. All i want to change is fiscal period (Month,Year) in these 100 reports one by one.

Could you please help me with this.

Thanks in Advance !