Screen Updating - Multiple Documents

[aap21956]

Hi,

This is the situation: I have two spreadsheet documents open at the same time, and I need to work with both in the same macro. In order to reference each document, I use "loadcomponentfromurl with "_default" as the target frame

However, even with lockcontrollers enabled, when I execute the code, the screen does show the application switching between the two documents. Is there a way to lockcontrollers for StarDesktop as a whole? Does someone know of a different way to reference a spreadsheet document that is not the current component without having the GUI switch to it? Is there an indirect way to reference a spreadsheet document via OOoBasic?

Thanks

[probe1]

Welcome to the forum.
Do a search here in forum for "hidden"

http://www.oooforum.org/forum/viewtopic.phtml?t=9158
or
http://www.oooforum.org/forum/viewtopic.phtml?t=36652
as starters.

Good luck!
_________________
Cheers
Winfried
My Macros
DateTime2 extension: insert date, time or timestamp, formatted to your needs