I think the question that we are having is why are you trying to overwrite the data that you
are placing at row 5, column 18? You are putting a string there, with one row of data from
the Excel sheet, and the next time the loop goes thru, you are overwriting with the data in
the next row on...
thanks for the input. I wasnt aware of the Sess0.Screen.OIA.XStatus property. I write alot of macros based on both attachmate and pcomm and never looked into that property.
The only thing I can think of is trying to write a macro from the machine that is dragging to troubleshoot from there. Then create a check to see if one session is running or the other, then having the macro that works with the dog run with that session, and the macro that works run from the...
Just bear in mind that the variable, UserName = Environ("USERNAME"), is the Windows Network logon id. If the user id for the Mainframe App is different, then that variable wont work.
I use wait state alot. If you are going to move a cursor and put a string somewhere, you wont need it. But if you are running a mainframe application that if you send keys to fast it hangs, like Fidelity, then you are better off including them. When I use them I cut the time from the default...
Yeah. The reason why they are not running from the toolbar is often the toolbar editor will associate macros to the default path. What you have to do is open the toolbar in the toolbar editor, click the button you want to associate the macro to, click object, click macro, click browse and...
I think it is because of the Trim statement. it basically edits the text string before outputting into your text file... I would try this as a simple fix to make the first line of each screen a blank line in your text file..
So your code looks Like this :
Open outfile For Append As #1
Print...
One thing that will help you right off the bat is changing your output statement.
Currently, you have:
Open outfile For Output As #1
Change to:
Open outfile For Append As #1
Output means to replace all the stuff in the text file with new stuff. Append means add to the bottom of the text...
There is no macro command that will fire at a certain time. You're better off writing a small vb app and have it run in the background, and at a certain time fire off the macro.
I got a question. I have a macro that scrapes data from one screen, switches to another screen, and then exports to a text file. I use the GetString command to scrape the data from one screen, but when I switch screens, it seems to act like the macro is passing a reference instead of copying...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.