Recent content by ajcarr

I really don't understand what caused this problem. The shapes that are being pasted are just simple rectangular shapes. The positioning seems to be a bit intermittent which may be something to do with hidden rows above the row where the object is being pasted. The code worked fine under Excel...

Skip, could well be that something has changed in 2007 - I've found quite a number of subtle changes. Even when I selected the Shape by name rather than count, I still had the problem of Excel putting the shape in the wrong place. Your code looks as though it should work OK so there might be a...

Skip, many thanks for your help. This is sending me up the wall! Your code picked up the wrong shape because there are quite a number of shapes on some pages. It looks like an Excel 2007 problem since the positioning varies according to whether the ribbon is displayed. It works OK under Excel...

The 143 was passed into the procedure as a parameter. I just substituted this so that I could get the exact numbers. The shape that I am trying to paste is a logo. The program is used by a number of different operations and each has their own logo. It is taken from a file which contains the logo...

Skip, the code looks like this Cells(143, 3).Select ActiveSheet.Paste With Selection .ShapeRange.LockAspectRatio = msoTrue .ShapeRange.Height = Rows(143).RowHeight * 0.8 .ShapeRange.Top = Cells(143, 3).Top + 1...

I have some code which positions a shape to align with a cell using the .top property. It does this 4 times on one worksheet. The first paste works correctly but the next three position the cells too far down. The code is the same, the row number is passed into a procedure as a parameter. The...

Have found the cause of the problem. The column heading in Excel that I was using for the addresses was "e-mail". Mailmerge seems not to like the "-" and when I changed the heading to "email", the mailmerge macro worked fine.

I am trying to use Mailmerge to send to a list of e-mail addresses held in an Excel workbook. I can't find how to link to link to the address table in the Word VBA Macro. I've tried using macro recorder but it doesn't record this part of the process. I presume it has to link to the...

Thanks Skip. I spent hours searching through the help screens trying to find this. So simple when you know how. Allan

Cells("A1").select or Cells(1,1).Select

Excel 2007 is a nightmare - Microsoft have made so many annoying little changes. I have several applications which use full screen mode (especially for non-technical users) and I used to use the status bar to keep the user informed during long processes. In Excel 2007, the Status bar is no...

I have an application which needs to insert pictures at particular positions in an Excel workbook.(These are organisation logo's). However, I can't find out how to control the exact positioning within a spreadsheet. Selecting a cell and pasting puts it roughly in the right area and I know I can...

Many thanks, that's it. Just not easy to find from the Help screens.

Is there an equivalent in Word for the 'GetOpenFilename' method in Excel? I want the user to be able to browse for a filename and then use that name in a Word Macro to drive Mailmerge.

Yes, both using NTFS.