I am creating new documents from templates and then saving them as docx files.My understanding is that when I go to my saveas method I should be able to have the wdFormatXMLDocument as one of my fileformat options.However I don't.I have to use the numerical equivalent of 12.I have imported the Word 2007 interop and have all the methods at my fingertips there, but can't seem to find this particular option.
View 2 RepliesMy system has Office2007. And i use VB.Net to automate word. Everything works fine. But when tried to save in Word2003 format(.doc), it is not working. But the saved document is readable in Word2007.
Dim WordApp As Microsoft.Office.Interop.Word.Application = New Microsoft.Office.Interop.Word.Application()
Dim MyDoc As Microsoft.Office.Interop.Word.Document
[code].....
I have created an addin specifically for Microsoft PowerPoint 2003 that will cature any save attempts made by the end-user. The purpose is it analyse where the file is saved to and to take a copy of the saved file for version control.I have created a module level object mobjPPT which contains my PowerPoint application object and have assigned the PresentationBeforeSave event to my sub 'PowerPointSave'. Everything works up until the point it hits the 'Pres.SaveAs' line and throws the following error:
System.Runtime.InteropServices.COMException (0x80004005): Presentation (unknown member) : Failed.
at Microsoft.Office.Interop.PowerPoint.PresentationClass.SaveAs(String FileName, PpSaveAsFileType FileFormat, MsoTriState EmbedTrueTypeFonts)
at PPTSave.Connect.PowerPointSave(Presentation Pres, Boolean& Cancel)
I have tried calling SaveAs on the mobjPPT object instead but get the same results.Here is the offending item:
Code:
Private Sub PowerPointSave(ByVal Pres As Presentation, ByRef Cancel As Boolean)
Dim dlgResult As DialogResult = Nothing
Dim dlgFilter As Microsoft.Office.Core.FileDialogFilters = Nothing
[code]....
write a VB code that will open Word, create a Word document then, upon exiting Word, automatically have the file name save in a specific folder based on an Excel worksheet cell value? In other-words, if...let's say... if a worksheet cell value is 09-1, can a code be written to save a document as c:/NBI/Docs/09-1.doc ? Or am I going WAY beyond the scope of a VB nubee...?
View 4 RepliesMy application crashes when trying to save a word document as text. The error at SaveAs is "Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))" I am opening and manipulating a Word 2003 Document (using Word 2007) and then trying to save it as a text file.
[Code]...
I have a VB.net application that gets data off our server with ODBC and populates and saves a Word Document. When I try to deploy it to another computer it will get the data just fine and populate the first document, but it will crash before saving it. I've installed the .net framework 4.0, Microsoft Data Access Components, and the Microsoft ODBC .net data Provider. The error code is 0xC0000005, which is from what I can see is called an "Access Violation Exception." It works fine on my computer.
View 3 RepliesI have been trying to figure out how to read paragraph content which exists a heading. The heading itself is part of the table of contents. The heading will have a particular style (say Heading 1). For example: "Introduction" is a entry in Table of content with style Heading 1. I want to read content under heading "Introduction" but not any more content (i.e not content under sub headings of Introduction) I have been trying to do this using styles/style, TableofContent, Paragraphs/Paragraph,Range. Still cannot come up with a effective solution. I am working in VB.NET in VS 2010. I am using the word 2007 object model (office 2007 interop) as [URL]
View 1 RepliesI have developed a WinForm Application with VB.Net (VS2010) having Office 2010 Professional Installed, and it is 64-bit Windows 7 Platform. The program opens a .doc and .rtf format document, and attempts to save it in htm format. I am using following commands:
Dim sFilePath as String = "C:ABCfile.doc"
Dim oApp As New Microsoft.Office.Interop.Word.Application
Dim oDoc As New Microsoft.Office.Interop.Word.Document
[code]....
All goes fine with development and running on development PC, but when I publish it for offline installation, and deploy it on Client PC having Windows XP with Office 2007, it gives error on oDoc.SaveAs2 line, and program crashes.
I am using MS Access -2007 on windows server -2003. on my one of the query I get "Internal OLE automation error" after it runs. It shows data for a moment then data gets deleted from query when I hit OK button on Internal OLE automation error.
SELECT Qry_SNew.*, IIf([Qry_SNew].[Score1]>3.5,99.9663, IIf([Qry_SNew].[Score1] < -3.5 , 0.03369,[Tbl_percent].[Percentile])) AS Percentile1
FROM Qry_SNew LEFT JOIN Tbl_percent ON Qry_SNew.Score1 = [Tbl_percent].score;
I have both Excel 2003 and Excel 2007 installed on my system. When I call oExcel = CreateObject("Excel.Application"), Excel 2003 is used in the context in my .NET code instead of Excel 2007 (which I need to be used). I have referenced the "Microsoft Excel 12.0 Object Library" but when the code runs, the 11.0 version is used.
Is it because I am using Visual Studio .Net 2003 that Excel 2007 cannot be correctly referenced or do I need to change a reference or setting?
I used the code previously added by Mike Rosenblum but Excel is still not closing, Here is my code:
Imports Microsoft.Office.Interop
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Runtime.InteropServices
Private Sub Check_For_Xcel(ByVal filename As String)
Dim varpath As String = ""
Dim varvalue As String = ""
Dim xlapp As New Excel.Application
Dim xlbook1 As Excel.Workbook = xlapp.Workbooks.Add()
Try
varpath = filename
xlbook1 = GetObject(varpath)
xlbook1.Application.Visible = True
xlbook1.Windows(1).Visible = True
xlbook1.Application.WindowState = Excel.XlWindowState.xlMinimized
For irow = 2 To 65536
For icol = 1 To 4
Select Case icol
Case 1
read_date_time = xlbook1.Worksheets(1).Cells(irow, icol).Value
Case 2
read_plate = xlbook1.Worksheets(1).Cells(irow, icol).Value
Case 3
read_plate_state = xlbook1.Worksheets(1).Cells(irow, icol).Value
Case 4
read_location = xlbook1.Worksheets(1).Cells(irow, icol).Value
End Select
Next
If read_plate = Nothing Then Exit For
Check_IF_Present(read_plate, read_plate_state)
Next
If Not xlapp Is Nothing Then
GC.Collect()
GC.WaitForPendingFinalizers()
GC.Collect()
GC.WaitForPendingFinalizers()
Marshal.FinalReleaseComObject(xlbook1.Worksheets)
xlbook1.Close(SaveChanges:=False)
Marshal.FinalReleaseComObject(xlbook1)
xlapp.Quit()
Marshal.FinalReleaseComObject(xlapp)
End If
xlbook1 = Nothing
xlapp = Nothing
GC.Collect()
GC.WaitForPendingFinalizers()
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, "Error at Check for Xcel")
End Try
End Sub
I've managed to work out how to read EXCEL cells via static values. Ideally I would like my application to check the third column of the EXCEL sheet and if there are no entries on a given row, it should display the coresponding row of colums 1 and 2...for example if (C,3) contains no entry then get values of (A,3) and (B,3)...then mark (C,3) as pending by writing a value to (C,3). Here is my code at the moment
[Code]...
All i want to do is write some text into word... some of the text is normal text the other is bold... how do I achieve this?The samples I have seen, they either do normal text or bold.. but in different lines utilising InsertParagraphAfter()I need to have both in the one lineie how do i do the following line? using vb.net and word automation (word 2010)
View 2 RepliesI have an application that browses through Excel-files, changes color in some cells if they are in a wrong format etc.When my application is saving the changed file I get this alert about compatibility issues that can occur, and this alertbox has to be agreed or cancelled to move on to the next file. How can I disable this compatibility check programmatically? Or is there any way to ensure there are only Excel 2003 compatible colors in the document before saving?
View 13 RepliesI have an issue which has successfully busted my head all weekend. I created a COMAdd-in, in VB.NET (VS 2008) for Excel 2003. We now need to work the solution out for 2007 and since the layout and objects are a little different we had to make some critical Interface changes.Instead of a floating CommandBar we are now going with RibbonBar, which looks good but it doesn't work. Whenever I open Excel Workbook (which is the primary application). The Add-in successfully recognizes it and opens it up properly (bunch of Macro calls, layout settings etc). Anyway, after it opens, if I click on any button (on the new ribbon tab) I get "Application not properly initialize. Program will now close" and excel object is lost.
View 1 RepliesI have used Visual Studio 2008 (VB) to create a custom tab and button group with custom buttons. When any of those buttons are clicked, I simply want to run a macro (add-in) that will already be loaded when Excel is launched. The main examples I've seen create an Excel object in the VB code and then call the macro, but that seems like unnecessary overhead, since the custom buttons are are already loaded into Excel.
[Code]....
I added the reference and the "Imports" line, and I get the folowing error on the line
Code:
Dim oApp As New Excel.Application
Dim oWB As Excel.Workbook = oApp.Workbooks.Add()
Dim oWS As Excel.Worksheet = CType(oWB.Worksheets(1), Excel.Worksheet)
COMException was unhandled
Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
I am trying figure out something new, I can add a schema to a word 2007 doc and place the elements at diff locations. In my VB project with automation can I fill the elements. I can fill fields/content controls/story ranges just fine, but how does XML fit it to this? Or have I got it all mixed up??? Not asking for code just yet, just seeing if this is a correct approach.
View 3 RepliesI have a word 2007 doc (letter) template with an address block which gets its data from a SQL (ODBC) database.What I want to do is, from my VB 2008 app, is select certain addresses and then create the document(s) from the template with the selected addresses being placed in the address block.
View 1 Replieshow should I proceed -- with a VB UserForm (eg upon clicking successively a Form Button) -- in order to have a [TextBox.Text] contain (in other words: to have a TextBox show), say, one sentence at a time, text obtained from a MS Word document.Then, also, since it is also essential to my ambitions: can I have all the functionalities of my twenty or so existing word macros (triggered each in Word itself by its corresponding shortcut) available for use in said Form's TextBox? Just as an example, I have macros to simply toggle words between singular and plural or that invert the relative positions of two words, while others are 100 lines long and do searches in another Word document containing glossary entries using bookmarks.I searched the Web for hours on end to get a foothold on this issue to no avail until someone finally hinted at "automation". Then a wealth of info surfaced, but so far I only managed to get as far as this:
Dim msword As Object
msword = CreateObject("Word.Application")
msword.Visible = True
Dim wordDoc As Object
wordDoc = msword.Documents.Open("C:\tests\mydoc.doc")
and, yes, I added references to Microsoft Office 11.0 Object Library and to Microsoft Word 11.0 Object Library to my project. I am using Microsoft VB 2010 Express.
What happens is this: When this code runs, first I get a message saying the file is "locked for edition" (or something similar, for mine is a Portuguese version of Word) because it is being use by another user (myself). How should I overcome this hurdle. Then, never minding this initial problem, the dialog box message error offers my the chance of opening a copy as read only. I accept this option and the Word document opens beautifully.But after many trials and only errors, I still don't know how to code so as to get, for example, the first sentence of the document in my TextBox. And, again, will I be able to run my Word macros in the TextBox?
I tried for example:
Selection.MoveRight(Unit:=wdWord, Count:=1, Extend:=wdExtend)
and
wordDoc.Selection.MoveRight(Unit:=wdSentence, Count:=1, Extend:=wdExtend)
but they get blue/and/red underlined (illegal)Are Word VBA declarations per se not valid in VB? I have many more hurdles on the way I wish to such as (1) what tricks could I use so as no to loose original formatting when I finally learn how to get the sentences shown in the TextBox and subsequently paste them back into the Word document and (2) populating a ListBox with the content of a database record.
I just learned automation in Word. I had a document that started out as 88kb but after automation (19 fields/check boxes)it is over 1MB. Another, document I automated went from 27kb-32.
View 1 Replies1. I have button tugllet. I click the button and save file. I want - when I open the file, to see the button preesed (like "bold" button), how am I do this?
[Code]...
Is there a way, in Microsoft Word 2007, to set up a style that will highlight VB.NET keywords, just like the Visual Studio IDE does?
View 4 RepliesWhat would be the best approach for creating MS Word 2007 documents with vb.net that contains signature lines? I am currently in the planning phase of a project and I'm trying to gather some info. The idea would be to upgrade this program we have already developed(using vb.net) to generate .docx files that contain signature lines that are created progmatically. The signatures would be added later by the user through a workflow in SharePoint I just need to create the document with the lines. I have seen different tutorials on creating word docs, but not sure which method would be the best for what I'm doing. Where should I start looking?
Also, there doesnt seem to be too many tutorials on adding signatures line through code, more specifically how to automate the signature line setup. e.g. Who should sign, signers name, signers email address. How do I set these paramaters through code?
I am maintaining a program that automatically does a mail merge based on a client list. Using earlier versions of Microsoft Word, such as 2003, I did not have any trouble simply using the MailingLabel.CreateNewDocument() function, which takes a MAILING LABEL ID as its first parameter.The particular ID I'm now having trouble with in Word 2007 is "5160" which is an Avery label that should print three labels across the page (and it did in Word 2003). In Word 2007, it now prints 4 labels across.
From the research I've already done, apparently this is because the number of label templates has greatly expanded since the release of Word 2003, and now Word 2007 has a new set of label IDs that can be used with the MailingLabel.CreateNewDocumentByID() function. In the case of the Avery 5160 label, its new ID to be used for Word 2007 with the MailingLabel.CreateNewDocumentByID() function is "1359804671" and I have NO IDEA how that was calculated or where it was found.
I can't find the list of IDs to be used with the MailingLabel.CreateNewDocumentByID() function for Word 2007 anywhere. I read in a Microsoft Developer's blog post that you can calculate the new ID by using the following formula:
Label ID = (vendor id << 24) | product id
Unfortunately, that doesn't make any mathematical sense to me as I don't know what "<<" and "|" are supposed to represent in mathematical terms. Can anyone tell me where to find or how to calculate (based on the vendor id and product id) the mailing label ID I need to use with the MailingLabel.CreateNewDocumentByID() function?
How to open word 2007 in vb dot net windows application and go to the bookmark?
View 1 RepliesI want to open a number of RTF documents in Word 2007, one at a time, in a VB .NET program. Here is a small representative sample of my code:
Imports Word = Microsoft.Office.Interop.Word
Public Shared WordApp As Object = Nothing
Public Shared WordAppInit As Boolean = False
Public Shared Sub ExecWord()
If Not WordAppInit Then
On Error Resume Next
[Code] .....
Sometimes it hangs on one of the WordApp or WordDoc statements in TestSub1; sometimes it gets all the way through TestSub1 without problems but then hangs in TestSub2. Often it leaves an instance of WinWord running so that I have to kill it in Task Manager or reboot the system.
I need to run some Word 2007 mailmerge macros on Windows 2003 terminal services. This is something we've done fine with Word 2000 but the 2007 macros won't work.I understand the issue being the 'pointers' in the macro to h:temp (h being the home drive for each user on the terminal serve). Word 2007 macros only seem to like c:, is that correct or is there a way to get the 2007 macros to use something other than c:.
View 1 RepliesI'm developing an Outlook 2007 Add In with Visual Studio 2010 (VB).In the project I have a routine that opens, saves and closes Word 2007 documents.While the routine is executing, if I open Word 2007 application I see all the documents opening and closing, making it impossible for me to work in Word 2007.How can I launch the routine using a unique Word 2007 process?
View 5 RepliesI'm developing a program that handles money, and there is a pre-made excel spreadsheet that I am to be transfering data into specific cells. How can I go about telling my program to write specifc data into specific cell numer in excel? Also, how can I get my program to write into specific areas of a MS Word Template (my program will generate letter with the same template just different names/addresses/valus)?
View 3 Replies