Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-08-2025, 09:41 AM
Dr. Rick Dr. Rick is offline macro to backup my VBA/macro text Windows 10 macro to backup my VBA/macro text Office 2010
Advanced Beginner
macro to backup my VBA/macro text
 
Join Date: Apr 2023
Location: Coastal N.C.
Posts: 42
Dr. Rick is on a distinguished road
Default

It stopped immediately on the first line of code:

Dim vbProj As VBProject 'needs reference to Microsoft Visual Basic for Applications Extensibility 5.3

But your note seems to anticipate this very error. I don't know what "needs reference.. Extensibility 5.3" means.


I may be even more of a "novice" than my label would indicate.


RJ

Last edited by Dr. Rick; 02-08-2025 at 09:46 AM. Reason: clarity
Reply With Quote
  #2  
Old 02-08-2025, 01:06 PM
Italophile Italophile is offline macro to backup my VBA/macro text Windows 11 macro to backup my VBA/macro text Office 2021
Expert
 
Join Date: Mar 2022
Posts: 555
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

Quote:
Originally Posted by Dr. Rick View Post
I don't know what "needs reference.. Extensibility 5.3" means.
To add a reference:
  1. Open the Visual Basic Editor.
  2. Ensure that the project you want to add the reference to is selected in the Project Explorer.
  3. Go to the Tools menu and click on References.
    Screenshot 2025-02-08 195801.png
  4. In the dialog scroll down the list of Available References until you find the one you need, and check the box next to it.
    Screenshot 2025-02-08 195900.png
  5. Click OK
Reply With Quote
Reply

Tags
backup/macros, vba save



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word macro to cut a range of text and apply to subsequent text as a hyperlink scientist101 Word VBA 9 07-20-2020 04:57 PM
Macro to add title in header is missing text once macro is run shawnee24 Excel Programming 1 05-27-2015 11:50 PM
Macro to add title in header is missing text once macro is run shawnee24 Word VBA 3 05-27-2015 12:35 PM
Microsoft Word macro to find text, select all text between brackets, and delete helal1990 Word VBA 4 02-05-2015 03:52 PM
Macro to find coloured text and replace with form-field/formtext containing that text tarktran Word VBA 1 11-26-2014 08:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft