Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2016, 07:08 PM
klpw klpw is offline vb code for updating file automatically Windows 7 64bit vb code for updating file automatically Office 2013
Novice
vb code for updating file automatically
 
Join Date: Dec 2015
Posts: 5
klpw is on a distinguished road
Post vb code for updating file automatically


Hi all,

I have code for showing file details in a folder, for instance, the folder name, the file name, revision with its last date modified details. Yet, I would like to update the list automatically when the user removes a file from the folder, adds a file in the folder as well as modifies a file in the folder. May I know how can I achieve this? Can anyone help? Please see attached my code.

Thanks in advance.
Attached Files
File Type: xlsm code.xlsm (21.8 KB, 9 views)
Reply With Quote
  #2  
Old 01-14-2016, 08:05 PM
macropod's Avatar
macropod macropod is offline vb code for updating file automatically Windows 7 64bit vb code for updating file automatically Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Excel doesn't have event-driven capabilities for folder monitoring. What you could do, however, is change the name of your PrintFolders macro to Auto_Open, so it runs automatically every time the workbook is opened.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
vba code

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
vb code for updating file automatically Captions automatically updating all previous entries jhats Word 1 07-29-2014 11:53 PM
vb code for updating file automatically Help with set up of automatically updating cross reference. lukebrown Word VBA 5 09-11-2013 09:38 AM
vb code for updating file automatically Word 2010 Includetext not automatically updating nataliec Word 4 12-13-2012 02:37 PM
vb code for updating file automatically Automatically Updating Content in Text dumbass0101 Word 4 10-11-2012 07:50 AM
vb code for updating file automatically Automatically updating currency exchange rate? Metamag Excel 2 09-07-2012 09:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:24 PM.


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