•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 456,428 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,614 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 3781 | Replies: 1
 |
•
•
Join Date: Jul 2004
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Greetings!
I currently have 5 very similar but seperate macros in 5 seperate .xls files. As one finishes I currently open the next .xls file and run that respective macro. And so on and so forth.
I am attempting to figure out how I can write code that will require me to only manually run the first macro to complete the first file and then somehow either access or open the next file and run the next macro in the series automatically. And so on and so forth.
To complicate matters slightly, each of the .xls files currently is refreshed by an external database query that is automatically executed when the file is first opened.
Any ideas?
Walt
I currently have 5 very similar but seperate macros in 5 seperate .xls files. As one finishes I currently open the next .xls file and run that respective macro. And so on and so forth.
I am attempting to figure out how I can write code that will require me to only manually run the first macro to complete the first file and then somehow either access or open the next file and run the next macro in the series automatically. And so on and so forth.
To complicate matters slightly, each of the .xls files currently is refreshed by an external database query that is automatically executed when the file is first opened.
Any ideas?
Walt
•
•
Join Date: Jul 2004
Location: Adelaide, Australia
Posts: 191
Reputation:
Rep Power: 5
Solved Threads: 1
Junior Poster
Mark Nemtsas
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
Time and Billing Software - Time Tracking Software - Roller Shutters - Roller Blinds -
Baby Books
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
apple cocoa commercial computer dell development drivers enterprise firefox fix framework games graphics hidden files how ibm intel internet java linux microsoft microsystems mozilla news next open open source open-source opengl openoffice operating profits programming red hat rhel server software solve source step sun super system ubuntu video virus vista wesnoth windows xp
- Internet Options won't open (Viruses, Spyware and other Nasties)
- Accessing files form me to xp home network (Networking Hardware Configuration)
- Viruses,trojans malicious files ,please help (Viruses, Spyware and other Nasties)
- Cursor Freezing When Accessing Images (Windows NT / 2000 / XP / 2003)
- IE won't open *local* PHP files anymore! (Web Browsers)
- can't open web pages in new IE window (Viruses, Spyware and other Nasties)
- IE6 won't open links: Hijack This Log (Viruses, Spyware and other Nasties)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Dhtml
- Next Thread: What is a Sequence
