Solved

i am running excel macro and i receiving the attach error

Posted on 2014-10-23
5
115 Views
Last Modified: 2014-11-03
in the debug it failing on the following line:
ThisWorkbook.Worksheets("Sheet1").Range("A1").PasteSpecial Paste:=xlPasteAll ', Paste:=xlPasteComments
its happen only for specific user and for other login users who running a copy of this file the error is not happen

please advice
Thanks
Gvilbis
excel-run-time-error.JPG
0
Comment
Question by:gvilbis
  • 2
  • 2
5 Comments
 
LVL 35

Assisted Solution

by:Kimputer
Kimputer earned 250 total points
ID: 40399017
Strange error, no solution.
Only one piece of advice, try to update your attachment (remove IP numbers visible)
Incidentally, I also use the same port number for that purpose :)
0
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 250 total points
ID: 40399027
Would the same error arise if you use Paste, instead of PasteSpecial?
0
 

Author Comment

by:gvilbis
ID: 40399082
i just run it on diffrent user and its running OK
but for specific user i am getting this error
0
 
LVL 24

Assisted Solution

by:Phillip Burton
Phillip Burton earned 250 total points
ID: 40399096
My best guess then: There is a problem with the installation of Excel or Windows on that computer, something which affects the clipboard.

I would suggest a detect and repair on MS Office.
0
 
LVL 35

Accepted Solution

by:
Kimputer earned 250 total points
ID: 40399111
Is the code based on more excel files? (Copy something from one excel file to another)
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now