Lounge: Visual Basic for Apps

I am having issues with what should be a relatively simple macro, but I consistently get a Run Time error 4198 when trying to close a document. The macro works in debug mode, but not in runtime, so...

I'm using the GetAddress method to retrieve Contact info from Outlook (using VBA in Word.) If I work with one Contact at a time, I have no trouble. If I display the dialog box to use To: and CC:...

I have several monitors and I want to execute a shell command to start a program and specify which monitor the program appears. Is this possible?

I'm a technical writer who needs to add the page number after a hyperlink. Another help author had posted this question back in 2008 and ended up with a working macro. I used his macro and although...

I'm trying to debug a macro which is stored in my document, and I'm having difficulty with Word's security features. When I try to run the macro from the Macro icon in the Developer menu, I get a...

First of all, I am relatively new to visual basic. However, I'm trying to develop a countdown program for my friends video game. It's simple with buttons that stay overtop his game therefore he can...

My first post in this forum. I have been trying to establish exactly how to send an email from an excel application and all seems to work except how to specify the account to use. I have used...

I have a two-part payroll process where employee data is exported from an Access utility to an Excel file, whereupon the user runs an Excel macro of mine to put the data into the format required by...

Our VBA macro wants to offer the user to save a PowerPoint presentation in either PPTX format or PPT (97-2003) format. I'm not easily finding the enum for 97-2003. There's ppSaveAsDefault,...

Hi All I learnt to programme in Word using Woody's fantastic "Hacker's Guide to Word for Windows" books, and since then have moved and modified through various versions of Word a Global Startup...

Below is an old macro we've used for years that adds a second page header to letters with more than one page. It's worked well until we upgraded some users for Word 2003 to Word 2007. Now somehow I...

I need to access a SQL database on my laptop. I understand that SQLExpress is a good (and free) way to do this. I've looked into SQLExpress, and there are many versions. Can anyone recommend which...

Hi All, Rebrand time again. I have a macro that is updating a disclaimer in the footer of a letter. After inserting the disclaimer, I want to select the text that has just been entered and...

I want to add a solid bullet to a list box. I currently use AddItem ChrW(&H2610) for an empty box, but I can't find the proper hex code for a solid bullet. Can anyone help? Thanks, Richard Barrett

Hi once again, I hope someone can help. I have a workbook with a sheet named "0001". I wish to copy this sheet "x" times and incremently rename each sheet. For example, copy 4 times and have...

Hi all, In the following code for saving a Word object embedded in Excel, you have to first activate the Word object, run it and make it visible. But how do you deactivate the Word object to...

I'm trying to update just the page numbers in my word document using this macro: Sub UpdatePageNumber() ' ' UpdatePageNumber Macro ' Store cursor position and go to top of document Dim...

Hi all, I have received a project to write a VBA program to convert an Excel file of specific format to a Word doc file. Before I forge ahead, I want to take the obvious precaution and hear...

I'm having trouble with pop-up help on a userform. I set a HelpContextID for the form itself, so if someone clicks What's This, then clicks off a control, they will get an overview of what the...

Using Word 2010, I have a table in the primary header. I need to insert a blank paragraph before (above) the table. I'm using the following code: Dim rng As Range Set rng =...

Hello, The output of a tool is in the form of a table in word that contains 4 columns. One column contains a set of flags, another contains style names and the third and fourth contain a mixture of...

Hi -- I'm really hoping someone can help me. I have a letterhead macro that I created for our office back in Word 97, and its worked fine all this time except now that we are upgrading to Word 2010,...

I need to repeat a set of recorded macro commands until the end of an active document is reached, but I encounter "runtime error 52" The coding is: Do While Not EOF(1) Loop But I can't...

Excel 2010. If I select File > Options > Trust Center > Trust Center Settings... > Macro Settings, I (now) find that everything is greyed out. And the 'Trust access to the VBA project object model'...

I create a CSV file to use as a data file. We had no problem merging with this file in Word 2007. In Word 2010 we are seeing the following error: Word cannot start the converter sspdfcg_x64.cvn ...

I have a customer moving (not soon enough) from Word 2003 to 2010. They would like an add-in that is compatible with both versions of Word, and would greatly prefer not having to do a DLL install on...

We have an Access utility which processes timesheet data. One of its valuable features is that it will export a week's worth of data to a spreadsheet in Excel 2003 format, which the clerks enter...