Spreadsheet Control 11.0 - data in

[vegasfoster]

Hi, so I just want populate some cells in a spreadsheet control box on my userform from data in the associated worksheet. I found sample code to get the data out,

Private Sub PasteButton_Click()

ActiveCell.Value = Spreadsheet1.Range("B5")

Unload Me

End Sub

But can't find an example to get data in. I've tried numerous things like

Private Sub Spreadsheet1_Initialize()

Spreadsheet1.Range("A1") = Worksheets("Input").Range("Date")

End Sub

but no joy. I don't get any errors, but nothing happens.

I'm clearly not searching for the right thing.

Thanks for any help.

 

[vegasfoster]

I was not aware of the Spreadsheet Control 11.0 until you mentioned it. Did a little research and apparently it is something discontinued from ver. 2003 ?

Would you be willing to share your final product so I can see what it is and how it functions in real life ? The few articles I found on the Net made it sound
very interesting.

Thanks.

Well poo, looked into it and the control is not available on most of the computers I want to use it on. Open the toolbox and then click on Tools>>Additional Controls>>Microsoft Office Spreadsheet 11.0. If you can't find it, then you don't have it. Confusing to me, but apparently something to do with 64bit and 32bit. If you have it, you can add spreadsheets from the toolbox, which are very intuitive to use, just right click for options. Then use the above code to get data in and out.

So, ended up using a poorly formatted listbox. Not understanding why they got rid of it, nice tool IMO.

 

[Logit]

Thank you for the update. I've read a few articles about the control and found a project download.
I haven't had any luck getting it to go.

I'll keep snooping around to see what happens.

Thanks.

 

[vegasfoster]

Thank you for the update. I've read a few articles about the control and found a project download.
I haven't had any luck getting it to go.

I'll keep snooping around to see what happens.

Thanks.

Posts 4 and 5 offer a couple things to try if you haven't already.

https://forums.techguy.org/threads/what-happened-to-activex-spreadsheet-control.1118588/

What I don't understand, is many people saying it died with 2003, but I am using 2007 and it's there. Wondering if maybe because I am using upgrade version of excel 2007 on office 2003.

 

[Logit]

Thanks !