VBA String functions not working

Question

Tried using a macro (was working last time I tried about a year ago), and it failed to work because of several string related functions.

Both Space() and Format() functions gave me "Can't find project or library" errors. Checking References, there is: MISSING: Microsoft Office.NET Private Object Library"

I'm not sure how to either add this library back, or if there is a different library I should select that has current versions of these functions.

Thanks,

Answer 1

Solved - I just removed the checkbox in missing reference and the code now works.