Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and ComDlg32.ocx
Hi,
I put a button on Excel's sheet and open a Common Dialog box. I created and run it well on some PCs with Excel9.0/Excel10.0/Excel11.0. But it failed on one of WindowsXP Pro. SP2/Excel11.0. It said that "Microsoft Common Dialog 6.0 can not be used", though ComDlg32.ocx is there(\Windows\system32). Then, on this special PC, I tried as follows, (1) Open Excel (2) input a controller and choose "Microsoft Common Dialog 6.0" (3) put it on Sheet1 At this time, Excel said "The object can not be inserted". Please help me to solve the problem? Thanks William |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and ComDlg32.ocx
Windows manages access to COMDLG32.OCX very cleverly. Even if it exists, it
may not be used. The version that can be used freely comes with VB6/Visual Studio. ALL the methods in this OCX can be replicated by Windows API calls (available on all PCS) although this means more code. "William" wrote: Hi, I put a button on Excel's sheet and open a Common Dialog box. I created and run it well on some PCs with Excel9.0/Excel10.0/Excel11.0. But it failed on one of WindowsXP Pro. SP2/Excel11.0. It said that "Microsoft Common Dialog 6.0 can not be used", though ComDlg32.ocx is there(\Windows\system32). Then, on this special PC, I tried as follows, (1) Open Excel (2) input a controller and choose "Microsoft Common Dialog 6.0" (3) put it on Sheet1 At this time, Excel said "The object can not be inserted". Please help me to solve the problem? Thanks William |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and ComDlg32.ocx
Thans for the response.
I have tried many PCs without VB/VC installation and it works well. Only one PC has such problem. I don't know why and how to work around it? William Windows manages access to COMDLG32.OCX very cleverly. Even if it exists, it may not be used. The version that can be used freely comes with VB6/Visual Studio. ALL the methods in this OCX can be replicated by Windows API calls (available on all PCS) although this means more code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comdlg32.ocx error | Excel Discussion (Misc queries) | |||
Comdlg32.ocx | Excel Programming |