Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel clears out clipboard
Message
 
To
17/10/2007 12:26:04
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01261553
Message ID:
01261557
Views:
12
Have no Excel installed on my computer to check it, but is there any Option in Excel, something like "Clear Clipboard at Startup"?


>Has anyone seen this before? I had a piece of code like:
>
>
>LOCAL ox,lnDefault,lcData
>TEXT TO m.lcData Noshow
>h1,h2,h3,h4,h5
>p1,1,2,3,4
>p2,1,2,3,4
>ENDTEXT
>_cliptext = CHRTRAN(m.lcData,',',CHR(9))
>
>  *** set the LOCALEID to English
>  nlLocaleId=sys(3004)		&& Save local id
>  =sys(3006,1033)
>  ox = CREATEOBJECT('Excel.Application')
>  WITH ox
>    .WorkBooks.Add
>	    With .ActiveWorkBook.ActiveSheet
>	      .Range('A1').PasteSpecial
>* ...
>
>This application has been working for many years w/o any errors on hundreths of sites so far.
>Yesterday I got a support request with error message attached:
>"Unable to get PasteSpecial property of the range class"
>
>Few hours ago I connected to the site to see it there (happens on a single computer). I discovered I could reproduce it:
>
>-Open notepad (no excel is running)
>-Type blah blah and copy
>-Paste to verify there is something copied
>-Open excel
>-Clipboard data is lost (Edit\Paste is disabled, Ctrl+V doesn't do anything)
>
>I was lucky that I could show them this happens w/o my application running.
>Thinking of faulty hardware,virus,faulty excel installation and alike.
>
>If you ever have seen this and know why happens I'd appreciate.
>PS: XlStart is empty, no startup macro I could find.
>TIA
>Cetin
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform