Threads Replies Last Post 8 Pages: 1  2  3  4  5  6  7  8   FAQ - frequently asked questions - vba - please read before posting - unofficial December posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted weekly.- more or less Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non-... 4 12/21/2005 7:30:32 PM disk cleanup problem Hello, When I run Disk Cleanup, I can't delete the following : I have 32KB in WebClient/Publisher Temporary Files & 175,60K Compress old Files that I can't clean up. I've tried more times than I can count and really need help. I'm sure this is slowing my system down. I have 32KB in WebClient/Publisher Temporary Files & 175,60K Compress old Files that I can't clean up. I've tried m... 2 12/19/2005 3:48:23 AM Read word document text page-by-page Hi Is there any method by which I can read a word file from my VB application page-by-page? Currently, I can open the file and save the text as a text file, but what I need is a way to know the page numbers, so I though instead of saving the text as a text file, I might be able to read the text from the word file page-by-page and add the page numbers then save the text to a text file... 2 12/12/2005 9:01:09 PM PDF four versions of a document then delete interim saved Word files I posted this the over in microsoft.public.word.vba.general but didn't get what I needed so I thought I'd try here. The answer I got over there was unworkable because I don't have access to the users' computers to configure their PDF conversion settings. Thanks Mike So I'm working on this template and the client wants it to have the ability to make PDFs of four different versions of the... 3 12/8/2005 4:58:04 AM error message from lost certificate hello, quick question about VBA and certificates. we have signed a bunch of documents with a certificate. the certificate has expired. and now we are running a batch job on some groups of documents that have been signed. when running the batch job we are getting message boxes for each documet: "there was a problem with the digital certificate. the vba project could not be signed. t... 4 12/4/2005 3:44:06 PM FAQ - Frequently Asked Questions - vba - Please read before posting - unofficial December posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted weekly.- more or less Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non-... 1 12/2/2005 1:04:00 PM convert symbol map char to Unicode Word 2000 I woul like to write a macro that looks for characters in a document that are inserted from the symbol map and converts them to unicode. Can someone help me? Many thanks, Carmen... 5 11/29/2005 12:42:39 AM Changing RTF file to Word Document I save an Access report as a RTF document and would like from within Access to convert it to a Word document. I set up the code in Access as follows but it does not save the file. Can anyone help ? strF1Month = "FileName" Set docSource = wdApp.Documents.Open(strF1Month) docSource.SaveAs FileName:=strF1Month, FileFormat:=wdFormatDocument ... 3 11/26/2005 1:56:01 AM FAQ - frequently asked questions - vba - please read before posting - unofficial November posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted weekly.- more or less Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non-... 4 11/25/2005 2:57:03 PM Insert Generic text starting from a bookmark Greetings, I have a document (template) where i need the user to be prompted for how many entries of some information will be appended (inserted) into there document. I need to spell it out for them where the heading is and where to insert the file. So for example if the user needed to insert 5 seperate files into this document the user would type in the number "5" and then the macr... 2 11/22/2005 10:43:32 AM Deleting last letter if a cell What I'd like to do is, if the last letter of what is inputed into a cell is the "+" symbol. Then delete it. I have a cell defined by: Sheet12.Cells(11, 2) = d & "+" + l & "+" + w & "+" + s Here's what i get fromt that cell. ..5D + 2L + 3W + 2S if i change it and s = 0 i get ..5D + 2L + 3W + i want to get ..5D + 2L + 3W So i was hoping maybe there was a command, to delete a spa... 2 11/19/2005 10:38:09 PM Deleting last letter if a cell What I'd like to do is, if the last letter of what is inputed into a cell is the "+" symbol. Then delete it. I have a cell defined by: Sheet12.Cells(11, 2) = d & "+" + l & "+" + w & "+" + s Here's what i get fromt that cell. ..5D + 2L + 3W + 2S if i change it and s = 0 i get ..5D + 2L + 3W + i want to get ..5D + 2L + 3W So i was hoping maybe there was a command, to delete a spa... 1 11/18/2005 8:35:11 PM Intercept Macro-Record Dialog Hi, I would like to limit the macro functionality of Word 2003 in such a way that users can save their macros only to a particular template, different from normal.dot. Two ways come to my mind, either modify the Macro-Record Dialog so that the "normal.dot" template is not shown, or (better) not show such a dialog at all but directly record to the specified template. However, both solutions s... 10 11/16/2005 10:58:05 AM Applying styles not working properly? I'm writing a C# app that allows exporting to a Word doc. I figured out how to create the paragraphs and tables, and setting styles works from the code perspective. However, when I open the document none of the styles are applied. For instance, instead of a paragraph being "Heading 1", it will be "Normal + 16pt" and similar for everything else. The strange thing is that if I do exactly the ... 2 11/15/2005 1:17:32 AM Track Changes not working in word Hi, I have an document in which I have written VBA code to accept/reject the changes that were made to the document using the track / revisions functionality in word. I am facing some problem wherein I am not able to accept/reject some of the revisions that were made to the document. Can anyone help me why this is happening. I have no idea on this. Regards Sudhakara.T.P.... 2 11/13/2005 5:51:26 AM Better Copy and Paste in word for tables I wrote a macro that retrieves data from a database, populates a table using bookmarks and then copies this table and pastes it at the end of the document before moving to the second row of data. I am looking for improving the efficiency and performance of this macro. 1. Is there a better copy and paste algo for tables 2. can i clear the clipboard between each copy and paste. will it ... 1 11/12/2005 7:06:24 PM Disable Task Pane I am using Word 2003. I dont want Task Pane from appear at all. I have a template that give restricted acess to users but with the access to Task Pane users are able do lot things that they are not supposed to do. Whenever they press F1 key for help, Task Pane opens and gives them access to the following Task Pane menus and this is basically breaking our customization. Task Pane Menu... 2 11/11/2005 7:54:42 PM Not able to call a function from custom menu item that is added in word menu(File) Hi, We are in the process of building VSTO 2005 customizations for MS Word 2003. One of our requirements is to add menu items to both custom menus (say MyMenu) and existing menus (say File) Scenario 1: We create a menu called MyMenu after Help menu in Microsoft Word 2003. We add TestMenuItem under MyMenu and call a function which displays a message box in TestMenuItem's click event ... 1 11/9/2005 5:36:54 AM Avoid dialog SaveAs when closing a document Hi all. I have a document called from access 2000 via vba. Two possibilities allow the user to print it (as single or double copy). Anything else is disabled ( thanks to help of some clever guys here !!) Now, my final problem is, that when a user clicks the X in the top right corner of a word document, how to avoid the upcoming dialog save (yes,no,cancel) . I tried the AutoClose event:... 3 11/8/2005 11:46:15 AM How to hide all menus and toolbars cross-posted in menustoolbars Hi all. I have a template that gets called from within vba.... In this template I would like to hide all menus and commandbars and particularly features like 'save' and 'save as' from the user. The template should only be usable when called from my application ( it gets renamed to a *.dot before usage and destroyed afterwards) In order to make the c... 2 11/3/2005 7:05:18 PM move a control from one command bar to another I would like to move a control from one command bar to a custom command bar. The control is the "&Toolbar" control that resides on the "Standard" command bar in the "View" dropdown control. Sorry if my terminolgy is incorrect. More plainly, I have created a new command bar named TestTB on the top menubar. I would like to move the toolbar feature that is displayed when you go to View-Tool... 1 11/3/2005 6:39:02 PM How to make a routine that will automatically print a word file after it has been changed via an ole link to an excel file? Hello guys. I know nothing of programming and would like to know how can I make a routine that, as I said, would print automatically a word file after it's been changed via an ole link with an excel worksheet (that implies I've changed the excel file). I would like the routine to be on the excel file, so I won't need to open the word file everytime. Also, I made the ole link and it updates... 2 11/2/2005 12:23:06 PM Remove all contents from the Header of a document I have some documents that are being inserted into an exhisting document. Some of the documents have headers that are changing my template. Is there a macro to get rid of all contents in a header. Including any tables that might be in there? I mean anything that is in there. Please advise. thanks in advance. ... 9 10/31/2005 4:03:06 AM How to overwrite keyboard shortcut I have a Mac G4 and within the Word application, shorcuts are assigned to various keys of the keyboard. For example alt-a types the special character æ I want to assign another macro in Word to this keyboard combination. I successfully assigned macros to some key combinations, such as ctrl-alt-shift A, but when I want to assign a macro to some key combinations, the software does not let ... 2 10/28/2005 12:01:05 PM 8 Pages: 1  2  3  4  5  6  7  8