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: *

  1. streetprog

    VBA / Attachmate: Getting the Color of Text from Screen

    I'm afraid you won't be able to drill down to that property with VBA or EXTRA's built in macro editor. I've wanted to check whether a field was read-only before and wasn't able to find any methods like this in the library. You can browse through the properties and methods that they've exposed...
  2. streetprog

    Using linked server in DTS package

    Can anyone give me some pointers on how to use a linked server in a DTS Package? The only thing I can see to do is to connect to the SQL Server directly but scheduling this is giving me some problems due to an error I'm getting: Error string: Login failed for user '(null)'. Reason: Not...
  3. streetprog

    Embed Extra in .NET form

    I'm posting the pertinent code from my form. You'll need to create the following but change whatever you don't like to fit your needs: - form (frmMain) with a MenuStrip at the top and a StatusStrip as the bottom. The default size is 800x600. - panel (pnlEXTRA) with the BackColor set equal to...
  4. streetprog

    Outlook not retaining recent contacts

    I've been having intermittent issues with Outlook dropping some contacts I haven't emailed in a couple of days. Yet it retains some contacts I haven't emailed in months. I'm talking specifically about the drop-down list of contacts you see when typing in the "To:" field of a new email. I've...
  5. streetprog

    Display Date In an Input Box

    You can also use the InputBox function as shown below Dim sDate as string sDate = InputBox("Enter the date you want:", "Any Caption", Format(Date, "mmddyyyy"))
  6. streetprog

    Embed Extra in .NET form

    Gotcha. I figured it would be something like that. I don't know that licenscing PCOMM is an option for me, but I've been playing around with a "no extra cost" solution that might do what I want, although not as slick as an emulator. I was able to create a .NET form with a transparent panel...
  7. streetprog

    Embed Extra in .NET form

    I started developing Extra! macros a few years ago and quickly moved into VBA to interact with Extra! sessions due to improved performance and functionality. I've now gotten into .NET and have begun development of better tools but don't love having to switch back and forth from the .NET app and...
  8. streetprog

    date verification

    Date is not a variable type in my version of EXTRA so you just declare the variable without a type. Option Explicit Sub Main() Dim exp 'variable to holds expiration date exp = #1/30/2008# If exp < Date Then 'check expiration date vs today's date msgbox "Expired"...
  9. streetprog

    Call Wait(Sess)

    With EXTRA you have to declare explicitly declare additional subs at the start of your code. I fixed a couple of other errors too. Option Explicit Declare Sub Wait(Sess As Object) Sub Main Dim Sessions As Object Dim System As Object Dim Sess0 As Object Set System =...
  10. streetprog

    Attachmate - Get today's date.

    You can use the Date() function: Sub DateAdd() Msgbox Date() Msgbox Format(Date() + 20, "MMMM DD, YYYY") End Sub Change the date format to suit your needs.
  11. streetprog

    Attachmate -&gt; IE -&gt; Attachmate

    I just wish I had known about Sess.Activate a while back. When I tried to view the EXTRA library in the macro editor it would always crash on my old PC. It's (inconveniently) not listed in the help topics. I've hunted around in the object library in VBA but never saw this until now. You...
  12. streetprog

    Sending Email via Outlook

    I discovered this a while back and the odd thing to me is that although it generates an error, it still displays the email. I just use On Error Resume Next and it works fine. I think there are two ways to do this. One is with carriage returns (Chr(13)) and the other is with <br> in HTML. I've...
  13. streetprog

    Attachmate -&gt; IE -&gt; Attachmate

    Try the AppActivate function instead of Sess1.Activate. Whatever your session displays in the Title Bar is what you put in quotes. Mine works like this: AppActivate "SESSION1 - EXTRA! for NetWare"
  14. streetprog

    Macro to run a macro later?

    This link will get you started: http://www.tek-tips.com/viewthread.cfm?qid=523094&page=14 I think you can also use Windows Task Scheduler if you have it. I think it runs in a similar fashion.
  15. streetprog

    Macro from batch file with COMMAND PARAMETERS

    Thanks for posting this! I was able to get the .bat file to launch the macro but when I added the Command part, it bombed. All it needed was to move the Command arguments inside the quotes like so: "C:\Program Files\Attachmate\EXTRA!\Ebrun.exe" "C:\Program...
  16. streetprog

    How to send &lt;END&gt; key to attachmate?

    If you are trying to move the cursor to the end of the current field, try: Sess0.Screen.Sendkeys("<EndOfField>") We have our End key set to execute <EraseEOF> which erases to the end of the current field the cursor is located in but use Ctrl + End for <EndOfField>. Does this help?
  17. streetprog

    HostSettle... more info for beginner pleease

    You can replace all of your "Sess0.Screen.WaitHostQuiet (g_HostSettleTime)" with "Do While Sess0.Screen.OIA.XStatus <> 0 : Loop" I had been putting a WaitHostQuiet in the middle of that loop but I learned from ChrisWhite123 that omitting it saves tons of time in how fast the macro can run.
  18. streetprog

    HostSettleTime

    ChrisWhite123, removing the Sess0.Screen.WaitHostQuiet (g_HostSettleTime) from the middle of my loop has already saved tons of time in my processes. You wouldn't think that 50 ms would slow things down that much, but the difference is astounding. Thanks!
  19. streetprog

    HostSettleTime

    This may be what CompuDork was referring to, but I use the OIA.XStatus property to check the state of the "status bar". If the mainframe is processing slow then this will allow you to wait until it is finished before performing the next task. I typically use a g_HostSettleTime = 50 so that it...
  20. streetprog

    Ctrl+V Paste not working

    It sounds to me like his keyboard map has been erased or overwritten with a blank default. We've had this happen to a number of people in my office. You can view the keyboard setup by opening the Keyboard Map Editor (either an icon or by selecting Options>Settings>Keyboard Maps and select the...

Part and Inventory Search

Back
Top