microsoft.public.office.developer.automation | Forum profile

Hi there, I am using Word 2003 and visual studio 2008 to create a document manager via automation. I have been able to trap the DocumentBeforeClose event. I am doing this to save the active document as a blob file to the database before the document is closed. The DocumentBeforeClose event is hit successfully, but when...

Hello, I'm just about to implement an application that creates a table in a Word 2003 document. Doing so, I came across an issue I really can't explain. The following code (VBA) creates a new document, inserts some paragraphs and then inserts a table and sets column widths: Sub TableCraziness1() Dim ...

Hi, if I manually copy something from Excel to Word using Ctrl+C/Ctrl+V, the result in Word looks good. If I do the same in code, using [...] Selection.Paste, the result in Word looks less good. I have noticed that if I, when copying manually, use paste special and Rich Text Format, the result in Word looks the same as when using [...] ...

I need to automate the sending of an e-mail with a content-type: multipart/alternative. The first part will be plain text, followed by an HTML version. I understand that the syntax I need to produce includes defining a boundary in the content-type declaration, then using that boundary between parts. I can insert the boundary ...

Hi, I am trying to automate work with Excel file that uses macroses and VBA controls and forms. In particular, Excel file has the button that invokes a new form when clicking on it. I can successfully access and get reference to the button, but fails to do this for the form My C# code: ... ...

I have an Excel template that uses VBA code to process data from several other Excel workbooks. The embedded VBA code reads data from these other workbooks. For example: For j = 3 To 14 Set myrange = wb.Worksheets(iETCsht).Range(Cells(11, j), Cells(27, j)) B(j) = Application.WorksheetFunction.Sum(myrange)...

Could you provide a sample in C# to create a PivotTable on Sheet2 using a ListObject on Sheet1 as the DataSource? The initial Column should be OrderDate, rows should be ShippingRegion, measure should be count of ID. I'm having trouble figure this out for VSTO3/Excel 2007. Best regards, Jerry...

Please, In C# could you provide the basic steps (sample) to accomplish this? I have a ListObject on Sheet1, called "ListObject1", range starting at cell B2. I would like to create in Sheet2 (also at cell B2) a simple PivotTable, called "PivotTable1" using the ListObject on Sheet1 as its data source. Assuming the data is...

Hello, Does anyone know how I can find out, using the automation model, what version of Word a document was created with? I can find out what version of Word is running, but not what version the document was originally created in. The information is available somewhere as Word 2007 is opening the file in ...

Hi, I need to get text from all pages except page 1 from a word document. I guess this can be achieved using Microsoft.Office.Interop.Word.Pages. I found one way to get pages, but that way requires me to activate Word application: Microsoft.Office.Interop.Word.Pages pages = doc.ActiveWindow.ActivePane.Pages; Since ...

Hi there, I am using Word 2003 and visual studio 2008 to create a document manager via automation. I have been able to trap the DocumentBeforeClose event. I am doing this to save the active document as a blob file to the database before the document is closed. The DocumentBeforeClose event is hit successfully, but when...

Hello, Does anyone know how I can find out, using the automation model, what version of Word a document was created with? I can find out what version of Word is running, but not what version the document was originally created in. The information is available somewhere as Word 2007 is opening the file in ...

Could you provide a sample in C# to create a PivotTable on Sheet2 using a ListObject on Sheet1 as the DataSource? The initial Column should be OrderDate, rows should be ShippingRegion, measure should be count of ID. I'm having trouble figure this out for VSTO3/Excel 2007. Best regards, Jerry...

Hi, I am trying to automate work with Excel file that uses macroses and VBA controls and forms. In particular, Excel file has the button that invokes a new form when clicking on it. I can successfully access and get reference to the button, but fails to do this for the form My C# code: ... ...

Hi, if I manually copy something from Excel to Word using Ctrl+C/Ctrl+V, the result in Word looks good. If I do the same in code, using [...] Selection.Paste, the result in Word looks less good. I have noticed that if I, when copying manually, use paste special and