Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
View open excel workbooks by multiple running Excel applications
- Thread starter wbl
- Start date
With great difficulty. Very easy if all in the same session....
For each wb in application.workbooks
msgbox wb.name
next
For multiple sessions, you'll need an API call to find the other excel sessions. Personally, I'd beat the users around the head until they learn to just use 1 session of an app....;-)
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
For each wb in application.workbooks
msgbox wb.name
next
For multiple sessions, you'll need an API call to find the other excel sessions. Personally, I'd beat the users around the head until they learn to just use 1 session of an app....;-)
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Thread starter
- #3
May I ask why multiple sessions are running....is there a good reason in other words ???
In all seriousness - if there is no particular reason then it would be good - not just for this project - for the users to learn that running multiple sessions of apps is not good practice...
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
In all seriousness - if there is no particular reason then it would be good - not just for this project - for the users to learn that running multiple sessions of apps is not good practice...
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Thread starter
- #5
Hi,
I've made a simple application in Excel that list all open documents or files.
With this program users can simply save one or more open files to a selected directory (so it is not neccessary for them to browse in our datastructure).
This excel application is shared on the network, so users started this program when they are finished with their own excel, word or other files.
This is the reason that there are more running excel applications.
Regards,
wim
I've made a simple application in Excel that list all open documents or files.
With this program users can simply save one or more open files to a selected directory (so it is not neccessary for them to browse in our datastructure).
This excel application is shared on the network, so users started this program when they are finished with their own excel, word or other files.
This is the reason that there are more running excel applications.
Regards,
wim
Well, I ain't much cop on API calls but this site may have some help for you - I'm pretty sure this can't be done with native excel functionality.
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
- Status
Similar threads
- Locked
- Solved
- Locked
- Question
- Locked
- Question
