Search results

OK, you can use References.AddFromFile Filename:="C:\Program Files\Microsoft Office 2007\Office12\EXCEL.EXE" But what if you do not know the version or the location of excel on the other computer?

If you don't care about the message you could use DoCmd.SetWarnings false, the built-in message will not be shown. At the end of the code you have to type docmd.set warnings true to turn them on again.

In the VBA editor you can go to Tools-References and add a reference to, for instance, the Excel library. However, if you open your file on a computer with a different version of Excel, you will see that some libraries are missing and the one you need is not in the list. Can you solve this...