Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel clears out clipboard
Message
De
17/10/2007 12:26:04
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Titre:
Excel clears out clipboard
Versions des environnements
OS:
Windows XP SP2
Divers
Thread ID:
01261553
Message ID:
01261553
Vues:
60
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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform