Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Gatorsbucs
- Order by date
-
Move to the next cell in the loop if blank data is pulled from Screen
PERFECT!! Thanks!!- Gatorsbucs
- Post #4
- Forum: AttachMate solutions
-
Move to the next cell in the loop if blank data is pulled from Screen
Global g_HostSettleTime% Sub Main Dim Sessions As Object Dim System As Object Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions g_HostSettleTime = 0001 OldSystemTimeout& = System.TimeoutValue If (g_HostSettleTime > OldSystemTimeout) Then...- Gatorsbucs
- Post #2
- Forum: AttachMate solutions
-
Move to the next cell in the loop if blank data is pulled from Screen
Hello, Was wondering if someone might be able to help with some EB code? My macro currently grabs 10 lines of data (For Y = 10 to 19) from 5 screens (For P = 1 to 5), PF8 forwards to the next page if there is more data. This runs in a loop using data in column B (X) until it is...- Gatorsbucs
- Thread
- Replies: 4
- Forum: AttachMate solutions
-
Stop Macro when GetString is "Blank"
Thanks Skip!- Gatorsbucs
- Post #7
- Forum: AttachMate solutions
-
Stop Macro when GetString is "Blank"
Thanks Skip...I don't think I communicated this very well..When the macro runs the first " MN = .range("B" & X) " it may have 1 page,10 pages, or just a half page of data to gather. What I would like the code to do is not exit but move on to the next " MN = .range("B" & X) " once "Blank" data...- Gatorsbucs
- Post #5
- Forum: AttachMate solutions
-
Stop Macro when GetString is "Blank"
Global g_HostSettleTime% Sub Main Dim Sessions As Object Dim System As Object Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions g_HostSettleTime = 0100 OldSystemTimeout& = System.TimeoutValue If (g_HostSettleTime > OldSystemTimeout) Then...- Gatorsbucs
- Post #3
- Forum: AttachMate solutions
-
Stop Macro when GetString is "Blank"
I have a macro that runs on a loop, it is getting data from the mainframe and populating it in and Excel spreadsheet. The one problem I am having is getting the macro to move on to the “Next X” if and when it comes to “Blank Data” in the mainframe. I have the code set to go through 10 pages...- Gatorsbucs
- Thread
- Replies: 6
- Forum: AttachMate solutions
