VBA for Every 15 min workbook will open and save data and close (for external links update

**rajeshn_in** · 04-02-2017, 05:31 PM

Hi friends,

I have some files in Google Drive, So that I want in every 15 min. file open in "Application.ScreenUpdating = False" mode and save file and close.
This is a helper file, so that no need to open, it will automatically open and update links and save and close. Edit links auto updated options SELECTED.

**gmr4evr1** · 04-02-2017, 06:20 PM

I'm not sure you can have a workbook open automatically with VBA. In order for the VBA code to run, the workbook has to be open already.

**Logit** · 04-02-2017, 06:52 PM

You could use Windows Scheduler to open the file for you. Then VBA to close it.

I've never used Scheduler but I'm presuming (maybe in error) that it can be configured to function every
15 minutes.

Otherwise, I agree with gmr4evr1 ... the workbook would need to be open all the time.

VBA for Every 15 min workbook will open and save data and close (for external links update

LinkBack

Thread Tools

Rate This Thread

Display

VBA for Every 15 min workbook will open and save data and close (for external links update

Re: VBA for Every 15 min workbook will open and save data and close (for external links up

Re: VBA for Every 15 min workbook will open and save data and close (for external links up

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Automatically open a workbook and update external links

Excel VBA to open PowerPoint Update Links, Save and Close Powerpoint with a new file name

Macro to open, update links, save then close all files in sub folders

[SOLVED] Open External File, Write Data, Save and Close without prompt.

Possible to have a shared workbook update external data links?

Macro that will open another workbook, update the links, and close it

[SOLVED] Links only update when external workbook is open

Bookmarks

Bookmarks

Posting Permissions