General information
Category:
COM/DCOM and OLE Automation
Thanks for the help. I created a new spreadsheet and the code works with your changes but nothing works on the spreadsheet that I need to modify. (The COUNT is always 0 in my main spreadsheet so the FOR...NEXT never occured.) I just realized that it's password protected so that's probably hiding the controls. I'll just work on a new spreadsheet for now until I can contact somebody about getting the password.
Next question:
Do you know how to set/get the values of the controls?
I tried "oWorkSheet.OLEOBJECTS(nObj).VALUE" to get the value of a CheckBox but an "Unknown name" error occurs.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only