I know this is a thread that has been posted before but after looking at them, non of the solutions have made any difference.
I am using the common dialog box active x control in a form. It worked fine for my PC and another PC (which both have VB6 loaded) but on all other PC's I get the 'Error 429 - ActiveX component can't create object'. I have copied over the comdlg32.ocx file to stop errors occuring when other users open the database (without trying to run the active X control) but still get the error on other PC's when they try and open the control. Code breaks as follows:
Private Sub btnFileImport_Click()
Dim comDialog As Object
Dim strPathAndFileName As String
Dim FileName As String
Set comDialog = CreateObject("MSComDlg.CommonDialog"
comDialog.DialogTitle = "Select File"
comDialog.filter = "Text Files (*.csv)|*.csv" '
comDialog.ShowOpen
.....code to do file import stuff.
Pulling my hair out on this one.
Any help greatley appreciated.
I am using the common dialog box active x control in a form. It worked fine for my PC and another PC (which both have VB6 loaded) but on all other PC's I get the 'Error 429 - ActiveX component can't create object'. I have copied over the comdlg32.ocx file to stop errors occuring when other users open the database (without trying to run the active X control) but still get the error on other PC's when they try and open the control. Code breaks as follows:
Private Sub btnFileImport_Click()
Dim comDialog As Object
Dim strPathAndFileName As String
Dim FileName As String
Set comDialog = CreateObject("MSComDlg.CommonDialog"
comDialog.DialogTitle = "Select File"
comDialog.filter = "Text Files (*.csv)|*.csv" '
comDialog.ShowOpen
.....code to do file import stuff.
Pulling my hair out on this one.
Any help greatley appreciated.