ctcLink Excel Journal Compile Error (Adding a Macro File to Excel)

Note: This article references specific files used for ctcLink Journals, but may still be applicable for other Excel spreadsheets that use .XLAM macro files and exhibit the Problem below. Substitute in your own file names where appropriate. 

 

Table of Contents:

 

The Problem

  1. You are attempting to open the JRNL1_UPLOAD_CTCLink-FSUAT.xlsm Excel spreadsheet with the corresponding JRNLMCRO.xlam macro file.
  2. Upon opening, you receive the following error and the buttons in the spreadsheet do not work: 
    1. Microsoft Visual Basic For Applications: Compile error: Can't find project or library.

 

Back to the Table of Contents.

 

Adding the Macro File to Excel

  1. Open Excel on your computer.
    1. Note: Excel must first be closed.
    2. If you have open spreadsheets, please save and close them and then close Excel. Then Re-Open Excel before completing the below procedure. 
  2. Click the File button at the top left of the menu bar/screen.
  3. Click the Options button at the bottom left of the menu/screen.
  4. Click the Add-Ins button in the Excel Options menu (second from the bottom, left side of the screen).
  5. Click the Go... button at the bottom of the Excel Options menu.
  6. Click the Browse button in the Add-ins menu.
  7. Navigate to where you have saved the JRNLMCRO.xlam macro file.
    1. Select the file and click the OK button.
    2. If you receive a dialog asking to copy the JRNLMCRO.xlam file, click the No button.
  8. Click the OK button on the Add-ins menu to close the menu.
  9. At this point, the JRNLMCRO.xlam macro file should be registering as an Add-in within excel.
    1. You can check this by following steps 1-4 above
    2. The file should be listed at the top of the Add-ins menu, even when closing and reopening excel. 
  10. Open the JRNL1_UPLOAD_CTCLink-FSUAT.xlsm file.
  11. If you receive the yellow Security Warning bar at the top of the spreadsheet, click the Enable Content button.
  12. The spreadsheet opens to the control panel. 
  13. Click the New button to test if the spreadsheet is now working.

 

Back to the Table of Contents.

 

Further issues and Troubleshooting 

The following issues may arise After you complete the above fix. 

 

The buttons produce an application-defined or object-defined error:

  • This error has presented due to
    • Excel spreadsheets being open when completing the procedure
    • or
    • The .xlam macro file did not correctly get added in.

Please save and close all spreadsheets, close excel, (or restart your computer), and complete the procedure again. 

 

 

The buttons do not work and do not even show a clicking animation:

  • If you are using a laptop on a docking station: Try disconnecting your laptop from your docking station and open the spreadsheet again.
  • If you are using Windows 10 desktop scaling at greater than 100%: Try setting desktop calling down to 100% and open the spreadsheet again.
  • If the above fail, there is an unknown issue with your machine. Please contact the help desk to:
    • Have Windows reinstalled on your computer.
    • or
    • Get a laptop or Virtual Machine to perform this function.

 

Back to the Table of Contents.

Details

Article ID: 137879
Created
Fri 9/17/21 8:48 AM
Modified
Fri 9/17/21 11:38 AM