Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2024, 12:00 PM
Logit Logit is offline Can Excel VBA auto-update a co-shared workbook every ten seconds? Windows 10 Can Excel VBA auto-update a co-shared workbook every ten seconds? Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Wouldnt simply saving the workbook every 10 seconds suffice ? Placing the vba macro into the original workbbok's "ThisWorkbook" module.
Reply With Quote
  #2  
Old 10-03-2024, 05:05 PM
syl3786 syl3786 is offline Can Excel VBA auto-update a co-shared workbook every ten seconds? Windows 10 Can Excel VBA auto-update a co-shared workbook every ten seconds? Office 2019
Advanced Beginner
Can Excel VBA auto-update a co-shared workbook every ten seconds?
 
Join Date: Jan 2023
Posts: 97
syl3786 is on a distinguished road
Default

Quote:
Originally Posted by Logit View Post
Wouldnt simply saving the workbook every 10 seconds suffice ? Placing the vba macro into the original workbbok's "ThisWorkbook" module.
The issue is that the current code does not work in a co-shared workbook. Do you have any code that can achieve the following: when a user opens the co-shared Excel workbook, it automatically saves every 10 seconds?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VBA Loop to update formula in certain cells and create copy in new workbook off dynamic range bwosk Excel Programming 1 10-07-2021 10:36 AM
Excel 2010 - Shared Workbook greyed out osheac3*40 Excel 0 03-08-2016 11:40 PM
OneDrive + iPhone Excel: Cannot Update Workbook? markg2 Excel 0 12-07-2014 09:02 AM
Shared Excel workbook eguru2 Excel 0 07-12-2011 12:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft