![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office 2010 reinstall not working | gossamer | Office | 0 | 06-14-2018 01:19 PM |
![]() |
Margaret | Office | 2 | 05-23-2018 03:41 PM |
![]() |
visaar123 | Office | 1 | 02-24-2016 03:33 AM |
![]() |
TJH | Office | 1 | 03-24-2014 08:08 PM |
cant reinstall office 2000 | Sword | Office | 0 | 06-11-2006 02:06 AM |