PDA

View Full Version : Solved: passing object name



Autofreak
03-02-2006, 08:01 AM
Hi X-Perts :hi: ,
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

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


...Q is :think: , 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
03-02-2006, 09:44 AM
serge

Why not pass the actual object?

Autofreak
03-02-2006, 10:06 AM
Yeah,
I got to a similar conclusion, and why not, sounds like the only neat solution so far?

Thanks Norie, :yes
Serge

Autofreak
03-02-2006, 10:34 AM
:help 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
03-02-2006, 10:52 AM
serge

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

Ken Puls
03-02-2006, 11:20 AM
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!