I agree with Skip, if you are using Excel or Access at all with your Extra Script, write everything in VBA within Excel or Access.
You open extra, send a few keystrokes, scrape data from the screens (sometimes lots of data from several screens), then loop over a Field Definitions...
Declare Public Sub Main()
Declare Private Sub Badloop()
Declare Private Sub Goodloop()
Public Sub Main()
Call GoodLoop
Call BadLoop
End Sub
Private Sub Badloop()
dim lng as Long
dim result as long
lng = 20
result = 1
do
if lng < 2 then exit do...
Hi all,
This is my way of saying thankyou to this community (special mention to several useful answers by SkipVought)
If you make any improvements or see any faults, feel free to let me know (though free code audit is not my purpose here).
Kind regards,
Tas
What is this?
This code comprises...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.