Can somebody out there help me.
I've written and tested an application that opens a .txt file, processes it in XL to re-order the columns and strip duplicates and saves it as .csv. All works fine on my system which has Microsoft Office 10.0 Object Library.
Problem is when I run it on nother machine which has Microsoft Office 9.0 Object Library I get an object undefined error at my definition line
Dim FileDlg as Office.FileDialog
I have checked that Microsoft Office 9.0 Object Library is ticked in the references dialog for the project.
Looking in more detail when I enter "Office." in my module and look in the pull down list FileDialog is not there.
So I need to look at either alternative code to allow the user to select the source data file, or a way to replace the existing FileDialog object on the older machine.
Any ideas anybody?
I've written and tested an application that opens a .txt file, processes it in XL to re-order the columns and strip duplicates and saves it as .csv. All works fine on my system which has Microsoft Office 10.0 Object Library.
Problem is when I run it on nother machine which has Microsoft Office 9.0 Object Library I get an object undefined error at my definition line
Dim FileDlg as Office.FileDialog
I have checked that Microsoft Office 9.0 Object Library is ticked in the references dialog for the project.
Looking in more detail when I enter "Office." in my module and look in the pull down list FileDialog is not there.
So I need to look at either alternative code to allow the user to select the source data file, or a way to replace the existing FileDialog object on the older machine.
Any ideas anybody?