R
Reggie
Hello,
I have an OWC11.Spreadsheet spreadsheet control embedded in a userform
in my Access project. I'm having trouble getting a handle to
spreadsheet control so that I can manipulate it. I've been trying the
following piece of code with no success:
Dim sprdSheet As OWC11.Spreadsheet
Dim wrkSheet As OWC11.Worksheet
Set sprdSheet = Me.sprdLeaveTracker
Unfortunately, trying to set the sprdSheet to the control gives me a
"Type Mismatch" errors. I've had success using the OWC9 spreadsheet
control, but this one is throwing me for a loop. Does anybody have any
idea how to use this thing?
I have an OWC11.Spreadsheet spreadsheet control embedded in a userform
in my Access project. I'm having trouble getting a handle to
spreadsheet control so that I can manipulate it. I've been trying the
following piece of code with no success:
Dim sprdSheet As OWC11.Spreadsheet
Dim wrkSheet As OWC11.Worksheet
Set sprdSheet = Me.sprdLeaveTracker
Unfortunately, trying to set the sprdSheet to the control gives me a
"Type Mismatch" errors. I've had success using the OWC9 spreadsheet
control, but this one is throwing me for a loop. Does anybody have any
idea how to use this thing?