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
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