Search results for query: *

Hi Deter I'm not very experianced with macro's between excell an and attachmate however here is some code which I sharing data between attachmate screens and excell and works fine Sub Macro Name() '-------------------------------------------------------------------------------- ' Get the main...

Thanks for coming back to me so quick Skip, using a macro to manipulate Explorer is new to me I have modified the code using a similar post on this forum However the problem still persists and the create object just loads internet explorer, I dont expect you to sift rthough all the code or...

I have written a macro which loads up a invoice and allows the user to enter the desired ifnormation and make a record of payment the entire macro works fine hower I have added a section to it enter set text in the payment screen which is internet explorer based, the section of code that...

Thanks vzachin I thought it would be something to do witht he If command wasn't quite sure how to go about it but makes perfect sense so thanks.

Hi I have uploaded a screen shot to make it clearer I have had to remove the personal info due to dpa but as you can see the macro loads the invoice then it will show balance as 0.00 in top right and then it will show history i.e date invoice created along with amount then would show next of...

you are correct I am coding this in Excel the purpose is to load the invoice in attachmate and see if the payment has been made if it has the code is to continue and put all spread sheet info in atatchmate if not I need it to stop. Thank you for your suggestions on making the code simpler i...

Hi any macro's where I'm using 2 Attachmate screen I use the below code and work great gives both screens a name i.e first session is sess0. and 2nd is sess.1 and so if commanding screen one its sess0.screen. and if commanding screen 2 its sess1.screen. Hope this is of some use. Dim Sess0...

Hi I've developed a macro to check on attachmate a list of payments collected from excell, the macro works in the respect that it opens the invoice and shows if payment has or hasn't been collected and will copy all the required info to and from attachmate and excell. However I want it to bring...

vzachin you sir are a legend that was causing me a massive head ache cant believe it was staring me in the face the whole time thanks.

check your keyboard maps set up to ensure there is a function for <F1> and if there isn't you Can assign one. Sess0.Screen.Sendkeys("<Ctrl+M>") Which is an equivalent to <return>

Hi all I Have created a Macro which makes a record of a payment against a invoice it currently does every thing I want it to except insert todays date in a desired format. Today = DateValue(now) Sess1.screen.putstring Today The result of this is 04/08/2011, the problem here is that the...