Transposing word doc into Excel doc

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - align 2 paragraph styles with no line break (appear as 1 line) I need to have 2 styles look as follows: (style 1) 62340 Description line (style 2) The number would be bold, the description line would not. Description line can be very long, wrapping quite a few times. Is there an option to have no line break and choose to align 2nd paragraph with 1st? I have used Ventura for years but have been asked to try & setup in MS Word, which I don't think is going to work. Tag: Transposing word doc into Excel doc Tag: 74181
  - 2
    - The list openend document On the right site when opening word than have you a list from the opening files what you haven don. When you opend the file than is the next time not the first one. The old program (word 2000) that was oke. The ask is that chance that when i for de second time opend the file that also in word2000 the second one is. ---------------- 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=0d0f81f0-5560-4db6-81e9-2fc3bbab7040&dg=microsoft.public.word.vba.general Tag: Transposing word doc into Excel doc Tag: 74180
  - 3
    - Unicode question I seem to have a strange unicode problem. Let me descibe what I am doing: Part of my VBA tool involves reading from a unicode saved text file which is in the format: findwordSPLITreplaceword The VBA code then processes the sequence of lines and keeps replacing "findword" with "replaceword". The sample text file is attached and its contents are: ?SPLIT&agr; ?SPLIT&bgr; ?SPLIT&khgr; Whenever I try to get the "findword" using a command like: SPL=split(EachLine,"SPLIT") msgbox strconv(SPL(0),vbfromunicode) ' Shows me gibberish for alpha and gamma BUT works for beta! The problems happen only for some unicode symbol fonts and work for all other normal fonts and most symbol fonts. My question is, if I need to have a file that may contain unicode characters and is saved in unicode format and I need to be able to do find and replaces the way mentioned above, what would be the best method? I have no idea why this doesn't work for alpha and gamma and works for many others! Thanks for your thoughts on this. Vince begin 666 test2.txt M__ZQ`U,`4 !,`$D`5 `F`&$`9P!R`#L`#0`*`+(#4P!0`$P`20!4`"8`8@!G E`'(`.P`-``H`QP-3`% `3 !)`%0`)@!K`&@`9P!R`#L`#0`*```` ` end Tag: Transposing word doc into Excel doc Tag: 74179
  - 4
    - Running two instances of Word at the same time Can this be done? I've got some VBA scripts to run on about 800+ MIF files, and I want to run the simple ones in one instance, and the complex one in another instance (it has to be babied). Tag: Transposing word doc into Excel doc Tag: 74178
  - 5
    - saving autotext to normal.dot I have a large autotext list with addresses etc. This has been saved to an alternated file named normal2.dot. Now when I add a new auto text or change an existing one it does not save it except in the current session of word. next time it is turned on it will be gone. It says normal.dot is read only but when I look at properties it says it isn't. It doesn't appear to be saving to the alternate file either. Also, the auto text doesn't appear automatically (although it used to). Everytime the machine is rebooted I have to go to templates and add-ins and select the extra file. Is there a way of making this a default. A Any ideas please Thank you Tag: Transposing word doc into Excel doc Tag: 74175
  - 6
    - Greetings, problems with setting a bookmarked textbox value...it's protected? Hi all, I've been writing code in various environments, in varying application, for a wide range of customers, for about 35 years now and I'm still learning new stuff. ;) This week I'm helping a friend create a Word document template (Word 97) that stores a bunch of answers to questions in the registry (Using SaveSetting and GetSetting). In this document, as a part of the startup processing (AutoNew), I want to load the stored values back into the bookmarked places where they belong. The problem is I'm getting a error saying the location is protected. From what I understand of this, yes it is! I've protected the document so the body cannot be modified...but I want to be able to enter text/values into those places where I've defined fields (such as Textboxes, Checkboxes...et al) Here's the code I have so far, the error comes from this line: BkMrkRng.Text = RegVal <code> Option Explicit Private BkMrk As Bookmark, BkMrkRng As Range Sub AutoNew() Dim sBMName As String, S1 As String, S2 As String, RegVal As String For Each BkMrk In ActiveDocument.Bookmarks sBMName = BkMrk.Name S1 = Mid(sBMName, 1, Len(sBMName) - 1) S2 = Mid(sBMName, Len(sBMName)) RegVal = GetSetting("MBD", S1, S2, vbNullString) If RegVal <> vbNullString Then Set BkMrkRng = ActiveDocument.Bookmarks(sBMName).Range BkMrkRng.Text = RegVal ActiveDocument.Bookmarks.Add sBMName, BkMrkRng End If Next BkMrk End Sub </code> Hints: I've used the bookmark name, split into 2 strings, to name the Section and Key for the SaveSetting function so I can easily retrieve the values. I've learned that by setting the text value of a bookmark it clears the bookmark itself, therefore making it necessary to Add the bookmark back in after setting the text value. Thanks for any help, Shell (Yes, this is my real name) Tag: Transposing word doc into Excel doc Tag: 74166
  - 7
    - =?Utf-8?Q?File=2C_Setup_=E2=80=93_Margins=2C_Paper=2C_La?= I prefer to work keyboard-driven as opposed to mouse-driven. In Word 2003, under File, Setup, the subheadings Margins, Paper, and Layout do not have alt+key strokes, so I have to take my hands off the keyboard to use the mouse to select them. Please fix. ---------------- 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=8cef4bda-d47d-4572-92fe-f9201b4425cb&dg=microsoft.public.word.vba.general Tag: Transposing word doc into Excel doc Tag: 74163
  - 8
    - How do I wrap drop-down items in a Word 2003 form? A textinput field will wrap in a form, but the contents of a drop-down will not. Tag: Transposing word doc into Excel doc Tag: 74162
  - 9
    - Using Access as Data Source I am creating a Word template with a userform. The form features a combo box populated with 175 manufacturers (using .AddItem). When a manufacturer is selected, I would like text boxes elsewhere in the userform (for Contact Name, Address, Phone) to update with the chosen manufacturer's information. This gives the user a chance to verify this information before clicking OK and feeding it into various areas of the document. Rather than writing 175 Select Case statements to populate the text boxes, I'm thinking that since I already have the contact info in an Access db called CompanyInfo in a table called Contacts, I could somehow use this table to feed the text boxes. My problem is I don't know the code needed to call the table and have it populate the text boxes. How do I do this? Thanks! Tag: Transposing word doc into Excel doc Tag: 74160
  - 10
    - how to create a table from info from several documents I have 1000 Word 97 documents. I want to "get" the name and address information from them (all located in same positions in docs) and create a TABLE to use for Mail Merge in the future. HELP. I also have Word 2003 and and received an email from a MVP with a Global macro (Finda & ReplaceAll) but need more help on modifying it to work with this. I am NOT very good with using macros. Tag: Transposing word doc into Excel doc Tag: 74159
  - 11
    - Customize Task Pane in Word 2003, or alike toolbar Hi MS people, At our firm we have about 10 templates that I want to display when word starts up in the taskpane to the right, instead of the normal one, either customize the old one or maybe make a new one ( dont know how, there does not seem to be a easy way to add files/dirs so the user can easily click and open the templates ) How the question is, are there a way to customize the Task Pane, add direct links to files, or do I have to make one myself, and how? The best link describing a little of the same problem I have is this one, but its not that I'm looking for.... but close... http://www.mcse.ms/message481718.html best regards Mikael Syska Tag: Transposing word doc into Excel doc Tag: 74158
  - 12
    - Macro not listed in OnExit dropdown box; why? Hello there. After creating the same macro (titled "SelectCheckbox") in both Normal.dot and in my template document titled "Expenses.dot", I then created a checkbox field. When I clicked the checkbox's OnExit dropdown box and scrolled down to find SelectCheckbox macro, it wasn't there. I even tried to look at one of the NewMacros, but it wasn't there either. SelectCheckbox is not a Public Sub by the way. Can anyone tell me why the SelectCheckbox macro wasn't listed under the OnExit dropdown box? Also, I find it exasperating that the width of OnExit dropdown box is so narrow that a long macro name is truncated. What gives with that? Thanks! Tag: Transposing word doc into Excel doc Tag: 74153
  - 13
    - display a pdf file while in Word I am trying to add a command button that will display a .pdf file while I am in Word. I would also like to be able to use a command button to start a Flash application. Tag: Transposing word doc into Excel doc Tag: 74152
  - 14
    - Obtaining full name in VBA How can I obtain the first and last name of the logged in user from within VBA. I know that Environ("Username") will give the username, but there is no such entry for the users full name. Thanks, ~ d Tag: Transposing word doc into Excel doc Tag: 74150
  - 15
    - AutoText and Image question (Report for Database) Let me explain what i'am doing. I'd like to use Microsoft Word as a report generator for my database. (I created a VB6 application that creates and has access to a Microsoft Access database ) One of my fields contains links to photos (full path). I want to print/save every record on a new page. (One photo (with some text) per page in one single document) I created a Ms Word template with bookmarks (within cells) for my fields and has access from my VB application to this document. I create a new page for every new record from my database and use AutoText to create new Bookmarks. First question: If Ms Word is already active, the AutoText fails (Error numer 5825, The object is removed (translated from Dutch)) What can/must i do to prevent this ? (This error only occurs when Ms Word is already active) Second question: Is it possible to define the photo size in my template. (I has to resize the original photo to approximately 13 x 17 cm) When the original photo is 2272x1704 everything goes well. The photo fills the cell. (about 13x17 cm) But when the original photo is 800x600, it doesn't fill the cell) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Some code i'am using: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Dim WordObj As Word.Application Dim WordDoc As Word.Document Dim WordRange As Word.Range Set WordObj = CreateObject("Word.Application") Set WordDoc = WordObj.Documents.Add(App.Path & "\report.dot") WordObj.Visible = False ' The code below will place the text/photo in the bookmarked location 'DESCRIPTION Set WordRange = WordDoc.GoTo(What:=wdGoToBookmark, Name:="description") WordRange.InsertAfter rs!description 'PHOTO Set WordRange = WordDoc.GoTo(What:=wdGoToBookmark, Name:="photo") WordRange.InlineShapes.AddPicture Filename:=rs!filename, LinkToFile:=False, SaveWithDocument:=True ' The code below will go to end of page, create a pagebreak and insert the AutoText Selection.EndKey Unit:=wdStory Selection.InsertBreak Type:=wdPageBreak WordDoc.AttachedTemplate.AutoTextEntries("MyAutoText").Insert Where:=Selection.Range, RichText:=True - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks in advance, Robertico Tag: Transposing word doc into Excel doc Tag: 74142
  - 16
    - AutoText and Image question (Report for Database) Let me explain what i'am doing. I'd like to use Microsoft Word as a report generator for my database. (I created a VB6 application that creates and has access to a Microsoft Access database ) One of my fields contains links to photos (full path). I want to print/save every record on a new page. (One photo (with some text) per page in one single document) I created a Ms Word template with bookmarks (within cells) for my fields and has access from my VB application to this document. I create a new page for every new record from my database and use AutoText to create new Bookmarks. First question: If Ms Word is already active, the AutoText fails (Error numer 5825, The object is removed (translated from Dutch)) What can/must i do to prevent this ? (This error only occurs when Ms Word is already active) Second question: Is it possible to define the photo size in my template. (I has to resize the original photo to approximately 13 x 17 cm) When the original photo is 2272x1704 everything goes well. The photo fills the cell. (about 13x17 cm) But when the original photo is 800x600, it doesn't fill the cell) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Some code i'am using: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Dim WordObj As Word.Application Dim WordDoc As Word.Document Dim WordRange As Word.Range Set WordObj = CreateObject("Word.Application") Set WordDoc = WordObj.Documents.Add(App.Path & "\report.dot") WordObj.Visible = False ' The code below will place the text/photo in the bookmarked location 'DESCRIPTION Set WordRange = WordDoc.GoTo(What:=wdGoToBookmark, Name:="description") WordRange.InsertAfter rs!description 'PHOTO Set WordRange = WordDoc.GoTo(What:=wdGoToBookmark, Name:="photo") WordRange.InlineShapes.AddPicture Filename:=rs!filename, LinkToFile:=False, SaveWithDocument:=True ' The code below will go to end of page, create a pagebreak and insert the AutoText Selection.EndKey Unit:=wdStory Selection.InsertBreak Type:=wdPageBreak WordDoc.AttachedTemplate.AutoTextEntries("MyAutoText").Insert Where:=Selection.Range, RichText:=True - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Thanks in advance, Robertico Tag: Transposing word doc into Excel doc Tag: 74141
  - 17
    - Macro on Folder and Subfolders Hi, with the help of another post I am trying to combine two macros into one to execute the macro on a folder of .doc files. Here is my code that has a bug: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 22/09/2005 by Warringah Council for folder macro on Position Descriptions With Application.FileSearch .NewSearch .LookIn = "C:\Documents and Settings\gilleg\Desktop\testPDF\" .SearchSubFolders = True .FileName = "*.doc" If .Execute() > 0 Then For i = 1 To .FoundFiles.Count With Selection.Find .Text = _ "<http://intra.warringah.nsw.gov.au/pdf/oh&s/GM Ohsrprocedures201 OHSR Respon.pdf>" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll With Selection.Find .Text = _ "http://intra.warringah.nsw.gov.au/pdf/oh&s/GM Ohsrprocedures201 OHSR Respon.pdf" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll Selection.Paste Next i End If End With End Sub Thanks. Tag: Transposing word doc into Excel doc Tag: 74133
  - 18
    - Unlinking a document from the template Hi Group Once again I'm trying to let people use my templates not only at work, but at home as well. To make things complicated, they shouldn't need to take the template with them. So, I need to get things out of the template and into the document. Three problems arise: 1) There can't be autotext in a document (right?), so I'll have to unlink the autotext entries from the template and insert them directly into the document. 2) Macros, Toolbars, Menus: I'll have to copy them to the document in Document_new. 3) Styles are automatically copied by word and only updated from the template on request. So, for once, Word is working with me. So, my questions are: Is this all right? Isn't there an easy way of doing all this? And: how can I do 2) right? E.g. I can't see any means of enumerating all macros (and forms, and toolbars, etc.) in a certain document. Thanks for any input! cheers, Bernhard Tag: Transposing word doc into Excel doc Tag: 74130
  - 19
    - Can I print a document so that the print is in reverse I want to try and make my own rubb-off lettering and need to print a document so that the letters are reversed. I am using Windows ME. Tag: Transposing word doc into Excel doc Tag: 74125
  - 20
    - Macro allowing user to select one of two templates I need to create a macro that has two option buttons. If the user selects the first option button, a specific template using singular language will run. If the user selects the second option button, a specific template using language for multiple signers will run. Tag: Transposing word doc into Excel doc Tag: 74116
  - 21
    - Word Screen Refresh When I open a template I have created with a picture logo and macros in it, the screen refresh is really slow. Is there any way I can make this quicker? Thank you. Tag: Transposing word doc into Excel doc Tag: 74114
  - 22
    - Last Modified doc property? Is there a property like LastSaveTime that I could use but that it shows only the the date of the last save or last modified? I really dont need to show at what time was modified Thanks in advance. Tag: Transposing word doc into Excel doc Tag: 74113
  - 23
    - Dropdown List Values In a "protected" Word2000 form template using Tables: I have a drop down list in a Cell containing only 5 items: 1, 2, 3, 4 and 5 When someone clicks on the dropdown and selects one of the numbers, I want to place a numeric value represented by the number in the dropdown in another column. This value will ultimately be totaled in a column at the bottom of the form. This is replicated 25 times on the form, so would like to use cell references in the formula. Example: IFB1=1,0.00,0.00 IFB1=2,0.25,0.00 IF B1=3,0.50,0.00 IF B1=4,0.75,0. 00 IF B1=5,1.00,0.00 Basically: IF, THEN, ELSE - I understand the concept, just don't know where quotes, brackets and commas should go so Word interprets it correctly. Can this be written as a nested IF statement? I believe it falls under the 7 items rule. The cell reference in the formula would have to be changed for each of the 25 instances in the table. Help in constructing this so it works would be appreciated.... My thanks and Best regards -- Message posted via http://www.officekb.com Tag: Transposing word doc into Excel doc Tag: 74111
  - 24
    - Do you wish to discard changes to ... and load the latest version? Hello- We are experiencing a problem with Word 2003 involving word documents that either contain macros and/or merge documents when we open them from our software. Our software just calls word and opens the document and prior to using the combination of our newest release of our software and Word 2003 we have not had a problem. Nor do we have a problem with the document UNTIL we save it in word 2003. If the document was created in office 97 through 2002 the document initially opens fine, but once we save it in Word 2003, anytime there after when we open it from our software we get the message 'Do you wish to discard the changes to <file name of the document being opened> and load the latest version?. If we say no, the document loads but reverts to a normal document instead of a mail merge main document and the autoopen or document_open macros to not fire. If we say yes to revert, the standard (2003) security message comes up - 'Opening the document will run the following SQL command:' and it opens normally and macros behave normally. I have made sure to remove all personal information from the document, accepted all changes and turned of change tracking, turned off fast saving, and stopped storing a random number to improve merge accuracy to no effect. Our software works fine with these documents in prior versions of word (97, etc), even after being saved by Word 2003 and we have tried this on Windows 2000, Windows XP, and Windows 2003 Server. Any ideas anyone might have would be greatly appreciated. Thankx, -- Scott Lowden Tag: Transposing word doc into Excel doc Tag: 74109
  - 25
    - can i format a word cell like formatting an excell field. I would like to be able to format a word cell like formatting an excel field. example is by typing in excel Sep21, I can format it to show as Wed Sept 21. I am using office 2000 Tag: Transposing word doc into Excel doc Tag: 74108
- Next
  - 1
    - Insert rtf formatted text Hi Is ther any method to insert .rtf formatted text into a word document other than inserting an existing file (which I believe is quite slow) Thank you, Shmuel Shulman Tag: Transposing word doc into Excel doc Tag: 74107
  - 2
    - Footer Dates We have several dozen documents in one folder (G:\Specs)where the same footer information was inserted on each page. Among that information is a date (manually typed -- it is not a Date field), which is the same for each document in that folder. What we want to do is if the footer date in all of these documents needs to be changed, run a macro that opens each document, seeks out the date in the footer and replaces it with whatever date we want (provided by perhaps an Input Box). The format of the date is typically 09-21-05, but also may be 09/21/05. Can anyone give me some ideas? Thanks! Tag: Transposing word doc into Excel doc Tag: 74104
  - 3
    - VB or VBA code for permutations Could you please help with writing a VB or VBA code for permutations: Context: There are some sentences in Word that will be selected by a user. The result should be a permutation (only one, not all of them) of these sentences (i.e., sent4, sent2, sent1, sent3 instead of the initial sent1, sent2, sent3, sent4). Thank you in advance for every help. Tag: Transposing word doc into Excel doc Tag: 74103
  - 4
    - Problem with Printing Word Documents I have a VB.NET application I wrote to assist users in printing groups of Word 2000 documents multiple times. Let say that 1 group consists of 10 word documents and I need 10 copies of the group, 100 documents total. When these documents are printed, some of the pages within the documents do not print completely. Incomplete printing would be, a document with a header and footer but no data or a document with only part of the pages data. The page or pages that are incorrect are not always the same. I have tested with several different print drivers as well as a few different printers. I believe that it is a Word issue, due to my last application change. I modified the application to print to a file and the same thing is happening. I am using Word 2000 SP3. Any help would be appreciated. Thanks Tag: Transposing word doc into Excel doc Tag: 74102
  - 5
    - Getting AutoIncrement Number I want an auto increment number on my document exactly where the cursor stays. For example while typing a text I need a autoincrement number (using as a reference number of a document) sometime on the 1st line, sometime on 6th line of the text or some time in next paragraph. Therefore I am looking for a solution to get auto increment number exactly where my cursor stays (any where in the document). Please advise. Regards. Irshad. Tag: Transposing word doc into Excel doc Tag: 74099
  - 6
    - how to programmatically select a certificate to sign a word Docume Dear all, I would like to find the way to select programmatically the right certificate in my store before issuing the digital signature. It looks like it is quite challendging because the set signature=activedocument.signatures.add command does pop up a listbox to manually choose a certificate from . I would like to bypass this and be able to select programmatically the certificate to issue a digital signature from with some conditions on issuer and signer and has private key properties (for example). Must I use Capicom objects instead ? Is it the same if I make a signature from capicom versus from Word internally ? any code snippet to solve my issue or to show me the way is more than welcome Best regards Herve Cadieu Paris Tag: Transposing word doc into Excel doc Tag: 74096
  - 7
    - Paste a bitmap from VB.NET2005 to Word2000 I am trying to paste an image in a pictureBox in vb.NET to a Word document. When using the paste method, the image quality in Word is bad. If using pasteSpecial method, all the dataType, like wdPasteBitmap or wdPasteEnhancedMetafile, etc. are not available. The code is as follows: wdApp = CreateObject("Word.Application") wordD = wdApp.Documents.Add My.Computer.Clipboard.Clear() My.Computer.Clipboard.SetImage(bm) wordD.Sections.Item(1).Range.PasteSpecial(Link:=False, DataType:=Word.WdPasteDataType.wdPasteShape) Does Anyone know how? I also find that when using pasteSpecial to paste a picture to Word, the foramt of JPeg, Png, etc are not available until you cut the pasted picture and do the pastSpecial again. Thanks. -- I like Vb. Tag: Transposing word doc into Excel doc Tag: 74094
  - 8
    - What is the difference between the two different Save methods? When I save the modified document, I find the Save button on the General Toolbar is different from the Save command in VBA code. The document size is smaller when using the Save button to save. I wonder what is the difference? Any reply is appreciated. -- Tag: Transposing word doc into Excel doc Tag: 74093
  - 9
    - Calling MS Word Mail Merge with Database Password How do I call an MS Word Mail Merge document from VB.NET so it does not ask the user for the MS Access Database Password? (not user password) I am performing Word XP automation from a VB.NET program. The Word document is set up to mail merge against an Access XP database. The Database has a Database Password on it. Without the database password, the document comes up just fine and without any user interface intervention from MS Word. I have tried a couple of commands that still popup the enter password dialog: 1.) mWordDoc.MailMerge.OpenDataSource( Name:="C:\Develop\TestMSWord\TestMSWord\bin\Docs\mydb.mdb", LinkToSource:=True, PasswordDocument:="mypassword", SQLStatement:="TABLE SellerInfo") 2) mWordDoc.MailMerge.OpenDataSource( _ Name:="C:\Develop\TestMSWord\TestMSWord\bin\Docs\mydb.mdb", _ PasswordDocument:="mypassword", _ Connection:="Provider=Microsoft.Jet.OLEDB.4.0;Data Source & _ "C:\Develop\TestMSWord\TestMSWord\bin\Docs\mydb.mdb;" & _ "User Id=admin;Password=;Jet OLEDB:Database Password=mypassword;", _ SQLStatement:="Select * from `SellerInfo`") Thank you. Tag: Transposing word doc into Excel doc Tag: 74091
  - 10
    - Does the free Microsoft Word Viewer have an open API? I would like to use the viewer, but want to hide the menu and toolbars so factory personnel do not have acces to navigate on the network. The Word documents will be opened from a customized program, so all opening operations are dictated outside of the viewer itself. Tag: Transposing word doc into Excel doc Tag: 74079
  - 11
    - load form into word upon opening I have a form that I have created in word using VBA, how do I call it up automatically when MS Word opens? What is the code and where do I put it? Thank you, Tag: Transposing word doc into Excel doc Tag: 74078
  - 12
    - HOW DO I TRANSLATE A ENGLISH DOC. TO FOREGIN LANGUAGE Trying to convert same english text to forgein language - chinese, ukrainian, and spanish Tag: Transposing word doc into Excel doc Tag: 74077
  - 13
    - how do I create a database using the word 2003 toolbar I am using Word 2003. I want to create a database using the database toolbar that is in Word 2003. Once the database is made I cannot save it unless I close the dbase screen. The screen that is left open shows my dbase setup i.e name, address etc. How do I save the dbase so that when I call it up to use it all I have to do is fill in the Blanks? Tag: Transposing word doc into Excel doc Tag: 74070
  - 14
    - How to select programmatically the digital certificate for signing Hi all, I would like to know how to select programmatically (VBA) one specific certificate to issue a word doc signature , the certificate could be either in mystore or smartcard or LDAP I would like to parse the available certificates properties like issuer , common name, etc.. to select the precise certificate I would like to use for signing purposes. When using the (addsign macro) set sig=activedocument.signatures.add instruction it displays a listbox but I would like to avoid this listbox and select programmatically the certificate instead. Any suggestion with code snippet is very welcome Best regards Herve Cadieu Tag: Transposing word doc into Excel doc Tag: 74068
  - 15
    - Is it possible to call and use MSWORD in command line mode? Hello all, Actually I would like to use the "Compare and modify" function in Word and Excel, but instead of opening the word application to complete the task, is there anyone know how to do it in command line mode? like c:\..\MSWORD c:\test1.doc c:\test2.doc "Compare and modify" or I need to write a VB program to call the function in MS office? Any comment, suggestion? or any related document for reference? Thanx so mush for your help MK Tag: Transposing word doc into Excel doc Tag: 74064
  - 16
    - Apply formatting to XML Tag Hi, Could anyone help me with these please I have the following situation: The user has a blank word document with a schema attached and has to add text to that document and tag the text accordingly. Now, i want to show each tag he adds with a different style. For eg, if he tags text with the <title> tag, i would like these texts to be displayed in bold with green highlight. he tags text with the <subtitle> tag, i would like these texts to be displayed in italic. Is there a way to achieve this? Thanks Alicia Tag: Transposing word doc into Excel doc Tag: 74061
  - 17
    - Error whilst fields are updating I have designed a report template using ASK fields (the report cannot be protected and tables are not practical). A macro placed in the ThisDocument module prompts the ASK fields and it all works beautifully except that whilst the prompts for the ASK fields are on screen you can see the document behind and where the bookmark for the ASK fields are it displays "Error Bookmark not Defined" - however when they are all filled in the error disappears and the data that was typed in the boxes appears in the correct fields, but I can't have users seeing the error messages it would confuse them. I have tried all sorts of ways but cannot find how to hide the window whilst the fields are updating. I've tried Application.ScreenUpdating = False, but it didn't work. Anyone have an idea? The code is: Sub AutoNew() Dim oStory As Range For Each oStory In ActiveDocument.StoryRanges oStory.Fields.Update If oStory.StoryType <> wdMainTextStory Then While Not (oStory.NextStoryRange Is Nothing) Set oStory = oStory.NextStoryRange oStory.Fields.Update Wend End If Next oStory Set oStory = Nothing Selection.GoTo What:=wdGoToBookmark, Name:="StartDoc" End Sub Thanks for looking at this. Jeanmac Tag: Transposing word doc into Excel doc Tag: 74060
  - 18
    - refreshing image in ms word using vba I am dynamically changing the image property of a picture box in word with something along the lines of... LoadPictureToDocument ActiveDocument, "imgMenu", strImage This is working, however it won't 'refresh' the page so to speak. When you minimize word then restore it the image has changed, or if you scroll to the bottom of the page then back up it refreshes. Is there some sort of form.refresh type function using vba in word? Thanks Dan. Tag: Transposing word doc into Excel doc Tag: 74056
  - 19
    - My Normal template not working in a different computer Last week I copied my normal template from my computer (with Word 97 and Windows 98) to another computer at a friend's house where I was staying (with Word 97 and Windows XP). Many of my macros didn't work. When I ran them I got this error message: "Compile error. Can't find project or library" When this happens to a macro, the highlighted text in the macro always involves the character code symbol, like this: Chr(30), for example, Selection.MoveEndWhile cset:=",.!? """ & Chr(13) So I guess I needed some special reference to be checked which would allow this computer to handle the character code symbol. Also, with many macros, I got this error message: "Compile error, can't find project or library" With other macros, I get message "Can't open macro storage." Even though the templaste containing the macro I was trying to run would open to that macro. I'm no longer working at the XP computer, but to avoid this problem in the future, does anyone know what I was doing wrong? Thanks, Larry Tag: Transposing word doc into Excel doc Tag: 74054
  - 20
    - refreshing image in ms word using vba I am dynamically changing the image property of a picture box in word with something along the lines of... LoadPictureToDocument ActiveDocument, "imgMenu", strImage This is working, however it won't 'refresh' the page so to speak. When you minimize word then restore it the image has changed, or if you scroll to the bottom of the page then back up it refreshes. Is there some sort of form.refresh type function using vba in word? Thanks Dan. Tag: Transposing word doc into Excel doc Tag: 74053
  - 21
    - Load Fields on a Form with Button Click? I have fields in a word document template that I would like to allow the user to fill in. Then with a button click, I would like to copy the data from those fields that the user filled in to other areas (fields) on the same form to be used as prompts for additional input. I can read the user inputs from the initial bookmarked fields with the dim x as string ActiveDocument.Bookmarks("fred").select x=Selection.text I cannot see how to load another field with the x text Something like : ActiveDocument.Bookmarks("fred1").select Selection.text=x This removes the fred1 bookmark and the associated field. Tag: Transposing word doc into Excel doc Tag: 74051
  - 22
    - water marks on word document On a word document there are sample water marks available on the system. How do I make my on water mark (e.g. my name) and put it diagonally on the document? If I want to put my hand writing there how do I do that? Tag: Transposing word doc into Excel doc Tag: 74049
  - 23
    - Variables and scope ? !!!! I wonder if some one can clarify if it is possible I want to set a global or constant in word at the start of a document / module in vba is this possible I understand to set a variable i use the "public" and if i require a set value that i would use the "const" But how do set a variable to the whole document which refers to a table something like const tblEmployees As Tables = ActiveDocument.Tables(1) or this is poor coding or bad practice... ? if ppl have any tutorials or links which might help it all become clear many thanks Tag: Transposing word doc into Excel doc Tag: 74048
  - 24
    - msword 2003 chgs ' when text is programmably inserted into msword I am programmably populating a MSWORD html template which has tags inserted in the html. All is well and good except for apostrophe and perhaps a few other characters. Instead of converting to ' word changes the ' to Ã¢â?¬â?¢ . In the browser this is what you get. Anyone have explanation and fix? -- Thanks, StanD Tag: Transposing word doc into Excel doc Tag: 74045
  - 25
    - RTF images conversion Hi, I'm working with an application which automatically generates an RTF document using the JFOR library. The problem is with Word 2003: an image file (our company logo) appears at the top of the page, as designed, but is resized to 2% of it's original design. This means that the conversion ignores the width and height dimensions set in the RTF. Previous versions of Word work fine and the imaged are rendered correctly. Can anyone tell mw how to correct this? Or why this happens? Our users were very confused and thought that the image didn't get placed in the document at all. Of course, I didn't even know our image was there until I viewed the document at 500%. Please help. Tag: Transposing word doc into Excel doc Tag: 74042

If I have a word doc that my employees need to fill out and then I need the
information they put in to be able to be transposed into an Excel doc, is
this possible and if so how do I do it?

Thanks,

Top

Re: Transposing word doc into Excel doc by Anne

Anne
Fri Sep 23 13:20:56 CDT 2005

The only way I was able to accomplish this, Liz, is to copy it (a table, in
my case), then go to Excel and Edit-->Paste. Then copy, then go to a new
sheet and Edit-->Paste special-->Transpose.
************
Anne Troy
www.OfficeArticles.com

"Liz" <Liz@discussions.microsoft.com> wrote in message
news:BAF7253F-F09C-475D-B79A-E825617AFC53@microsoft.com...
> If I have a word doc that my employees need to fill out and then I need
> the
> information they put in to be able to be transposed into an Excel doc, is
> this possible and if so how do I do it?
>
> Thanks,
>
>

Top

Re: Transposing word doc into Excel doc by Liz

Liz
Fri Sep 23 13:31:08 CDT 2005

Anne,

That sounds good but, my problem is my contracts person has a word doc that
employees need to fill out, but our vp wants the info they put in the word
doc to be able to some how automatically be able to be transposed into his
Excel doc. I don't believe it can be done, but it's worth asking.

Thanks so much,

Liz Burns

"Anne Troy" wrote:

> The only way I was able to accomplish this, Liz, is to copy it (a table, in
> my case), then go to Excel and Edit-->Paste. Then copy, then go to a new
> sheet and Edit-->Paste special-->Transpose.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Liz" <Liz@discussions.microsoft.com> wrote in message
> news:BAF7253F-F09C-475D-B79A-E825617AFC53@microsoft.com...
> > If I have a word doc that my employees need to fill out and then I need
> > the
> > information they put in to be able to be transposed into an Excel doc, is
> > this possible and if so how do I do it?
> >
> > Thanks,
> >
> >
>
>
>

Top