Write, Bureaucrats, Administrators
1,171
edits
Difference between revisions of "Unreadable contents error when starting ExcelReportLink"
Jump to navigation
Jump to search
Unreadable contents error when starting ExcelReportLink (view source)
Revision as of 20:14, 17 February 2016
, 20:14, 17 February 2016no edit summary
(Created page with "== Overview == If you ever get '''Unreadable Content in Startup.xlsm''', it most likely is due to have Visual Basic for Application not installed. == How to install VBA == [...") |
|||
| Line 2: | Line 2: | ||
If you ever get '''Unreadable Content in Startup.xlsm''', it most likely is due to have Visual Basic for Application not installed. | If you ever get '''Unreadable Content in Startup.xlsm''', it most likely is due to have Visual Basic for Application not installed. | ||
== How to | == How to confirm if Microsoft Visual Basic for Application is installed == | ||
[[File:VBA installation.png|300px|thumb|right|]] | [[File:VBA installation.png|300px|thumb|right|]] | ||
[[File:VBA installation2.png|300px|thumb|right|]] | [[File:VBA installation2.png|300px|thumb|right|]] | ||
To confirm if Microsoft Visual Basic for Application is installed, follow these steps. | |||
#Start '''Excel''' | #Start '''Excel''' | ||
# Go to '''File \ Options''' | # Go to '''File \ Options''' | ||
# Select ''' | # Select '''Customize Ribbon''' | ||
# Tick the '''Developer ribbon''' | # Tick the '''Developer ribbon''' | ||
# Click ''' | # Click '''OK''' to close the options dialogue | ||
# Select the '''Developer tab''' | # Select the '''Developer tab''' | ||
# Confirm | # Confirm if the Microsoft Visual Basic and Macros buttons are both greyed out. | ||
If the Visual Basic button is greyed out, | If the Visual Basic button is greyed out, Microsoft Visual Basic for application is not installed. You will need to repair/reinstall/modify Microsoft Office to include it as per the images shown. | ||
<br clear=all /> | <br clear=all /> | ||
== Related Topics == | == Related Topics == | ||