Can't put common dialog control on a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I can do that on a Windows98 with Office 2000 machine. I put a common dialog
control on a worksheet so that it would be popped up when necessary to allow
user to select a workbook to open. However when I load this Excel workbook on
a Windows 2000 Professional with Office 2000 machine, the common dialog
control on the worksheet was missing. Even though I could register the
comdlg32.ocx successfully via regsvr32 program. I still cannot put the
control on a worksheet, get an error something like ..."cannot insert object"

Please help!
 
application.GetOpenFileName can be executed and provide the file open dialog
and return the fully qualified path of the file the user selected. No need
to involve the comdlg32.ocx.

The code can be run from a button or event using worksheet level events.
 
Thank you very much ... Tom!

Best regards,
KS

Tom Ogilvy said:
application.GetOpenFileName can be executed and provide the file open dialog
and return the fully qualified path of the file the user selected. No need
to involve the comdlg32.ocx.

The code can be run from a button or event using worksheet level events.
Click to expand...
 
Back
Top