Recent content by mike1955

Getting errors when trying to create a ghost image of a drive that say: the operating system or another process has exclusive access to this drive. Anyone got a fix for this? Mike

The only way I can see of doing this is with a macro - here you would build the copy row in a loop constructing the copy cell reference as part of the loop counter

large table - select statement calls dataset from table where data is not sequential and the value in tne table field 'stage' is M10 I have seen quite a few variations: row_num, row_number etc and some as row_number() over etc but can't find one that works last five records are the last 5 of...

Hi all, I am having some grief getting a piece of SQL to work and wonder if anyone out there does anything similar. What I want to do is pull back records from a table and use just the last five of them in a calculation. I am calling these through an application in which SQL seems to work ok...

I never press the shift key on drop - it's displacing cells is not something I like to do. Regards mike

My instances update ranges from worksheets that are on a different server across a LAN. I just build the path and range into the cell using VBA, update the cell and then copy and paste as a vaqlue to overwrite the link. Maybe this is not remote enough to match your problem. Can add more to this...

It might be that you do not have the update links addin installed. see the help files answerwizard/search add-in and choose add-in programs for excel

do you get a message box on open asking to update? I have just created two workbooks, wb1 and wb2, entered a value in a cell in wb2 and referenced it in wb1. saved them both then alterd the value in wb2 and again closed it. opened wb1 and get the update links dialog - ok then updates.

try running macrorecord in excel as you do it manually. It records all inter-office transactions. It will give you a pointer as how to manage automation. If macrorecord is on before you open pp you will also get the new pp code.

No - but you could build them in an 8x8 table to view - you will find tha as you populate the table there is a pattern making it easier to populate.

It's a strange thing you are trying to do It would be easier to use vba to edit the links to the destination folder/files based on the current month. The links can be overwritten with a concatinated string sequence in vba that makes up the destination file path.You could also put a list box in...

drag and drop works when the cursor changes to an arrow as it is placed on the edge of the cell. If it a single cell just watch for the change and then press the left mouse to pick it up and move to the next place. If it is more than 1 they must all be part of the highlighting.

if(b1-364>a1+364,"answer1","answer2") remove the "" if your answers are numerical Dates typed in most of the formats ie dd/mm/yy, dd-mm-yyyy etc will be interpreted automatically as a number even if the cell is in text format. Need to be a bit more carefule if your pc is american format and...

using lookup with ranges or named ranges must have the index field sorted to work correctly. mike

you could do this in the workbook_open event in the sheet. Get it to look at a cell with =now()in it and build an algorithm to decide if it is the first of the month. Place a rowcounter in another cell and use this to target the addrow function position if the day is the first. a mathematical...