Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Strange Clipboard Response

Status
Not open for further replies.

johnmtb

Programmer
Jul 12, 2008
37
US
i cannot understand what is happening, and i need to solve the problem.

the following snippet of code is used six times in the programme

Code:
ExcelFile.Worksheets("Calculations").Range(CellAdres).Activate
Clipboard.Clear
ExcelFile.Worksheets("Calculations").Range(CellAdres).Copy
WordObj.ActiveDocument.Tables(i).Rows(j).Cells(k).Range.Paste

the programme may run once, or even twice, successfully, but at some time it hangs and advises:

"This method or property is not available because the clipboard is empty or not valid"

using the debugger i know this happens in different parts of the programme, but always in the above snippet.

the curious thing is that it only happens on my desktop in my office, not on my laptop.

can anyone help me please?

john
 
RonRepp,

the office version is Excel 2003 11.5612.5606

my version is Excel 2003 11.5612.6360.

but before i changed this programme from VBA to VB 6.0, it was working for a long time without any problems.

any ideas?

regards,

john
 
i have additional information for everyone:

I was asked the question whether there was something on my work computer that was causing the problem, or was it the version of Excel.

I have now discovered that:

the version on my office computer is Excel 2003 11.5612.5606

the version on my Personal Laptop is Excel 2003 11.5612.6360.

the version on the office computer of one of my assistants is Excel 2003 11.5612.5606

the version on the office computer of another of my assistants is Excel 2003 11.8146.8132

so far the only machine that gives the clipboard error is my office machine.

any ideas on what could be causing this?

Regards,

john
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top