Cannot save VBA library references

[Cheesecube]

Hi, I am opening a macro workbook on another computer.

I activate the various libraries under Tools > References, then save the VBA and the workbook.

When I close the document and reopen it, all these references are gone.

Cannot save the VBA library references with the workbook.

How do I troubleshoot and solve this issue?

[Marc L]

Hi !

Same issue with another workbook ? Try to save as a new name and checking the workbook type (binary or macro) …

[dangelor]

You can use VBA to add reference libraries, but you need to know the full path and filename of the library. Such as...

Please Login or Register  to view this content.

[CK76]

This part...

..on another computer.

Can it be that you don't have the same libraries installed on both computers?

[Cheesecube]

This part...


Can it be that you don't have the same libraries installed on both computers?

The libraries are clearly installed on both computers therefore I am able to tick the checkboxes on the relevant libraries. Just that when I save, close and open the workbook again, the references are gone

[CK76]

Do you have any code saved in the workbook?
If not add some dummy code like Debug.Print “sometext”. And save workbook.
Without code project will not be saved with workbook and all references will be lost.

[Norie]

Are you adding any code to the workbook?

Are you saving it as macro-enabled/binary?

[Cheesecube]

There's definitely code in the workbook and it is definitely .xlsm format

[rorya]

Where are you opening the workbook from?

[Cheesecube]

I am able to save the workbook with references and open it without issues from Windows Explorer on one computer..

somehow when I do the same on another computer, the references are gone every time i reopen the file

[rorya]

Is this true for all workbooks? Also, are you saving the workbook through the main Excel window or the save button in the VBE? The latter is notoriously fickle.

[Marc L]

As we are expecting OP answers since post #2 …

[Cheesecube]

Hi, solved it... apparently there was a reference to MS Word 16.0 and I checked version 15.0 as well, so due to the conflict it wasn't saved when I closed and opened the file