I'm using the Word 2007 spellchecker via Interop in a VB.net desktop app. When using the default language (English), it works fine. If I set the language to French via LanguageId, it also works. But if I set it to French (Canadian) (Word.WdLanguageID.wdFrenchCanadian), it doesn't work. There's no error message, it simply runs and says the document contains no errors.
View 1 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 currently a dictionary of 20,000 words and since i want my application to be ran independently, i want to use the words in my dictionary to spell check all words in the RTB Control.
View 2 RepliesI am having an issue with my program that I hope you can help with. I have integrated my program to work with Outlook and I have installed the 2003 Primary Interop Assemblies on the client computer and it works fine (i.e. opens Outlook Email and attaches a file from my program). Well, we have many computers here that run Office 2007, so I installed the 2007 PIA on their computer and it doesnt work. It doesnt tell you anything in the error when the update download fails, just "You need to contact your system administrator". Is there anything else I need to do to get it to work with computers running Office 2007 - any references I need to add, or properties needing changed?
I know the isnt any issue with the server, connectivity, or anything like that because it works just fine on computers without Office 2007.
I 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.
My 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 a .NET winforms app that automates Excel and checks for a worksheet password. The requirements are to be able to detect
1) that the protection is turned off
2) that the password is removed (protected but there is no password)
3) that the password matches the correct password from a database
To meet the second requirement the program calls the Worksheet.Unprotect command with a null string, capturing the error. If error as expected, the 3rd check is made. If no error, then the Unprotect worked without a password ==> password was removed.
The code sample below has these checks.The application can do this fine with Office 2003. I have since had my dev machine updated to Office 2007 and it no longer works as it did. When I call the Worksheet.Unprotect, Excel prompts for the password!
I need to know how this should be accomplished in the new version of Excel or if there is a way to reference the old PIA. No matter what if I set a reference to Excel 11 it is replaced with the PIA for 12 in the GAC.
'return true if unprotect of worksheet does not generate an error
'all other errors will bubble up
'return false if specific error is "Password is invalid..."
Try
[code].....
Assume all traces of Office 2003 will be removed from the computer.I understand that I will still be able to use .xls files. I'm asking about automating Excel through the COM interop from outside Excel. When I add a reference to Excel to a VB project, it gives me a different version of the dll for different versions of Excel. If a program was compiled with a reference to Office 2003's dll, will it need to be recompiled for Office 2007? Will the code need to be updated to use the new dll?
View 2 RepliesI'm working on an application which automatically generates faxes.The system uses word interop to fill a template .doc file with values (which works fine), but when it comes to be time to print the resulting file to pcl, I'm having issues. So, we've got a HP Laserjet printer set up which prints .pcl files.
Dim appWord As New Word.Application
Dim doc As New Word.Document
appWord.ActivePrinter = PCL_PRINTER
[code]......
Problem is that when the doc.PrintOut line runs, word complains, popping up a message:I've tried all sorts of combinations of things, but the error message persists. Very occasionally, the thing actually works and generates a usable pcl file, but 98% of the time, the error message pops up and the whole process grinds to a halt.
We have other applications on the same server which do almost exactly the same thing, except they print from excel instead of word, and they work without throwing the error.
I am working on a legacy VB.NET application that uses Microsoft.Office.Interop.Word, with Office 2003 installed on the server. When I publish my site, even though my config file clearly shows v11: The site will crash saying v12 couldn't be found: Could not load file or assembly 'Microsoft.Office.Interop.Word, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)
Note: I currently have Office 2003 & 2007 installed on my dev machine, also, when looking @ references I am given the option of selecting v11 or v12 (so v11 is def. there). Within a page on the site the page does an import statement for Microsoft.Office.Interop.Word. Is it possible to specify the version at this point, or any way to force it to use v11 without me uninstalling my v12?
I'm an inquisitive .NET student without any commercial working knowledge and I have been puzzled by what exactlty are .NET languages meant for? Q1.If you look on job websites, .NET seems mainly used for web applications, not much for Windows applications? (My dream job is to develop standalone small Windows applications.)
[Code]...
I am able to insert a textbox into a Word document using the below code:
Dim opProcedures As Word.Shape
opProcedures = oDoc.Shapes.AddTextbox(Microsoft.Office.Core.MsoTextOrientation.msoTextOrientationHorizontal, 0, 0, 456.75, 24.75)
opProcedures.TextFrame.TextRange.Text = "Operational Procedures"
This adds a textbox to the first page of the document however even when I change the first (top) parameter I am unable to move the textbox onto the second page (only lower down onto the 1st page, any greater values than the height of the first page an it disappears).
How can I get the textbox to appear on the 2nd page of the document?
I'm having some difficulty merging multiple word documents together using Microsoft Office Interop Assemblies (Office 2007) and ASP.NET 3.5. I'm able to merge the documents, but some of my formatting is missing (namely the fonts and images).
My current merge code is shown below.
private void CombineDocuments() {
object wdPageBreak = 7;
object wdStory = 6;
[code]....
I don't care necessarily how this is accomplished. It could output via PDF if it had to. I just want the formatting to carry over.
visual basic.net is case insensitive so it allows the coder to write without caring or remembering the casing of variables. it also relieves from the 'undeclared variable' errors if you use the variable in another case than the one used in declaration. The fact that its line termination is a line feed makes it even more readable unlike C# or c++ that need good care in the casing and contineous war with following up with the {}, matching them and figuring out which is for which.my question is what are the advantages of c# over vb knowing that both get compiled to MSIL so there is almost no performance difference between the two languages?
View 1 RepliesI have an issue with an Office addin I'm working on, which is implemented for Office 2003 & 2007. The addin is written in VB.NET 3.5 using VSTO.The problem comes from some external code which automates a mail merge, opening the mail merge template, merging and then closing the template document. The close is done with this code:
objWord.Documents(sDoco).Close SaveChanges:=wdDoNotSaveChanges, OriginalFormat:=wdPromptUser
Because of some logic in my addin, instigated from the Interop.Word.Application.DocumentBeforeClose event, a message box is opened which prevents the Office document from closing, which breaks the automation.
Is there a way for me to determine the SaveChanges parameter (if any) on a Close within an Office.Interop.Word.Application event, such as DocumentBeforeClose? I'm trying to capture this parameter and determine if it's set to wdDoNotSaveChanges so that I can work around this problem.
I'm trying to call this code in VB.NET with "option strict on":
Dim application As word.Application = New word.Application
application.WordBasic.DisableAutoMacros(1)
The WordBasic object is dynamic, there is no type library available.Now the compiler will complain, because late binding is not allowed.
It says .Application ambiguous Error6'Application' is ambiguous in the namespace 'Microsoft.Office.Interop.Word'.
Imports Word = Microsoft.Office.Interop.Word
oWord = CType(CreateObject("Word.Application"), Word.Application)
oDoc = oWord.Documents.Add()
My 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 am creating simple mail without any atach using Microsoft.Office.Interop.Outlook. Mail is successfully created and opened, but after this button 'Attach File' does not work (it could be clicked, file could be selected but it is not attached). Here is simple code:
[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 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 RepliesI 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 RepliesI try to make a find/replace in a existing word document using vb.net. Here's my code:
[Code]...
When running the code I get a AccessViolationException on the codeline where the Range.Find is called... I use VSTD2008 and Office 2007 on Windows 7. I have also tried running the code on a machine with Office 2003 which was successful. So if anybody could tell me what I have to do differently that I get this working with office 2007 I'd be very glad!
In our Company we were using the following code to open an HTML script in Microsoft Word 2003
[Code]...