MS Word Error Running a Macro

Asked By Norman L Trent 0 points N/A Posted on - 10/16/2013

Hi,

I have Microsoft Office 2010 installed. I wanted to run a macro from Word and I got the error message shown below?

Please help me with an idea of what could be causing this error and how to solve it?

Run time error 5342

The specified data type is unavailable

• Status: Open
• Question Views: 1082
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Word

Best Answer by Danny Ion

Go To Solution

Answered By Ioon Darn 0 points N/A #176479

MS Word Error Running a Macro

This particular error usually occurs when a .dll file is missing or unregistered. To fix this, try completing the following steps:

1. Open the Run prompt from the start menu.

2. Enter the following command: regsvr32 c:windowssystem32dllfile

3. Reboot your computer.

Another option is to download a registry scan tool and run it. You can get one from https://www.techyv.com/, for example.

 

About Ioon Darn

Questions
0

Answers
66

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 10/16/2013
• Question Category: MS Word

Best Answer

Best Answer

Answered By Danny Ion 0 points N/A #176480

MS Word Error Running a Macro

Hi,

 

The error is generated when you try to paste an image using Paste Special macro which clear all kinds of formatting while pasting content in Word document.

 

To get around this problem, you need to modify you macro so that if the macro encounter any problem in pasting unformatted text, it should go ahead and complete the paste action using normal paste action. you need to include following sub-routine in your macro

 

 Sub PasteUnformattedText()

    On Error GoTo errHandler

 

    Selection.PasteSpecial DataType:=wdPasteText

    Exit Sub

  

  errHandler:

    Selection.Paste

  End Sub

 

 

About Danny Ion

Questions
0

Answers
23

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/16/2013
• Question Category: MS Word