Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OLE Dispatch error
Message
De
20/09/2006 10:54:27
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Titre:
OLE Dispatch error
Versions des environnements
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01155551
Message ID:
01155551
Vues:
76
It never rains but it pours. As you may have noticed from recent post, I'm pretty new to this Excel automation lark. However, I do have some code that's been working fine for me. I've built my exe and it works fine as well as from VFP -on MY m/c

Now when my users invoke the exe and run this code:
EXPORT TO &lcFilePath TYPE XL5
loExcel = CREATEOBJECT([Excel.Application])
With loExcel
  .Workbooks.Open( lcFilePath) 
  If not thisform.lCustom		&& If chose non-custom, formatted o/p (default)
    With .ActiveWindow
      .DisplayZeros	= .F.
      .Width		= 1124       && <---------------- THIS THE OFFENDING LINE
      .Height 	= 645
   EndWith 
  With .ActiveSheet
    ...
my error routine reports:

OLE dispatch error 1479 at line 30 of ...., line of code = .

The actual line is:

.Width = 1124

but the routine says "."

What gives here?????

Of course Help tells me zip.

I suspected that it might be because Excel was already open on their m/cs, so closed it, but no difference.

'ppreciate it.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform