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 IamaSherpa 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. Inovate

    How to send appointment using CDO and Excel

    Let me further explain what I am trying to accomplish. In Excel we have all our reviews for our associates (over 2,000) I have VBA code that will go in to attachmate schedule the remote associate to come in to the facility on a certain date for his/her review and then what I want is the...
  2. Inovate

    How to send appointment using CDO and Excel

    I am trying to send an e-mail from Microsoft Excel VBA using CDO but I am unable to find any information on how to send a meeting request to another person that will appear on their calendar. It is important that I use the CDO code so I do not encounter the securtity warnings. Any suggestions...
  3. Inovate

    Attachmate Reflection

    It appears to be a Java window...
  4. Inovate

    Attachmate Reflection

    I am use to programing VBA for Attachmate Extra, but now I am tasked with programming VBA for Attachmate Reflection which is the same thing as Extra but is Web Based....everything looks similiar I am just not sure how to call the application....below is the code I use to call the Extra...
  5. Inovate

    Type Mismatch Access 97

    That makes complete sense. Since Tech_ID is an integer when it hits the "+" sign it thinks it should add. Sometimes it just helps to have another set of eyes look at it. Thank you for your help...
  6. Inovate

    Type Mismatch Access 97

    I am having a problem converting VBA from 2007 to 97. I keep getting a Type Mismatch error. I recieve the error when referencing Tech_ID. In the Table this is a long integer I have tried dim Tech_ID as Long with no help...Any assistance you can give would be helpful....here is my code. Sub...
  7. Inovate

    Microsoft Access and Attachmate

    Skie, I was able to figure it out, you actually had it in your script I just didn't understand the steps at first....This is great, thank you for your time.
  8. Inovate

    Microsoft Access and Attachmate

    Thank you Skie, I will try the script. How would I loop it? Say I have 100 associate numbers stored in the Access table and I want to send each associate # to attachmate to pull the associate name and hire date and fill the access table with the data, what would the loop look like. In excel...
  9. Inovate

    Microsoft Access and Attachmate

    I have wrote many VBA scripts to pull information from Attachmate to Microsoft Excel, but I have never wrote a script in Access. Here is the question: I have a Table the contains three fields (Date, Associate Number, Money Collected) the data is contained in Attachmate and I need to scrape...
  10. Inovate

    Multple <tab>

    Is there a way to tab in Sessions multiplyed by a counter for example if the counter is 3 then I want to <tab> 3 times but I do not want to write the code as myscreen.sendkeys"<tab><tab><tab>". Any suggestions?
  11. Inovate

    Handling Multiple Open Sessions

    I considered this senario however every computer that runs the macro seems to have the *.edp file stored somewhere else, like the desktop, mydocuments, quicklinks,etc. So although that would be the easiest way it will not work for everyone. Thank you for the suggestion.
  12. Inovate

    Handling Multiple Open Sessions

    I have done that and then I am assuming according to the code that Calculus suggested that the name of the userform would be changed to frmselectsessions and that the listbox would be named lstselectsessions.....That is where I am currently at.....and working from there....any additional pointer...
  13. Inovate

    Handling Multiple Open Sessions

    What I have is a large macro that currently works using activesession command but the problem is that when different users use this they end up having to close all but one session of attachmate because the macro seems to use different sessions that is unpredictable. So what I was attempting to...
  14. Inovate

    Handling Multiple Open Sessions

    I read this thread and did not have any luck the macro errors out at ExtraSession = frmSelectSession.lstSelectSession.ListIndex + 1 and I am unable to determine why? any suggestions?
  15. Inovate

    Handling Multiple Open Sessions

    I am attempting to find a way to write a macro in Excel that refers to Attatchmate sessions, the problem is that the only code that I can get to work is Set Sess=sys.ActiveSession However I want to creat a list box that the user can pick which open Attachmate session they want to use...

Part and Inventory Search

Back
Top