Search:

More than likely on a second parameter passed into the function.

Thank you Andrew. That works beautifully for the watermarks. Is there anyway I select whether it goes into a header or footer (or just at the insertion point). This is because we use the building...

I've been playing with Quick Parts and loving being able to create a Quick Parts building block that I assigned either to a footer or a watermark gallery.

I've been using the Building Blocks...

This has been helpful, thank you. (Now I need to change my settings so I get an email when I get a reply :rolleyes:)

Thank you sooooo much. You won't believe how frustrating an extra space can be :rolleyes:

I have a Word 2010 table, and a calculation {=sum(above)\#$#,##0.00}. The problem I have is if the answer is below $1,000.00 then there is a space after the $ sign, eg: $ 500.00. I really want the...

I have a multipage form, and somewhere there is a textbox labeled txtDate, however I can't find it. I can set its properties so that at runtime it shows up (txtDate.top = 0) but if I am just using...

Thank you so much. There was a string variable named Replace. Once I changed this to strReplace everything worked perfectly! Pity the error message didn't just say I had an ambiguous name or...

Hi All,

I have a simple piece of code in a module on my Normal template:


Sub SearchString()
Dim txt As String
Dim newtxt As String
txt = "Designation1/Designation2"
...

I am trying to edit a macro that was written prior to 2007. It edits the footer/s in a document. As I am having problems with the macro, I decided to take a step back and try and record editing the...

I have macro code that calls the InsertPicture dialog for the user to select which logo he/she wants in a document. The pictures all reside in client folders which I can identify using VBA. I want...

If the inline shape is selected, you should be able to do something like this:

Selection.InlineShapes(1).Height = Application.InchesToPoints(2.5)




Thanks Hans, I had to add...

When I insert a picture using the InsertPicture dialog the picture comes through as a selected inline shape - which is what I want. I want to set a specific height for the picture. The macro...

Hello Don,
I have attached a zip file which contains two Excel files which each have code copied from the MSDN website, and which I can't work out how to get to work. The examples on MSDN say we...

Hello Andrew,
I have attached a zip file which contains the Word document that I am trying to work with. This will eventually be a template loaded into the Startup folder. It contains a...

I started off really excited, I found a good book (RibbonX, customizing the Office 2007 Ribbon by Robert Martin, Ken Puls, and Teresa Hennig), through this found a little program called the Office...

Thanks Jeff. Your second reply to my post (which for some reason I can't see online) that VBA arrays are zero-based lead me to look again at arrays and in particular "base". I had an Option Base 1...

Thank you. I had just found that, and now have to try and work out why I had it there in the first place! It was possibly just a legacy as part of this form was used on another project.

Thank you Hans. This works perfectly with the sample form, but when I put into my actual form, which is a multipage form, I get a subscript out of range error. Firstly I thought it was because I...

I have a mental block when it comes to working with arrays, and I think this is where my problem lies with this exercise. I have a user form containing a listbox which has items added to it at...

Thanks for your prompt reply Hans. I've just had a frustrating day playing around with this, and your code works beautifully.

I have a form which reads data from a text file into a list box. I can then add or remove items from the list box, but I can't seem to write the information back to the file.
The procedure I am...

Earlier versions of Word showed the line number and measurement in centimetres from the top of the page, and the column number from the left margin, in the status line at the bottom of the screen. ...

Hello everyone. Has anyone seen the following problem:

We have a macro that extracts the address from a letter and then prints. Currently we are having issues where the printer prints a rather...

We do use global templates.

My query was what are the essential differences between docm and dotm files? I know one is a document and one a template, and I know that they have inherently the...