Search results for query: *

Strongm, Thanks for your reply. Yes, but I just thought I'd check one last time as I'm getting a lot of pressure to make sure it definitely cannot be done. The thing that doesn't make sense to me is that it accepts the other SendKey commands, but not enter...

Combo, Thanks, but neither work. I've tried them from the same page you posted! I think the problem might lie with the bespoke old software (at least 1980's era).

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

Skip, Thanks for showing me that stuff, I have already looked into that. I'm aware this isn't going to be the best, and it's a work around. It would just save an awful lot of time if I managed to pull it off. By the looks of things I'm going to have to just leave this as something which is...

Apologies DjangMan. The solution to my first issue was to run the macro without the code screen open. I was using F8 to run bit by bit through the code. The issue was, I was trying to say 'look at this app', but instead it was sending the key to the code screen it had to keep checking back in...

Hi all, Thanks for your help with this so far. It's working up to the point where I want to put in the 'enter' key (not return). I'm working on a laptop so the keyboard key doesn't exist, if that matters? I cannot use [highlight #FCE94F]application.sendkeys "~"[/highlight] or [highlight...

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

The thing is, it's a company PC and I'm unable to install new software. Just to clarify, when I say old system, I mean to say an application that is old. Apologies for the poor terminology! I'm running Windows 7, so using a macro should work.

Right so the beginning of the code identifies the notepad as a number, right? I assume this is important when needed to identify the same app when switching between applications? I'm trying to move to another application which is already open with someone's log on already entered. Another side...

Thanks for your response, I'll look into playing about with something like notepad first before moving onto the system I want to use it for. Thanks again!

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

Thanks for taking the time to look at this. The macro won't actually run to begin with. When I click the 'run macro' button, the macro box comes up blank and it wont show in the 'My Workbook' drop down, either. I've tried saving it in it's own module and the excel is saved as a macro enabled...

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

Thanks for your help guys, all sorted now.

Skip, Thanks for looking at this. There is an error with the final part: 'Destination:=.Range("A2:L" & MyValue), Type:=xlFillSeries'. Perhaps I should write it so that it just does it column by column? Regards!

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