View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William[_7_] William[_7_] is offline
external usenet poster
 
Posts: 2
Default 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