Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 05-29-2017, 10:43 AM
OfficeAssociate99 OfficeAssociate99 is offline VBA to automatically pull data from other excel documents Windows 7 64bit VBA to automatically pull data from other excel documents Office 2010 64bit
Novice
VBA to automatically pull data from other excel documents
 
Join Date: May 2017
Posts: 19
OfficeAssociate99 is on a distinguished road
Default

Quote:
Originally Posted by BobBridges View Post
I do this fairly often, and have developed some regular functions and classes to help. The general idea is that I use the FileSystemObject to run through all the files in a folder, and a Regular-Expression object to determine which filenames match the desired pattern. Does that tell you what you need to now, or do you need more information on one or both?
I have a little bit better of an idea. I'm more or less doing this from scratch, as I have limited working knowledge of VBA and coding related to that. Any additional details on either of items you mentioned would be great.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to automatically pull data from other excel documents Using Excel data to automatically make Word documents Vincent Mail Merge 9 01-04-2021 03:05 PM
Pull data from Excel to Powerpoint (not dynamically) Terri11130 PowerPoint 1 08-25-2015 12:17 PM
How to get project to automatically pull in task dates? Moe Szylak Project 2 04-26-2012 12:37 PM
Excel VBA: Pull data from web tinfanide Excel Programming 0 12-09-2011 02:11 AM
VBA to automatically pull data from other excel documents Old Excel Document folder automatically created in My Documents slickcondo Office 6 07-13-2011 02:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:37 AM.


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