Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-27-2018, 01:00 PM
Stephen Ray Stephen Ray is offline After A Reinstall of Office, My Macros Get Multiple Errors Windows 10 After A Reinstall of Office, My Macros Get Multiple Errors Office 2016
Advanced Beginner
After A Reinstall of Office, My Macros Get Multiple Errors
 
Join Date: Sep 2018
Location: Kansas
Posts: 34
Stephen Ray is on a distinguished road
Default After A Reinstall of Office, My Macros Get Multiple Errors

My friends,
I am suddenly getting many errors when I run my Macros. All my Macros used to work very well. I believe it is because my computer got a newer Microsoft Office 2016, but I cannot be certain because I don’t know what version I had before.
But I do know they had to reinstall Microsoft Office on my computer.
So, I had to paste all my Macros back in, I religiously keep backups in several different places. And it was sure a pain to make the Key Assignments again, about 50.
The first thing I thought of is some file that must be installed/clicked/enabled initially to make Macros/VBA work, MSForms?? I have a dim memory of that, but I forgot what it is or how to do it.
Thank you very much for any advice.
I will explain the errors:

Microsoft Visual Basic
Run-time error ‘424’:
Object required
And then, one line is highlighted in yellow:


Clipboard.SetText “John Doe” (only this line is highlighted in yellow)
Clipboard.PutInClipboard

Another Error:
Microsoft Visual Basic for Applications
Compile error:
User-defined type not defined

And then, one line is highlighted in blue:
Dim strTemp As String
Dim myData As DataObject (only this line is highlighted in blue)
Set mydata = New DataObject


Another Error:
Microsoft Visual Baic for Applications
Compile error:
User-defined type not defined

And then, one line is highlighted in blue:
'This part clears the clipboard
Dim clipboard As MSForms.DataObject (only this line is highlighted in blue)
Set clipboard = New MSForms.DataObject
clipboard.SetText ""
clipboard.PutInClipboard
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2010 reinstall not working gossamer Office 0 06-14-2018 01:19 PM
After A Reinstall of Office, My Macros Get Multiple Errors How Many Times Can I Reinstall Microsoft Office Margaret Office 2 05-23-2018 03:41 PM
After A Reinstall of Office, My Macros Get Multiple Errors Reinstall Office 2003 visaar123 Office 1 02-24-2016 03:33 AM
After A Reinstall of Office, My Macros Get Multiple Errors Reinstall Office without a disc TJH Office 1 03-24-2014 08:08 PM
cant reinstall office 2000 Sword Office 0 06-11-2006 02:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:27 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