Hi Guys
I have to right click on the date and do the refresh. But i am not able to do that
Thanks
Kamesh
Hi Guys
I have to right click on the date and do the refresh. But i am not able to do that
Thanks
Kamesh
Kindly try with macros
—for that record the macros and copy that vb script and paste it in a text file
—then use INVOKE VBA and execute the same macro by placing this activity inside the excel application scope
Kindly try this and let know for any queries or clarification
Cheers @Kamesh
Hi Palani
Thanks for the reply I am not using macro or VB script using Pivot table. In One sheet i will be entering the data and in the other I am just refreshing the data and getting the chart for required date
Thanks
Kamesh
Fine
the reason why suggested MACRO is we wont be able to click on the Date column alone with the click activity as it will select the whole table structure as element
Thats why, buddy
Cheers @Kamesh