Lampshade14
New Member
- Joined
- Jul 19, 2011
- Messages
- 1
Hi all, i've read your forums a lot in the past, never had to post since the answer is uaually already here. You guys have taught me lots, thanks for your knowledge already.
So here's my problem. I have an excel sheet that's saved on a network drive and used on 20+ comptuers(Win XP SP3/Excel2003). There is one master sheet that is copied and opened using a command prompt script. On 2 of the computers, excel fails to load any OLEObjects(Combobox's and CommandButton's). I have a workbook open routine that does not compile because the "Method or Data Member Does not exist". This is happening when setting the listfillrange for a combobox. If i block out that part of code, it will run the full workbook open routine, then fail the next time any OLEObject is referenced in code. The Objects are visable on the sheet, however they can not be selected in any way.
I have other sheets that use shapes with assigned macro's, these work correctly. Any sheets with OLEObjects in VBA code has issues, i just created a sheet that has a combobox named CBTEST, and the workbook open routine of:
This failed on a compile error as well.
Here's what i've tried:
Reinstall excel
Save sheet to local computer(see if network drive issue)
run office repair
Remove workbook open routine to let sheet load
Have excel open before opening sheet
Replaced a computer that had this issue last week(This Worked!)
Any idea's or suggestions would be great, thanks in advance.
So here's my problem. I have an excel sheet that's saved on a network drive and used on 20+ comptuers(Win XP SP3/Excel2003). There is one master sheet that is copied and opened using a command prompt script. On 2 of the computers, excel fails to load any OLEObjects(Combobox's and CommandButton's). I have a workbook open routine that does not compile because the "Method or Data Member Does not exist". This is happening when setting the listfillrange for a combobox. If i block out that part of code, it will run the full workbook open routine, then fail the next time any OLEObject is referenced in code. The Objects are visable on the sheet, however they can not be selected in any way.
I have other sheets that use shapes with assigned macro's, these work correctly. Any sheets with OLEObjects in VBA code has issues, i just created a sheet that has a combobox named CBTEST, and the workbook open routine of:
Code:
Private Sub Workbook_Open()
Sheet1.CBTEST.ListFillRange = "K1:K26"
End Sub
This failed on a compile error as well.
Here's what i've tried:
Reinstall excel
Save sheet to local computer(see if network drive issue)
run office repair
Remove workbook open routine to let sheet load
Have excel open before opening sheet
Replaced a computer that had this issue last week(This Worked!)
Any idea's or suggestions would be great, thanks in advance.