caching in excel
Application.CommandBars("Data").Controls("<menunam e").Enabled = False
--
If this post helps click Yes
---------------
Jacob Skaria
"murali velaga" wrote:
Can u share the code to enable/disable the refresh button (which is in the
menuitem 'Data') in excel.
"Jacob Skaria" wrote:
You can have the last updated date stored in a cell' and check that in
Workbook open. If the date is different enable or display the refresh button.
Once refreshed the button can be disabled
--
If this post helps click Yes
---------------
Jacob Skaria
"murali velaga" wrote:
we can have it. but how do we disable the refresh button after the first
refresh?
"Jacob Skaria" wrote:
Cant we have a hidden sheet with data populated on refresh..
If this post helps click Yes
---------------
Jacob Skaria
"murali velaga" wrote:
I have to create an excel report where i should have a connection string in
the report so that users can refresh the report once a day and after first
refresh the report should go offline but the report should show up the data
based on the filter changes . Basically i need to use caching technique .
Please help me in this.
|