Search results for query: *

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...

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...

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...

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.

I have just bought a wireless router/mdem and am trying to get a Windows XP/Home desktop system talking to a notebook running Windows 2000 Professional. I can't get either system to communicate properly with the other. 1. The XP Home system can access the mapped 'C' drive on the notebook but...

I have a range of data in which some items are all numeric and others are mixed character / numeric. I have converted it all to text fields within Excel. For example Cell 1 = 22640 Cell 2 = 06N0405 If I sort this data ascending, cell 1 comes before cell 2. However using if(cell 1...

After having rebuilt my XP Home system following a disc contoller failure which crunched both hard discs, I cannot now get it to communicate with two other systems which used to work fine before the crash happened. I have tried following all the Microsoft 'How to...' instructions without...

I'm trying to transfer some files from an old Win 98 system on to one running XP Home using Direct Cable Connection. The connection establishes OK but a password is demanded for access to IPC$ and also PRINTER. The 'Allow Directly Connected Devices without password' box has been ticked in the...

I used to use an excellent add-in VBA code formatter but unfortunately, due to a major system crash (disc controller failure crunched both RAID 1 discs!), I have lost it. I have back-ups of all my application data but neglected to back-up the add-ins I used (DOH!) I have searched all sorts of...

I have a workbook which has a lot of complex shapes with macros assigned to them. These macros work fine when the worksheet is unprotected but some cease to work when protection is applied. The 'pointing finger' still appears but no action is taken as a result of clicking the mouse button.In...

I have a worksheet which when I try to copy it, comes up with the message "A formula or sheet you want to move or copy contains the name wrn.WARRANTY._.REPORT which already exists on the destination worksheet" However, I cannot find this name anywhere in the worksheet. There is no...

Is it possible to identify the name of a Drawing Object which has a macro assigned to it from within that macro when the macro is invoked?

I have a worksheet which contains a lot of macros linked to buttons. This works fine until I protect the worksheet whereupon the wrong macros are executed. Removing protection excutes the correct macro once more. Unfortunately, the worksheet has to be protected. This is Office XP running under...

I have a worksheet which contains a lot of macros linked to buttons. This works fine until I protect the worksheet whereupon the wrong macros are executed. Removing protection excutes the correct macro once more. Unfortunately, the worksheet has to be protected. This is Office XP running under...

My Windows XP Home system did not come up properly from sleep mode and on re-booting neither Internet Explorer nor Outlook would connect with a comms line which Windows said was connected. The problem occurs with both an ISDN line and standard dial-up. McAfee Firewall Visual trace connects OK...

I need to start a Lotus Notes session which requires a password. I can successfully start a session and send the required Excel workbook but currently have to enter the PW manually. Presumably, this can be automated. Is it also possible to close the Notes session after sending the file?