Error after pasting Macro in Excel

Asked By 0 points N/A Posted on -
qa-featured

Hi all,

Why is it that after I paste a Macro in MS Excel, I always get this error:

Microsoft Visual Basic

Compile error:
Expected: end of statement
 
Have you ever seen this error message? How did you solve this problem?

Thanks again for your help!

SHARE
Best Answer by Scott Douglas
Answered By 0 points N/A #93417

Error after pasting Macro in Excel

qa-featured

Hello,

   Macros are development tools available in Microsoft Excel, they are used to record sequence of actions for a task.

As per viewing your screen shot, it seems like that you have entered a wrong formula for running macro. Please note that when record a macro in excel, it must follow the Syntax of the excel formulas, not the, Visual basic syntax..

Please resend your question with proper screen shot, so i can help you some more in details…

Thanks

Best Answer
Best Answer
Answered By 5 points N/A #93418

Error after pasting Macro in Excel

qa-featured

 

Hi,

You didn’t mention which Microsoft Office package are using. I guess you are having trouble with Office 2000. This can be occurred due to start or quit module mod_voice. Please follow the instructions I have given below.

1.       Go to My Computer and locate the following path

C: Program Files Microsoft Office Office XLStart

2.       In the XLStart folder, select the UT200 and right click on it then select Delete.

3.       Then you need to find a following file. Search on your computer and delete all the files permanently. You can delete files permanently by pressing SHIFT key and the DELETE together.

File name is shown below.

Ut2000.dot

 

Hope this will solve your problem.

 

Related Questions