-
Solver VBA reference in non-english Excel
I need to add VBA reference to solver programmatically when the user opens the Excel-file (Excel 2010 is used). For that I use:
[vba]ThisWorkbook.VBProject.References.AddFromFile Application.LibraryPath _
& Application.PathSeparator & "SOLVER" & Application.PathSeparator & "SOLVER.XLAM"[/vba]
What if the user doesn't have english version of Excel installed but some other languague? Will the above code fail, i.e. the SOLVER dll-file is not "SOLVER.XLAM" but something else?
One of my users is getting "Compile error in hidden module"-error and I suspect that this line causes it.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules