Emptying cache or "history" before opening workbook
 

I'd like one of my workers to be able to quickly download and open
updated XL spreadsheets each morning by merely clicking on an icon on
their "desktop." With the shortcut icon approach, they do not have to
go look to see if they got an e-mail with new data; they click on the
icon and they have the latest data. The process is simplified by the
fact that they take the same action each time. They don't have to
wonder 'did I or did I not find the e-mail with the updated data?'

If I place a shortcut icon to the XL97 workbook located on my IPS'
server, when they click on the icon, their machine automatically opens
up their browser and downloads the file. All they need to do is say
"OPEN." However, if they have previously downloaded a file, the browser
opens the file from the data in the cache or history rather than going
and getting the new data.

Or alternatively, the browser assigns a new name to it. If the first
file opened was named Name.xls, the next time the file is downloaded and
opened, it gets the name Name-1.xls. If the name is changed, the macros
don't run because they are looking for the file Name.xls.

Is there a way I can insert code in the shortcur or the WorkBookOpen
routine that will either empty the cache or force the browser to go and
get the new data rather than retrieving the data from the cache /
history. The worker is currently using IE but will probably change over
to FireFox.

WindsurferLA

Emptying cache or "history" before opening workbook
 

What you want to do is probably best done through the browser. IE
definitely and Firefox most likely have a 'delete the cache on exit'
option.

Alternatively, write the macros so that they work with the
activeworkbook (or thisworkbook if more appropriate) rather than a
hardcoded name.xls

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I'd like one of my workers to be able to quickly download and open
updated XL spreadsheets each morning by merely clicking on an icon on
their "desktop." With the shortcut icon approach, they do not have to
go look to see if they got an e-mail with new data; they click on the
icon and they have the latest data. The process is simplified by the
fact that they take the same action each time. They don't have to
wonder 'did I or did I not find the e-mail with the updated data?'

If I place a shortcut icon to the XL97 workbook located on my IPS'
server, when they click on the icon, their machine automatically opens
up their browser and downloads the file. All they need to do is say
"OPEN." However, if they have previously downloaded a file, the browser
opens the file from the data in the cache or history rather than going
and getting the new data.

Or alternatively, the browser assigns a new name to it. If the first
file opened was named Name.xls, the next time the file is downloaded and
opened, it gets the name Name-1.xls. If the name is changed, the macros
don't run because they are looking for the file Name.xls.

Is there a way I can insert code in the shortcur or the WorkBookOpen
routine that will either empty the cache or force the browser to go and
get the new data rather than retrieving the data from the cache /
history. The worker is currently using IE but will probably change over
to FireFox.

WindsurferLA

Emptying cache or "history" before opening workbook
 

Tushar Mehta wrote:
What you want to do is probably best done through the browser. IE
definitely and Firefox most likely have a 'delete the cache on exit'
option.

Alternatively, write the macros so that they work with the
activeworkbook (or thisworkbook if more appropriate) rather than a
hardcoded name.xls

Thanks... good ideas... I've not tried it yet, but I assume I can use
the above terminology in a command such as

Thisworkbook.Close