call .NET DLL

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - UserForm_Initialize() Need to find more info about the order in which the sub routines for UserForm events UserForm_Activate(), UserForm_Initialize(), are executed, which one is executed first and also other events that belongs to the UserForm object Tag: call .NET DLL Tag: 100521
  - 2
    - prevent to show part of document Could I prevent from showing part of open document? I try to solve one problem and one of possible sollution could be show just two pages of three. Gives Word or VBA som possibilities? Peter KNAP Tag: call .NET DLL Tag: 100517
  - 3
    - =?ISO-8859-1?Q?=22=E9chec_de_la_fermeture_du_presse-pa?= Bonjour, Que faire pour emp=EAcher ce d=E9faut: "=E9chec de la fermeture du presse-papiers" qui appara=EEt quand je cherche =E0 restaurer le contenu sauvegard=E9 du = presse papier par PutInClipboard ? D'avance merci. hpa Tag: call .NET DLL Tag: 100516
  - 4
    - MVP Status Fellow regular posters and MVP's, I've been declined the MVP status of this year. A decission of MS, I can't comprehend and validate: If there are persons willing to doubt this decission, kindly feedback on this thread. -- Krgrds, Perry System: Vista/Office Ultimate VS2005/VSTO2005 SE Tag: call .NET DLL Tag: 100515
  - 5
    - loading userforms Should you always load a userform before showing it? What is the advantage of loading the userform and then showing as opposed to just showing? Thanks. Tag: call .NET DLL Tag: 100510
  - 6
    - Is there a Clippy replacement for 2007 I wrote quite a few help systems for my office using what many people have described as 'that annoying Clippy.' As it turns out, he was endearing for the purpose used, and, properly configured in VBA, it allowed tremendous 'go forward' and 'go backward' controls, numbering, bulleting and autosizing features just not found in the standard message box. Is there anything thing that replaces this feature in 2007? Any 3rd party programs? Ed (in Virginia) Tag: call .NET DLL Tag: 100504
  - 7
    - Connect mysql with vba Hi, I'm writing a word vba which require to connect the mysql database. I'm new to database thing, any1 have any idea ?? I'm thinking to the ADODB.Connection But, I have no idea about the connectingstring, provider and driver,etc I'm using "Mysql server 5.0" I've install in my computer, so I can do the testing on my comp (localhost), and need to connect to the server on the network later. Many thanks Tag: call .NET DLL Tag: 100502
  - 8
    - Last page _ BLANK I have problem with this macro: Dim i As Long i = 5 Dim source As Document, target As Document Set source = ActiveDocument Set target = Documents.Add target.Range.FormattedText = source.Sections(i).Range.FormattedText After user click last button of user form just appropriate section of active document is shown. This is perfect however problem is that it always inserts one empty page at the end of section. I thought it is problem with formatting of text but it is plenty of place at the end of page for text (so I think problem is not with page or section brake). Could somebody help? peter Tag: call .NET DLL Tag: 100499
  - 9
    - How to hide source document? Hi. I am trying to create form for submission of applications where all used forms are in one document in separate sections. After user open template of this document macro asks him through UserForms what kind of application is he asking for. Then he is asked to fill in the appropriate boxes in UserForms and at the end only filed section is shown. Problem for me is that with filled form also template document stays open. I tried to write macro for closing source template document: ActiveDcument.Close but since template is actually active document last part of my macro: Dim i As Long i = 5 Dim source As Document, target As Document Set source = ActiveDocument Set target = Documents.Add target.Range.FormattedText = source.Sections(i).Range.FormattedText did not work because active document was no longer open then. How could I solve this problem? I want user to see just UserForms and at the end just part of the document he will print. Tag: call .NET DLL Tag: 100498
  - 10
    - Creating a variable This is what I need to do: If TextBox1 on UserForm1 is blank when the UserForm is unloaded, I want to create a public variable called "incomplete" (would also want that variable deleted if it already existed and TextBox1 were not blank when the UserForm where unloaded). Then when I open UserForm4 if the variable "incomplete" exists, I want the BackColor of CommandButton1 to be red. Tag: call .NET DLL Tag: 100489
  - 11
    - OptionButton Group question On my UserForm I have a number of OptionButton groups and each group has a Label associated to it. This is a series of questions with 3 possible answers for each question. What I would like is some code which would change the color of the text in the label from black to red, if none of the 3 OptionButtons in the group is true. I am hoping this could be done by Option Group as opposed to writing a click event for each OptionButton. Tag: call .NET DLL Tag: 100482
  - 12
    - checking if folder exists and if not create it Hi, I've got some code that move files, but I need the code to check if the destination folder exists and if it doesn;t to create it. I think I can do the code to create if, but not sure how to check if it exists? My code is below. I need help with the ***** bit. Thanks for any help. Dim oldfilepath as String Dim newfilepath as String Dim myFile as String Dim fso oldfilePath = "C:\old\" newfilePath = "C:\new\" myFile = "randomfile.doc" Set fso = CreateObject("Scripting.FileSystemObject") ***** if newfilepath exists then 'do nothing else fso.CreateFolder(newfilepath) end if oldfilepath = oldfilepath & myFile newfilepath = oldfilepath & myFile Name oldfilepath As newfilepath Tag: call .NET DLL Tag: 100477
  - 13
    - Finding and converting text to hyperlink with VBA Greetings from sunny Sweden, I have a macro that converts a SGML-style (custom formatted) plain text file to a word document with proper formatting (headers, styles etc.) but I cannot figure out how to convert the links. How can I use the macro to locate "tagged" (hyper-)links and convert them to working hyperlinks? This is how it looks like: --- Some text here. Some more text. Click here to view the PDF: <LINK>FileName.PDF</LINK> Even more text. --- I want the "tags" to be removed and the text FileName.PDF to remain, but as a functional (clickable) link to the PDF file. I know that there is a search-and-replace method that can extract substrings from strings (have used it for style control) but can't make it happen with the link creation. Any coding hints would be appreciated. Thanks in advance! Jon Tag: call .NET DLL Tag: 100475
  - 14
    - modified date Hi, I;m using the following code to display the modified date of the active document: Dim dlvVersions As Office.DocumentLibraryVersions Dim dlvVersion As Office.DocumentLibraryVersion Dim strVersionInfo As String Set dlvVersions = ActiveDocument.DocumentLibraryVersions If dlvVersions.IsVersioningEnabled Then strVersionInfo = dlvVersion.Modified End If MsgBox (strVersionInfo) Set dlvVersion = Nothing Set dlvVersions = Nothing But it's debugging at: Set dlvVersions = ActiveDocument.DocumentLibraryVersions saying that 'No versions exist for this file' Any ideas where I'm going wrong? thanks. Tag: call .NET DLL Tag: 100471
  - 15
    - adding gui application to word Suppose i have a gui application (currently written in python) which enables the user to create word tables, is there any way to insert this application as some sort of a macro (meaning: adding a button to word clicking on which will show the wizard) Thanks Tag: call .NET DLL Tag: 100470
  - 16
    - computer maintenince how could where i could improve my knowlge on this ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=44eb36cd-57a8-464d-9739-ed4c9bcfc735&dg=microsoft.public.word.vba.general Tag: call .NET DLL Tag: 100469
  - 17
    - loop through all docs in a folder Hi, how do I loop through all documents in a folder and perform a task? ie what I would like to do is: - while there is a word document in folder - open word document - perform code - next word document if there is one Thanks. Tag: call .NET DLL Tag: 100447
  - 18
    - Templates and Macros Hi guys and gals, I'm having trouble with a template in Word 2003. It has macros and forms in it. When I create a document based on the template, the macros work while on my machine. However, when I separate the document from the template, the macros and forms no longer work. It appers they are not copied into the new document. Does anyone know how I can make the document carry over the macros and forms from the template? Thanks in advance Stephen at ZennHAUS Tag: call .NET DLL Tag: 100440
  - 19
    - Reading text at bookmark field Hi All, Bascially i have a bookmark "Claim_No", i want to be able read the data that has been entered against it. I have had one of those days and i know it is simple, but i just can't seem to remember how to do it. Can someone please show me an example so that i can store it again in the memorybank. TIA Justin Tag: call .NET DLL Tag: 100436
  - 20
    - Set Word Options in VBA for Word 2007 I've created a macro to set Word Options to my needs in Word 2007. It includes most of the properties settings for Options object and some properties settings for Application & Window/View object. It runs VERY SLOW. I stepped through each line of codes and found half of the settings take several seconds to finish. The similar macro I created for Word 97/2000/2002/2003 run very smoothly, took just a second to finish all. I've noticed the message "conneting to printer .." shown on the status bar when the macro run and tried to turn off "Application.ScreenUpdating", no difference. Does any one know how to fix this problem? Thanks in advance. Tag: call .NET DLL Tag: 100408
  - 21
    - Find the next blank line Hello from Steved I have a 6 paragraph then a blank line also i have paragraphs from 4 to 22 each with a blank line. Please how do I find the next blank line, Yes I've tried using wildcard but did not help me find the next blank line. Thankyou. Tag: call .NET DLL Tag: 100402
  - 22
    - What is Eclipse Inventory Management & Financial Software? Interviewing with a Company that has the Eclipse Software. Where can I find this? Thanks. Tag: call .NET DLL Tag: 100384
  - 23
    - deselect command in a macro I have created a macro for users to update all the fill-in fields in my document, but it puts me back in with the "WholeStory" still selected. AND the recorder will not let me click on the document, right click and toggle fields or any other way that I know how to deselect the material. This document is going out to the entire company of about 2000 poeple and I know a LOT of them are not computer savvy enough to do it themselves. SO, I want to know what the command is that I can put within the macro to deselect the WholeStory. I don't even know enough about Visual Basic to BE dangerous!!! Thanks! Audrey Tag: call .NET DLL Tag: 100383
  - 24
    - Form field frustration I am having a couple of issues programmatically accessing form fields. I have assigned â??bookmarkâ?? names to these fields and here is how I can use VBA to see what has been entered in the field. Dim FieldText as string FieldText = Word.ActiveDocument.Bookmarks("LastName").Range.Text The problems : A) I cannot detect when the field is empty B) Empty fields have text value of 5 spaces, but return FALSE when compared to being equal to 5 spaces C) Trim seemingly has no effect, as â??trim(FormField)â?? still = FormField = 5 spaces D) Any attempt to erase the text in a form field by setting = â??â?? erases the form field, setting equal to 5 spaces also does not work. I need to be able to detect an empty form field, and be able to erase text in form fields. Any ideas? Tag: call .NET DLL Tag: 100381
  - 25
    - Insert superscripted ordinal date - Word 2000 ?? Hi all :) I'm trying to create a macro that inserts the current date to replace the selected text (not as a field). ------------------ Selection.InsertDateTime DateTimeFormat:="dd MMMM yyyy", InsertAsField:= False, DateLanguage:=wdEnglishUK, CalendarType:=wdCalendarWestern, InsertAsFullWidth:=False ------------------ is easy enough and gives me the date as 18 May 2007 but I need to insert it as 18th May 2007 with the ordinal (st,nd,rd) in superscript. I think that it's something to do with \* ordinal but I can't for the life of me work out how the syntax goes. And I can't even begin to guess how to do the superscripting! Yes, I know it's a silly way of formatting a date - it wasn't my idea ;) Thanks all :) Tag: call .NET DLL Tag: 100376
- Next
  - 1
    - PrintDate from Protected document doesn't work I have the following problem with PrintDate which appears only in Word 2000 In Word 2003 everything works OK. My users unfortunately use Word 2000 (9.0.4402 SR-1) 1) Users demand is that the footer contains PrintDate field 2) Second demand is that when approved, document is protected against writing with password . I protect document programmatically with following code Const wdAllowOnlyComments=1 WordObj.ActiveDocument.Protect wdAllowOnlyComments, False, "PASSWORD" 3) PROBLEM IS FOLLOWING: After protecting the document, PrintDate, after document has been printed out, doesnâ??t work any more It is empty = 00.00.00000. I also found out that the same problem with PrintDate appears also if I do everything manually in Word so probably this is a Bug or something. Can someone give me an advice what to do that PrintDate will work in Word 2000 (9.0.4402 SR-1). Maybe there is fix for this or some workaround? Thank you Lojze Tag: call .NET DLL Tag: 100373
  - 2
    - How to remove italic formatting I'm obviously a bloody beginner in Word. I have some text, some of it formatted in the (italic) character style "Emphasis", some of it with "italic" applied as manual formatting. I want to have all the text formatted "not italic". Selection.Font.Italic=False does not work. Am I overlooking an obvious, simple solution, or do I have to write some elaborate code, just to remove the italic formatting? Regards, Klaus Tag: call .NET DLL Tag: 100359
  - 3
    - Excel running Word macro I have a complicated macro which does several things to a series of imported htm files, however it is not working as expected. An excel macro produces a list of htm files within a directory and outputs it to sheet1 and then one by one uses this as a parameter to start a word macro (ww has been defined as the word application object) ww.Documents.Open ThisWorkbook.Path & "\datastage1.doc" runnow = ww.Run("stage1", file) This runs the macro stage1 in the word document datastage1.doc using the file stored in variable "file". Sub stage1(myfile As String) file = myfile folderpath = ActiveDocument.Path & "\inputhtm\" Documents.Open FileName:=folderpath & file This word macro then opens the file and is meant to remove all occurences of a two line text fragment using a word (XXPAEDT) to find the first of those lines: 'DELETE UNWANTED LINES Selection.HomeKey Unit:=wdStory Selection.Find.ClearFormatting With Selection.Find Do While .Execute(FindText:="XXPAEDT", Wrap:=wdFindContinue, Forward:=True) = True Selection.EndKey Unit:=wdLine, Extend:=wdExtend Selection.MoveDown Unit:=wdLine, Count:=1, Extend:=wdExtend Selection.Delete Unit:=wdCharacter, Count:=1 Loop End With This does not work and the lines are not removed, yet if i open the document manualy and then use the macro after removing the above section that opens the htm file (so it starts with the remove unwanted lines comment) it works perfectly!!! Any ideas as to why the different behaviour if the file is opened manually by the user or automatically by the macro Thanks Richard Tag: call .NET DLL Tag: 100349
  - 4
    - Date + 1 Month Hi there, I'm pretty new so bear with me. I have a word document ask a user what a certain date is. Let's call it "DATE A". This date is inserted into the first row of a table. I need to add 1 Month to this date in the next row. 2 Months to this date in the row below, etc. I.E. Let's assume DATE A is January 01, 2007. I need the next date in the table to be Febuary 01, 2007, then March 01, 2007 etc. Any clue on how I would do this? I've looked everywhere, and every thing seems to be a little over my head. Much appreciated. :) Kevin Tag: call .NET DLL Tag: 100332
  - 5
    - Code for Adding Custom Document Property I have revised an existing template to contain a new custom doc property. Since old documents (not containing the new property) will sometimes be attaching to the template, I need to add code that checks the attached document for the existence of the property & if it's not there, create it. I know the code I need to use to add the custom document property(ActiveDocument.CustomDocumentProperties.Add ...) , but I don't know the best way to check for the property & tell it to execute the code if the property is missing. Also ... I read in another email thread that it may not be a good idea to create the customdocument property with ActiveDocument since the property exists in the template but not in the open doc. If the property existing in the template but not in the active document creates a conflict, then what should I use instead to create it? Thanks for your help. -- JoAnn Tag: call .NET DLL Tag: 100331
  - 6
    - Detect if word document is open How can I detect if a word document is open and if it is open how can i do modification from MS access with VBA? Thanks for any suggestion Jose Tag: call .NET DLL Tag: 100329
  - 7
    - Using arrays in a userform I have an Excel file which is a database of names and addresses. It consists of 16 columns of data and 20 rows for each office. In my Word template I have a userform with, among other things, a dropdown list and two command buttons. One button Retrieves the first nine fields in the database and displays these on the form for the user to check the correct details have been selected based on the dropdown list. I have no problems with this part. On retrieval, Fields 10 to 16 are put into an array variant, like this: VarData(0) = rs.Fields(9).Value VarData(1) = rs.Fields(10).Value VarData(2) = rs.Fields(11).Value VarData(3) = rs.Fields(12).Value VarData(4) = rs.Fields(13).Value VarData(5) = rs.Fields(14).Value VarData(6) = rs.Fields(15).Value I have checked and each element of the array is holding its correct information. What I don't know how to do is to pass the data that was in the array under the "Retrieve" button so that it can be put on the paper when I press the "OK" button. Each piece of the array would be concatenated with a vbCr prior to going on the page. Also, if there was no data (Null) in the last field then I would discard it from the operation. Can anyone help, please? Roderick Tag: call .NET DLL Tag: 100326
  - 8
    - Userform is no longer invoked Hi: I am having a problem with a userform that is no longer invoked once the custum button is pressed. What it is call up a template with the userform to enter specific fields and then print two copies. What did I do to cause this issue? Thanks, -- Jo Tag: call .NET DLL Tag: 100322
  - 9
    - closeing only active document Hi. how to write macro for closing only active document not all the word application? in F1 help I found st. like : ActiveDocument.Close SaveChanges:=wdPromptToSaveChanges but when user is asked whether he wants to save changes or not there is also possibility to cancel and when this is done document is not closed. I would like to manage to close active document without possibolity for cancelling (just save or not). regards Peter. Tag: call .NET DLL Tag: 100317
  - 10
    - Re: find last modified file in .file.search Use msoSortOrderDescending instead of msoSortOrderAscending in FileSeach.Execute() -- Krgrds, Perry System: Vista/Office Ultimate VS2005/VSTO2005 SE "Perry" <drumper@gmail.com> schreef in bericht news:... > Don't know what the With Selection/End With block is doing in yr code. > Remove this for the time being. > > As to the searchresults: > > Expand below code example to match yr situation. > Note: the results can be found in the .FoundFiles() array. > The first member in this array will be the full filename of targetfile you > requested against the .Execute() parameters you used. > > Use that one to open your file... > > With Application.FileSearch > .NewSearch > .LookIn = strPath > .SearchSubFolders = False > .FileName = "*.csv" > .Execute (msoSortByLastModified, msoSortOrderAscending) > If .found then > Msgbox .FoundFiles(1) > end if > End With > > -- > Krgrds, > Perry > > System: > Vista/Office Ultimate > VS2005/VSTO2005 SE > > > > "muyBN" <muyBN@discussions.microsoft.com> schreef in bericht > news:6B3C5BA7-C9C5-4F69-8DDB-E270F5BDBF22@microsoft.com... >> In the following code, I need to open the file which has been modified >> last >> but don't quite know how to write it. Your assistance in this will be >> appreciated. >> >> >> strPath = "C:\Data\misc\0PackIt\" >> strFirstFile = ActiveDocument.name >> With Selection >> With Application.FileSearch >> .NewSearch >> .LookIn = strPath >> .SearchSubFolders = False >> .FileName = "*.csv" >> .Execute (msoSortByLastModified) >> intFiles = .FoundFiles.count >> If .Execute(msoSortOrderAscending) > 0 Then >> strFile '= last modifed file >> End If >> End With >> End With >> Documents.Open (strPath & "\" & strFile), AddToRecentFiles:=True, >> Format:=11 >> >> -- >> Bryan > Tag: call .NET DLL Tag: 100316
  - 11
    - how to reference/open last file modified In the following code, I want to search for and open the most recent file modified, but don't know how to write that particular line. Assistance will be appreciated. Thanks. strPath = [path name] strFirstFile = ActiveDocument.name With Selection With Application.FileSearch .NewSearch .LookIn = strPath .SearchSubFolders = False .FileName = "*.csv" .Execute (msoSortByLastModified) intFiles = .FoundFiles.count If .Execute(msoSortByLastModified, msoSortOrderAscending) > 0 Then strFile = [last modifed file] End If End With End With Documents.Open (strPath & "\" & strFile), AddToRecentFiles:=True, Format:=11 -- Bryan Tag: call .NET DLL Tag: 100313
  - 12
    - find last modified file in .file.search In the following code, I need to open the file which has been modified last but don't quite know how to write it. Your assistance in this will be appreciated. strPath = "C:\Data\misc\0PackIt\" strFirstFile = ActiveDocument.name With Selection With Application.FileSearch .NewSearch .LookIn = strPath .SearchSubFolders = False .FileName = "*.csv" .Execute (msoSortByLastModified) intFiles = .FoundFiles.count If .Execute(msoSortOrderAscending) > 0 Then strFile '= last modifed file End If End With End With Documents.Open (strPath & "\" & strFile), AddToRecentFiles:=True, Format:=11 -- Bryan Tag: call .NET DLL Tag: 100312
  - 13
    - Error running Word 2007 Macro- macros disabled I get the error "Macros in this project are disabled" when trying to run a macro. I looked around and went into the Trust Center and set it to allow all macros. It still gives me the same message even after setting that to allow all and restarting word. Any ideas? This was a Word 2003 doc if that makes any difference. Tag: call .NET DLL Tag: 100308
  - 14
    - Auto Clear Picture from Clipboard After I copy paste a picture to a word document, save it and close it, it asks "You placed a picture on the clipboard. Do you want this picture to be available to other applications after you quit word?" and has 3 options for me "yes" , "No" , "Cancel" . How do I make sure it always selects "No"? All help is appreciated. Tag: call .NET DLL Tag: 100305
  - 15
    - Word 2003 I would like to combine 2 pre-installed macros in one macrobutton expression without creating a new macro or editing an existing one. Can I somehow include 2 macros in 1 macrobutton? Tag: call .NET DLL Tag: 100291
  - 16
    - Is range in a field? Is there a way to test whether a Range (or Selection) is in a Field, and if so, to access that field? Tag: call .NET DLL Tag: 100288
  - 17
    - PUTTING A TICK IN A FORM Please help I'm going insane. I want to eaither change the check box form field into a a= ctual tick or get the macro (which is basic) to work in my form. It keeps coming up with a= run time error 4605. Heres the VB for the tick Sub TICK() ' ' TICK Macro ' Macro recorded 2/16/2007 by Megan Dixon ' Selection.TypeText Text:=3D"=C3=BC" Selection.Font.Name =3D "Wingdings" Selection.MoveLeft Unit:=3DwdWord, Count:=3D1, Extend:=3DwdExtend Selection.Font.Name =3D "Wingdings" End Sub Thanks Tag: call .NET DLL Tag: 100283
  - 18
    - Splitting a line of text at commas I have an Excel database and my Word template retrieves data from it quite successfully. One of the lines of data it retrieves is an address, each part of it separated by commas e.g: address1, address2, address3, and so on... For historical reasons, the one line address must remain as it is in the Excel database file. My client has now asked me if I can split that line at each comma and put each component on a separate line. I'm sure it can be done but would not know where to start. Is there a solution, please? Roderick Tag: call .NET DLL Tag: 100280
  - 19
    - Selecting a table in a footer I'm trying to adapt the following code to find out if there is a table in any of the footers: kJunk = ActiveDocument.Sections(1).Footers(1).Range.StoryType 'Iterate through all story types in the current document For Each kStory In ActiveDocument.StoryRanges 'Iterate through all linked stories Do On Error Resume Next Select Case kStory.StoryType Case wdEvenPagesFooterStory, wdFirstPageFooterStory, wdPrimaryFooterStory * * Pseudo-code: If there are any tables in this story then select the third cell in the first row * Next End If Case Else 'Do Nothing End Select On Error GoTo 0 'Get next linked story (if any) Set kStory = kStory.NextStoryRange Loop Until kStory Is Nothing Next Can anyone help with this please? Roderick Tag: call .NET DLL Tag: 100279
  - 20
    - Word-2003 VBA winword.exe is running under 'processes' but not ope winword.exe is running under 'processes' but not open under application hi, to close the application from VBA i am using the command Application.Quit wdDoNotSaveChanges the application closes, in the application tab of task manager, nothing is there but when i open processes in task manager i can see that the WINWORD.EXE is still running. why winword is still running. it happnes some time not all the time. please suggest how to overcome this problem. The machine in which i am running it contains two processor. let me know if any more information needed. Tag: call .NET DLL Tag: 100276
  - 21
    - Endless loop if macro tries to process text in a table cell, otherwise running fine. Below macro which I recently wrote is supposed to COPY all the text that has been placed between brackets TO the end of the document and list them one below the other. It is running fine with one exception. If text between brackets is found in a table cell, the macro falls into an endless loop. In theses cases, it copies the text between the brackets over and over again and won't stop. Hence, how do I have to re-write this code so that text between brackets located in a table cell is also properly copied and put at the end of the document. Help is appreciated. Thank you very much in advance. Regards, Andreas Dim rng As Range Dim rngEnd As Long Set rng = ActiveDocument.Range rngEnd = ActiveDocument.Range.End With rng.Find .Text = "$[!$]@\)" .MatchWildcards = True Do While .Execute() rng.Copy ActiveDocument.Bookmarks("\EndOfDoc").Range.Paste ActiveDocument.Bookmarks("\EndOfDoc").Range.InsertAfter vbCr rng.Collapse wdCollapseEnd rng.End = rngEnd Loop End With End Sub Tag: call .NET DLL Tag: 100270
  - 22
    - More help with specific page printing I have a macro set up whereby users are presented with a user form which gives them the choice of printing all pages, current page or first page OR inserting into a text box which pages they wish to print. The form also has a combo box for selecting/inserting the number of copies they wish to print. Here is the code for the cmdOK button of the form dim Specific Pages as String dim NumberCopies as String SpecificPages = txtSpecPages.value (the name of the text box) NumberCopies = cboNumCopies.value (the name of the combo box) If SpecificPages <> "" Then ActiveDocument.PrintOut Range:=wdPrintRangeOfPages, Pages:=SpecificPages, Copies:=NumberCopies ElseIf OptA = True Then (the option button for printing all pages) ActiveDocument.PrintOut Copies:=NumberCopies ElseIf OptC = True Then (the option button for printing the current page) ActiveDocument.PrintOut Range:=wdPrintCurrentPage, Copies:=NumberCopies ElseIf OptF = True Then (the option button for printing the first page) Selection.HomeKey Unit:=wdStory ActiveDocument.PrintOut Range:=wdPrintCurrentPage, Copies:=NumberCopies End If What happens is the following: If specific pages is filled in - prints all pages and prints one copy regardless of how many copies are asked for If Print All - prints all pages (which is OK) but only prints one copy regardless of how many copies are asked for Print Current - prints all pages and only prints one copy regardless of how many copies are asked for Print First - prints all pages and only prints one copy regardless of how may copies are asked for What am I doing wrong???? The printer I am printing to is set up to print duplex at all times, does this conflict with the printing request? I would have thought that it would still print the pages you asked for as duplex. thanks, Tag: call .NET DLL Tag: 100269
  - 23
    - ShapeRange gives error Can anyone tell me why the statement i = Selection.Range.ShapeRange.Count gives error message 5852 if there are no shapes in the selection but works if there are one or more shapes. I can work around the problem using error trapping but it is messy. I am using Word2000 VBA Tag: call .NET DLL Tag: 100262
  - 24
    - Populating & updating Word document from database I am looking for the best solution to meet the needs for a future development project. I think the new Word smart document might be the answer, but I'm not sure of its capabilities. What I need is as follows: My end users frequently create data-intesive proposal documents. The documents are a combination of a standard proposal template of text that they edit/customize for each specific proposal, and inserting data from another application, generally in the form of tables. The data from the application is always grouped together in a set number of tables, say Table A, Table B, and Table C. I would like the end user to be able to open a word document template, choose which tables to insert and where to insert in the document, and be able to modify the formatting of the tables (not the values in the table). Since the end user continues to update the data in the application while developing the proposal in Word, the user needs the ability to automatically update the table values from the application, without overriding any formatting changes that were made to the table. Is this possible? Am I on the right track with smart documents? I am not really a technical person, but am trying to do the initial research on what technology my development staff should use. Any help or advice would be appreciated! Thanks! Tag: call .NET DLL Tag: 100256
  - 25
    - Hide screen while Macro is working I have a template with 16 different forms. There are 16 buttons and when the user double clicks on a button, all other forms are cut leaving only the form they need. This works very well but the flashing screen is annoying. Is there a way not to hide this macro working screen? DJK Tag: call .NET DLL Tag: 100244

Hi,
is it possible to call .NET DLL from VBA?
How?

Best regards
Seb

Re: call .NET DLL by Jonathan

Jonathan
Tue May 22 06:50:31 CDT 2007

"Seb" <sebs_78@nospam.hotmail.com> wrote in message
news:4652b7d5$0$5111$ba4acef3@news.orange.fr...
> Hi,
> is it possible to call .NET DLL from VBA?
> How?
>

Only if it has been configured as an ActiveX DLL.

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Top

Re: call .NET DLL by Cindy

Cindy
Tue May 29 14:18:12 CDT 2007

Hi Seb,

> is it possible to call .NET DLL from VBA?
>
It has to be exposed to COM. Andrew Whitechapel explains
the steps in some detail in his ".NET developement for
Microsoft Office", but in a general way it means

1. Set the project's Register for COM interop to true

2. Generate a GUID to attribute the assembly

3. Write interfaces to expose the methods, assigning each
its own GUID and setting an attribute to be
ComVisible(true)

4. Implement each interface in a public class, also with
its own GUID and with the attribute
ClassInterface(ClassInterfaceType.None) and also make it
ComVisible(true)

5. Strong name the assembly

If you need more help with this, the
dotnet.framework.interop newsgroup is probably a better
place to ask than a VBA newsgroup :-)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)

Top