Problem with Office XP PIA

Published 08 March 04 07:00 AM | chris 

A reader of my blog recently wrote in and asked a question that I did not have a good answer for related to using the PIAs with Office XP. Maybe someone else out there will have the answer:

------------------------------------
I have created a Visual Basic .NET project that takes a Word template and creates a document and then searches it for specific text items and replaces these with Field/Links to an Excel workbook. I have it working but?.

  • When it runs I cannot use Word or Excel (even different documents) until the program finishes. While it only takes 3 minutes it is still bugging me.
  • Also, Form prompts the user for a Excel file name using the openFileDialog class. When the dialog box goes away the screen doesn?t clear correctly so I have parts of screen left over, not sure it is because of the memory being totally absorbed by Word.
  • Which brings me to my last question, looking at processing it is showing almost 100% usage. I have Intel Pentium 4 CPU 2.80GHZ, 512 MB RAM, Running Windows XP SP1 plus all updates. Using .NET 1.1.
One of the difficult things I am finding is that everyone addresses automating Word or Excel through the Word or Excel Office Projects and I need to be able to create a regular project and then use the Word and Excel classes. ------------------------------------

Any takers? - Chris


Comments

No Comments
Anonymous comments are disabled