Solved: passing object name

[Autofreak]

Hi X-Perts ,
I have the following broblem to solve. There is a set of OWC spreadsheets on a MultiPage, one spreadsheet on each page. I need to be able to set up a spreadsheet object depending on MultiPage page selected.

eg.
I select page #3 that holds object Spreadsheet3

I would like to proceed like following
[vba]
dim my_Sheet as OWC.Spreadsheet
set my_Sheet = Me.Spreadsheet3

With Me.Spreadsheet3
.ActiveSheet.Cells(1,1).Value = "U gotta see this message now"
End With
[/vba]

...Q is , if I pass the spreadsheet name like a string, say "Spreadsheet3", how do I get it to be recognized as an object's name?

Regards ,
serge

[Norie]

serge

Why not pass the actual object?

[Autofreak]

Yeah,
I got to a similar conclusion, and why not, sounds like the only neat solution so far?

Thanks Norie,
Serge

[Autofreak]

Can anybody tell me what I am supposed to do with the threads that I consider to have been answered. I noticed that some people post "Solved" in front of the original title, does that mean they are satisfied with the replies and hence are closing the post. How do I edit the title then??

Thanks,
serge

[Norie]

serge

I think you mark a thread solved using Thread Tools at the top of the page.

[Ken Puls]

Hi Serge,

We're still in a board upgrade, so the "Mark Thead Solved" function in the Thread Tools is not working. I'll edit the post title for you.

Cheers!