Search results for query: *

I need help along the lines of the OP. I'm having a hard time writing (not a programmer unfortunately or too familiar wth VB) a macro in Attachmate or VBA that's sole purpose is to run 3 other macro's. Example, I want to run "Multiple Macro File" in Attachmate that will run the following...

How do you know that. Nothing in the code you posted would give that indication!" I ran it on two separate accounts, one that matched the criteria and one that did not. It continued on as if nothing had happened on both. "Regarding your issue, usually you're testing for the presence of a...

What I am wanting to do is have the macro check a specific screen location in Attachmate for any value other than nothing. If there is a value, then continue running the macro, if there is nothing then stop running the macro. I've tried using the following, but it isn't working: Location =...

I'm working from that link Skip provided, Combining Two or More EXTRA! Macros into One. Ok, when I placed two "Include Statements" before "Sub Main()" ['$Include: "Pei.EBH" and '$Include: "Cei.EBH" on separate lines] and then placed "Pei" and "Cei" calls where I need them to run, it says that...

I found and read that earlier, but then I couldn't get the 2nd macro to run when I split it at the dialog box. Numerous errors pop-up that weren't there when I had less lines in the original macro. I'm also not certain if that will work as the 2nd half of the macro is just over 1000 lines and...

So, I thought I was done. With Skip's help, I was able to get past having the macro check an Excel value, then operate within Attachmate accordingly. My current problem "Procedure Too Large." I'll post the entire macro in this thread (a little over 1200 lines). My skills are very limited...

Excel 2010 can handle up to 64 nested IF statements in a single line. Can the same be said for Attachmate? As an example, can I have a macro look at a specific location and based off the corresponding text run a specific action. As an example, 22 letters of the alphabet, can the macro look at...

It works!!!!! I'm on cloud 9 right now. I've got more to do to it to make it fully functional, but this was a big step. Skip, thank you. I owe you Starbucks, just let me know how to get it to you! Stupid silly errors on my part that could have made this faster, but I'm new and will...

I can't check it until tomorrow. No longer at work.

What I had read said to do it as Range, but now that you bring it up, I want the info in that specific cell.

This is what I have down in the script: IF obj.WorkSheets("Data Input").Cells(23, "A").Value>0 Then obj.WorkSheets("Data Input").Range(23, "A").copy Sess0.Screen.MoveTo 4,76 Sess0.Screen.paste Sess0.Screen.Sendkeys("<Enter>") Do While...

I copied it from a prior reference that works earlier in the macro. I ran this on an account that does not have a sublocation and everything ran perfect. It did exactly what I wanted it to do, which was look to see and skip it if there isn't an indicator in the Excel Spreadsheet. I'm only...

Thank you. Last few catches were dumb misses on my part. Still have the same error pop-up.

So you know, when I run the macro with the fixes you've pointed out, I get the following error message (though the compiler says it's good): Object error Line number 143 Stopping Macro playback. Line 143 is: Obj.WorkSheets.Range("A23").copy

Thank you and be safe.

Yes. I believe the original author wrote that particular code just to get around the pop-up, that doesn't always occur. It looked to me that he got the string to compare to the word Flag, which is at that string if the pop-up occurs, but we don't take paste any info off that pop-up screen. We...

That Flag code just gets us past a pop-up if it occurs. We don't paste anything from that pop-up.

We are using Extra! X-treme 9.0 Service Pack 2. Our function keys send commands or we can go to our "Go" line and enter jump codes to get around. If I take out the sublocation issue, the macro works. However, we need to be able to copy info from the sublocation screens on those rare...

So, I work for a taxation agency. We have Seller's Permits and other various licenses. A business owner, like a CVS as an example, would have one single Seller's Permit, but multiple (sub) locations attached to that Seller's Permit. Not all business owners have multiple locations. The first...

This was the original that I started from: '-------------------------------------------------------------------------------- ' This macro was created by ' Date: Tuesday, 4-18-2011 ' User: DMOOS '-------------------------------------------------------------------------------- ' Global...