Ho to update a label from a userform within a macro in a different Workbook?

[holditall]

Dear all,

I am trying to do a simple thing, namely updating a label like:


ProgressReport.Label12 = "Finished!"

This works fine as long as it is called from a macro within the same workbook. When I am doing it from another workbook it
get me an 424 Object required error, presumably because Excel does not know where the form is (even if it is already activated).

but neither:

Workbooks(" bbbb ").ProgressReport.Label12 = "Finished!"
Worksheets(" bbbb ").ProgressReport.Label12 = "Finished!"
Windows(" bbbb ").ProgressReport.Label12 = "Finished!"

etc. does work. Any ideas?

Thanks a lot!

Axel

 

[mrod79]

i could be wrong. but there arn't suppose to be spaces at the workbook name line.
Should be
Workbooks("bbbb").ProgressReport.Label12 = "Finished!"

 

[holditall]

BBB was just an example.. there are no spaces.

 

[mrod79]

Are the both workbooks open when the script is called?

If so, add the line below to your script:

Windows("WORKBOOK NAME HERE.xls").Activate

 

[holditall]

This does not help.

I can indeed even change my userform when a another Window is open as long it is done by a macro within that workbook. It is just that I can not call the label since the code is in another Workbooks Module.

Axel
\