Search results for query: *

Hi all, I'm attempting to control a mainframe to automate a manual process using a sort of screen scraping method with the Application.SendKeys function. I've written code which does just that, but I've hit a wall. I've scoured the internet and found no solutions! The mainframe requires the...

Hi all, Below the line is some code I've written with the purpose to go between excel and an old program called TRUST. It works up till the point which I've highlighted in yellow. The idea is to basically eradicate the manual process of doing this through a macro which can just input the...

Morning all, I have been writing rudimentary macros for excel for about a year now but I've heard of a way to write macro's which will open other programms and perform keystrokes within a system to perform very manual processes. An example would be having to press the arrow key down, type "S"...

Hi all, Is anyone able to decipher the code below? I can get my head around INDIRECT, but the rest is jargon! [highlight #FCE94F]=IF(ISERROR(INDIRECT("'"&HG$17&"'!M"&MATCH($A5,INDIRECT("'"&HG$17&"'!D:D"),0))),0,INDIRECT("'"&HG$17&"'!M"&MATCH($A5,INDIRECT("'"&HG$17&"'!D:D"),0)))[/highlight]...

Hi all, I need to select a particular colour from some RGB numbers, and it must be done by VBA as a formula would be limited to only 56 colours. Can someone tell me why I cannot save the macro below to use again in the future...

Hi People, I am trying to auto fill (Drag down) a row of formula's on one tab to a specific row number which is located in Cell (O7) from sheet 'RR S&C'. This is what I have so far, but an error keeps coming up on the highlighted text in yellow. Can anyone show me where I'm going wrong please...

The code below stops when it gets to the second row of the first section. Can anyone tell me why? I've double checked all the tabs have the correct naming conventions... LastRow = Sheets("RR Master").Range("A" & Rows.Count).End(xlUp).Row Sheets("RR S&C").Range("A2").Select...

The code below is an extract of what I've created so far and works. The data being filtered is basically 1, or 0 mostly with a few other values. The only thing I need is for the column to be filtered on '0's for me to them copy and paste the data to another tab in the workbook. It needs to say =...