Search results for query: *

Thanks! I could have had a V8! I didin't think about the Excel VBA tool! You're right on the structure building too. I will start doing that. If you bring that sentence in for a fitting, I can have it shortened by Wednesday!

Here's a routine I reuse all the time for Excel connections that's been cobbled together over the last few years from experience and forums...maybe it will be useful to you. 'In your declarations add this: Declare Sub OpenExcel Declare Sub CloseExcel Global S0 As Object, Sys As Object, Sess As...

I know this probably absurd, but I've been playing with this for two days now and I think I've just burned out on it and I'm not seeing the obvious somewhere. I'm getting the default Attachmate Editor error message on compile "For and Next statements must be in same block" and I have access to...

Assuming you are doing this using VBA from like Excel (yes, assuming...we all know that's bad!)...try utilizing something along the lines of: Splitting up a filename The two examples in this section make it easy to extract a path or a filename from a full filespec, such as...

[spineyes]Skip, you seem to fixated on the Case Select when it actually had nothing to do with this question and was only an alternative example of the same issue appearing in other example code (may I recommend decaffeinated?[shocked]), but to address the Case Select, yes the literal values are...

I have tried the Trim trick previously, but it didn't return a satisfactory result. In my routine I'm attempting to move the cursor to the line being evaluated in the For statement: Dim z as Integer For z = 8 to 21 LnChk = sess.screen.GetString(z, 04, 21) If LnChk = " " Then Exit Do 'we reached...

I'm having trouble with the MoveTo where the cursor is not moving to the selection as anticipated. The entire macro is very long so I've included only the specific sub where the issue is occuring. All other aspects of the code are working as anticipated and desired with the exception of the...