Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel & Word Intellisense
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00589038
Message ID:
00590573
Views:
28
>>Hi all,
>>
>>I want to be able to have Word & Excel (97) application objects on my AS list (as shown in the What's New in VFP 7 book)... However when I use the Intellisense manager and select the Types tab and Type Libraries button, neither Excel or Word show up on the COM server list (even though I can do a CREATEOBJECT, automate, etc.). After a CREATEOBJECT Intellisense will kick in as expected.
>>
>>In fact many of the Objects exposed through the Visual Studio 6 Object Browser do not show up on the list generated.
>>
>>My machine is using Win98SE.
>>
>>Does the Intellisense manager work differently in Win98?
>>Is this a bug with the Intellisense manager or a feature?
>>
>>
>>Marshal Rosenberg
>
>
>You have to edit the foxcode table to do this. Don't mess up this table, or you will mess up intellisense badly. You may want to back it up first. Anyway, after you have backed it up (or not, your risk) from the command window:
>
>
>use (_foxcode)
>append blank
>
>
>browse to your blank record. Replace:
>
>foxcode.type with "T"
>foxcode.abbrev with "word.app"
>foxcode.data with "Word.Application"
>foxcode.save with .T.
>foxcode.timestamp with DATETIME()
>foxcode.source with "RESERVED
>foxcode.uniqueid with SYS( 2015 )
>
>That should do it for you, for Word anyway, do the same thing for Excel, and whatever else you need. I can't remember what the "T" type means right off my head. The .T. in the save field means that if you run Fox's application for cleaning up intellisense ( can't remember what that is called either, sorry, it's late ), it will leave your changes alone. If you change this to .F. and run it, all your custom stuff will be gone. Good luck,
>jfh

Thanks John for your help.

By the way, I discovered that even though they are not on the AS list out of the box, when you enter a line (in the editor) such as LOCAL loExcel AS Excel.Application or loWord etc. and subsequently reference the object variables, Intellisense automatically kicks in...I suspect some internal Microsoft specfic code at work here.


Marshal
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform