Office XP PIA's

Question

I’m trying to make my application update an excel sheet but I’m having trouble closing excel afterwards. I found this explanation http://www.xtremevbtalk.com/showthread.php?t=160433 which I think will solve the problem – however, my Visual Studio 2008 version will not recognize MARSHAL – it doesn’t bring up any intelli-sense etc.

 

I believe it’s because I haven’t installed the Office XP PIA’s from http://www.microsoft.com/downloads/details.aspx?familyid=C41BD61E-3060-4F71-A6B4-01FEBA508E52&displaylang=en

 

Can anyone confirm if this is correct?

 

If so, when I download the update where do I save the files?

 

Many thanks

John

Answer 1

Your question is off-topic here. Try post your question in a office development forum.

---

Return to the source, learn the way!

Answer 2

Hello John,

Your question is about Office extensibility development. The right place should be the Office Automation Newsgroup,
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.office.developer.automation&cat=en_US_edd5c8cb-2460-4373-a729-fd2e9a1cc9f1&lang=en&cr=US

As to the problem itself, based on my understanding, the answer is no. The problem is not related to the Office XP PIA. The Marshal class is in the System.Runtime.InteropService namespace. So, you need to import this namespace, otherwise the Marshal class will not be recognized.
C#
using System.Runtime.InteropService;
VB.NET
Import System.Runtime.InteropService


Thanks,
Ji

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.