hello.
i have come pretty much to the end of my project but encountered a problem when running it on a different machine.
My computer is set up in English with English Excel, but my co-workers have German versions of windows and Excel.
The little application ( i konw its technically a macro) that i have written works fine on my machine but not on the german ones ,there is a problem with one line which causes an error (Runtime Error '-2147417848(80010108)') which causes a program failure and it exits Excel.
this is where the error occurs
i have come pretty much to the end of my project but encountered a problem when running it on a different machine.
My computer is set up in English with English Excel, but my co-workers have German versions of windows and Excel.
The little application ( i konw its technically a macro) that i have written works fine on my machine but not on the german ones ,there is a problem with one line which causes an error (Runtime Error '-2147417848(80010108)') which causes a program failure and it exits Excel.
this is where the error occurs
Code:
Public Sub AddInCode()
Dim FName As String
FileVersion = "Calculator7.21_Ger2.xls"
With Workbooks(FileVersion)
FName = .Path & "\code.txt"
.VBProject.VBComponents("basMenuChange").Export FName
End With
Workbooks(FileX).VBProject.VBComponents.Import FName
End Sub
[\code]
the error occurs on the Import line. It knows what FileX and FName are, and the export part works perfectly, and everything after the import works fine if the line is commented out so i dotn know what is happening.
i would really appreciate any suggestions
Help !!!
Ava