Search results for query: *

I have recorded a macro in Normal.dot but it doesn't run as desired. What is required is to process the whole of a document that exists in a separate file. The code fragment below repeats 100 times but ideally it should work through the whole document without using a For:Next loop. Somehow I...

The company I work for uses a 3 character string to identify users. I want to convert the 3 character string to a full name. e.g. user identifier = xqj user full name = Tommy Atkins. Assuming I populate one array with the identifiers and another with the full names is the only way to achieve...

I use a 123 workbook to track my current (checking) account and balances for some credit cards. Each worksheet applies to a single account. I can get updated statement information in .csv files using internet banking, To assist in keeping the workbook up to date, I'd like to write a set of...

I know about relative vs absolute addressing, but I want to test the values in two adjacent cells in a row in a macro that I've chosen to write using classic 123 macros. Is there a way of saying look in the cell to the right of the current cell? For example: {if...

Hi As an elctronics systems engineer I often need to produce complex documents with paragraph numbering etc. Every time I have to do this in Word (spit!) frustration rapidly builds up. Looking at Wordpro it looks as though much of what I want to do could be done using power fields but the...

Excel 97 and earlier have a bug in cut or copy and paste that the edit buffer is cleared as soon as new data is entered. Has this bug been fixed in more recent releases? In most Windows applications the data in the edit buffer remains there until overwritten by a new copy or cut operation.

I'm no expert at this, but think the nature of mail merge would be to create a complete document for every record in the merge database. Because it creates a complete document, printing part may be considered unusual which may be why it is not an option. I think you might be able to do what you...

The company I work for is willing to archive old Notes email to CD Rom, but the PCs provided generally do not have CD drives. I get the impression that archiving email to CD will be done readily, but a request for a CD drive could meet much more resistance. I have a copy of the version of Notes...

AFAIK the media descriptor byte is part of the boot sector on a floppy. Using a disk editor implies, at least to me, that you are going to manually edit any problematic disk. An alternative would be to write a short programme that reads the boot sector using low level BIOS commands, modifies the...

why not do a range sort on the times then the places are in order? I've been using UK football league tables as an excuse to learn a bit of 123 Lotusscript programming. The league tables are sorted (at least in my version) on points, goal difference, goals scored and on team name. The code below...