- Feb 18, 2001
- 30,990
- 5
- 81
Here is the Deal:
My Programming ability: I have been programming for all of a month. I will be the first to tell you that I suck at programming, but I learn fast. I am lazy, so I made a macro in a program called "Attachmate". This is a mainframe access program. All this macro did was sendkeys to 5 different Attachmate sessions and log into 5 different mainframes. It was nice, because the macro was written very close to VB, so using my super duper crappy skills, (RE: reading the help file) I was able to get it to "screencrape" certain things and store them as variables so that I could do stuff with them, then put them back into a different session. big deal right? Anyone who took a 6 month class could do that, and in way less time then it took me. The good thing was that the sessions did not have to have the focus to recieve the sendkeys. Each session was set as an object, then I was able to sendkeys to that object.
I also managed to get the variables to send to IE in a web form. The only thing is, I was unable to set IE as an object (because I suck at programming) so IE had to have the focus. I think I solved that problem yesterday tho with this code:
I also have a DOS window I need to screenscrape but I do not know how. At all. In the Attachmate sessions, I could just highlight column 2, from position 2,3 to 2,40 and that would set the data in a variable to whatever was in that position on the screen. Does DOS have the same row, column design? or is this impossible?
The porgram will actually be written in MS Access, not VB. But AFAIK 99% of the VB commands work in an Access Module.
My Programming ability: I have been programming for all of a month. I will be the first to tell you that I suck at programming, but I learn fast. I am lazy, so I made a macro in a program called "Attachmate". This is a mainframe access program. All this macro did was sendkeys to 5 different Attachmate sessions and log into 5 different mainframes. It was nice, because the macro was written very close to VB, so using my super duper crappy skills, (RE: reading the help file) I was able to get it to "screencrape" certain things and store them as variables so that I could do stuff with them, then put them back into a different session. big deal right? Anyone who took a 6 month class could do that, and in way less time then it took me. The good thing was that the sessions did not have to have the focus to recieve the sendkeys. Each session was set as an object, then I was able to sendkeys to that object.
I also managed to get the variables to send to IE in a web form. The only thing is, I was unable to set IE as an object (because I suck at programming) so IE had to have the focus. I think I solved that problem yesterday tho with this code:
My Problem:sub ()
Dim IE
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate "http://www.addresshere.com"
IE.Visible = True
While IE.Busy
DoEvents
Wend
IE.Document.All("name of box to send stuff to").Value = "what I want to Send"
IE.Document.All("name of box to send stuff to").Value = "what I want to Send"
End Sub
I also have a DOS window I need to screenscrape but I do not know how. At all. In the Attachmate sessions, I could just highlight column 2, from position 2,3 to 2,40 and that would set the data in a variable to whatever was in that position on the screen. Does DOS have the same row, column design? or is this impossible?
The porgram will actually be written in MS Access, not VB. But AFAIK 99% of the VB commands work in an Access Module.
