Search results for query: *

I am creating a MultiSelect listbox in Word 2003 and when the listbox is displayed, some of the items in the listbox are preselected and I have not been able to find out why. I do not want anything preselected. In my main module I have the following code: For i = 1 to FundNumber...

I'm using Word and Outlook 2000. I have a simple function that I use to send an email from Word. In the version I have below, it uses an Outlook template and it works just great. But now they've decided they want to add some textboxes to the Outlook template that need to be filled in by the...

We have a few users that continually open an excel spreadsheet in word even though they get the extra box that tells them it’s a spreadsheet. Then when they see it’s not what they want, instead of just closing it, they save it, and destroy the spreadsheet. Is there any way to turn off the...

If you have Word and Outlook open side-by-side, you can drag an email into the Word document. It inserts an envelope icon that opens the email when you double-click on it. I'm trying to do this samething through code. I can get it to the point where the correct outlook folder is open on the...

I have some code that we use all the time to send an email from Word. Usually I just put the text in the body of the email, or if they need to reference a file, I put a link in the body of the email. However, this email is going out-of-house and needs an attachment. The problem is it seems...

When a macro creates a document, I want it to go to the end of that document and insert a form and then run the macro that goes with the new form. I've tried: Selection.GoTo what:=wdGoToBookmark, Name:="plip" Documents.Add Template:="10-122test.dot" This works, but it creates a second...

We're upgrading from Word 97 to Word 2003. In 97 I could open a template, open the vb editor, make some changes in the code, (not saving them in case they were incorrect), put in some breakpoints, then go to File/New/General/ select my template, test run the macro and it would stop at my set...

We have a macro to create envelopes by pulling information from our databases. There are several options, but basically they all end with: With Dialogs(wdDialogToolsCreateEnvelope) .Addrtext = temp$ .Show End With We use pre-printed envelopes and on one of the...

Using Visual Basic template in Word, I am currently creating an email to be sent to a specific department. I'm using redemption to create the email and I'd like to pull a section of the document created from the template into the body of the email. I'd prefer not to create a separate document to...

I have a macro that opens a daily excel fixed length text file using VBA. This file is received from off-site. It is used by several users and if it is in use, the macro gives the alert box "File is being modified by another user. Open as read-only." I'm trying to bypass this alert...

I'm programming a Word Document where the user will input an Amendment Number. If they input "1st" or "23rd" instead of "First" or "Twenty-Third", the macro needs to convert it before inserting it into the document. Haven't been able to find a function...

I have an excel template that the Workbook - Open event has been set to call a macro attached to that workbook. After the macro runs, it saves the file in an .xls format. My problem is that when you open the saved file, the macro activates. I've been able to disable it for now by changing the...

We use a word macro to send an automatic email to an internal email group. Does anyone know how to have the signature block set up by the user included in the email created by the macro? Here is the code we're using to create the email: Dim olapp As Outlook.Application Dim nspNamespace As...

When a macro generates a document such as a letter, that (for example) has only 3 lines of text on the 2nd page, is there a way to have VBA determine how many lines of text are on that last page so that it can use the ActiveDocument.FitToPages command if applicable? Any help is appreciated

I'm new to writing macros in Excel. In Word if you have a template on the General Tab under File/New, it will automatically execute when you double-click on the icon. How do you get an Excel Macro on a template to excute from the General Tab under File/New? When I double-click on the icon it...