ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to use VBA to set "update changes" automatically every 5 min on a shared file? (https://www.excelbanter.com/excel-programming/346426-how-use-vba-set-update-changes-automatically-every-5-min-shared-file.html)

CiccioSPICE

How to use VBA to set "update changes" automatically every 5 min on a shared file?
 
Hi all,
I would to set the otion you read in the subject via VBA script. If I
use _accessmode:=xlShare option in saveAs method, I can set my file in
Shared mode...it works fine. But I need to set option about
automatically changes. Can someone help me?

TIA
CiccioSPICE



All times are GMT +1. The time now is 05:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com