Search found 16 matches

by bsharp
Sat Mar 29, 2008 7:44 am
Forum: Technical / Scripting
Topic: A faster way to Separate
Replies: 20
Views: 20126

It's a bit unfair to compare speeds with a lower level, compiled language. Macro Scheduler is a high level automation tool with an interpreted script language. You'll not get the same performance as with C or even VB. You could use VBScript. Use FileSystemObject and Split. Because MS is such a powe...
by bsharp
Mon Mar 10, 2008 2:09 am
Forum: Technical / Scripting
Topic: A faster way to Separate
Replies: 20
Views: 20126

It may be because I am running an older version of MS? I am running 8.1 Pro. I just started porting the code to VB6 witch has no problem with it. loads it along with 6 other files in around 2 seconds using this in VB6 'Read the file into a string Open FileName For Binary As #1 FileString = Input(LOF...
by bsharp
Sun Mar 09, 2008 10:11 pm
Forum: Technical / Scripting
Topic: A faster way to Separate
Replies: 20
Views: 20126

I zipped up the test file and put it on my web server. If you could unzip it and post your results it would be great. I am running it on a 3.2 GHZ Core2 system with two 10K RPM hard drives?
by bsharp
Sun Mar 09, 2008 8:28 pm
Forum: Technical / Scripting
Topic: A faster way to Separate
Replies: 20
Views: 20126

Yea I figured that one out. But the Separate function still seems to slow. http://www.hellbentpcs.net/Separate.jpg Waiting almost two minutes just seams to long for such a small file. I have around 4 days into this project and do not really want to recode the entire thing in C over something so triv...
by bsharp
Sun Mar 09, 2008 3:30 pm
Forum: Technical / Scripting
Topic: A faster way to Separate
Replies: 20
Views: 20126

For some reason after around two minutes I get an "out of memory" err with that Bob. But thanks anyway.
by bsharp
Sun Mar 09, 2008 3:15 pm
Forum: Technical / Scripting
Topic: Help with my macro :/ Isn't working
Replies: 4
Views: 5285

I played around a little bit and got this working with note pad. and numberpad keys. Hope it helps Label>Start Let>Comma=, Dialog>Dialog1 Caption=Marcdks F-Tool Width=450 Height=240 Top=193 Left=172 Close=0 Rezise=0 Label=Choose your sentences and then start the bot,56,20,true Button=Start Bot,344,1...
by bsharp
Sun Mar 09, 2008 2:37 pm
Forum: Technical / Scripting
Topic: Help with my macro :/ Isn't working
Replies: 4
Views: 5285

I would think you need to add an onevent to the first loop "Start Bot". That way it will loop until key press?
by bsharp
Sun Mar 09, 2008 3:30 am
Forum: Technical / Scripting
Topic: A faster way to Separate
Replies: 20
Views: 20126

A faster way to Separate

Example. Let>filename=C:\post\kat6.apt ReadFile>%filename%,APTData Separate>APTData,CRLF,APT Repeat>k Let>APTData=APT_%k% Let>k=k+1 Until>k>APT_Count The "ReadFile" seems fast enough but the Separate function is a killer. The file is only 1.2MB and around 17,000 lines. I need to load every line into...
by bsharp
Sun Mar 02, 2008 10:51 pm
Forum: Technical / Scripting
Topic: Direction of arc by direction vector
Replies: 4
Views: 6268

GetAngle using vector mathematics For MS

I have resolved my problem. I found an example at VB-Helper.com and converted it to MS. It could save someone a lot of time. What it does is takes the cords of three points and converts it to an angle. Using Vector mathematics. Let>Ax=%point1x% Let>Ay=%point1y% Let>Bx=%point2x% Let>By=%point2y% Let>...
by bsharp
Sat Mar 01, 2008 11:51 pm
Forum: Technical / Scripting
Topic: Help with VB code
Replies: 0
Views: 3096

Help with VB code

I am trying to code this in Macro

Cos(theta) = A · B / (|A| * |B|)
Sin(theta) = |A × B| / (|A| * |B|)

But what does this do in VB? :?:
V = x2 - x1, y2 - y1
Will it add the two sums together?

http://vb-helper.com/howto_find_angles.html
by bsharp
Fri Feb 29, 2008 10:52 pm
Forum: Technical / Scripting
Topic: Direction of arc by direction vector
Replies: 4
Views: 6268

OK I figured out what the "INDRV" values are. They are an incremental distance projected tangentially from the start of the arc. Now what I need to do is some how calculate when the arc center is left or right of the "INDRV" vector. This would give me the direction of the arc. I am trying to use the...
by bsharp
Sun Feb 24, 2008 7:14 am
Forum: Technical / Scripting
Topic: Direction of arc by direction vector
Replies: 4
Views: 6268

Ok I am trying to translate an APT file from one format to another. The file I am trying to read from gives me the coordinates of arcs like this. A three arc circle going clockwise: GOTO / 0.80353, -0.60825, 0.75000, 0.000000, 0.000000, 1.000000 INDIRV/ -0.86603, 0.50000, 0.00000 TLON,GOFWD/ (CIRCLE...
by bsharp
Sat Feb 23, 2008 9:38 pm
Forum: Technical / Scripting
Topic: ArcTan
Replies: 1
Views: 3195

ArcTan

does ArcTan work in MS?
by bsharp
Sat Feb 23, 2008 6:32 pm
Forum: Technical / Scripting
Topic: Direction of arc by direction vector
Replies: 4
Views: 6268

Direction of arc by direction vector

I need to determine the clockwise or counterclockwise direction of a circle or “arcâ€
by bsharp
Wed Nov 30, 2005 12:35 am
Forum: Technical / Scripting
Topic: ADODB ACCESS MDB Problem
Replies: 2
Views: 4277

Thank You it works like a charm. I had thought I had tried that but I must have missed some thing. I knew there was a simple way.
Sign up to our newsletter for free automation tips, tricks & discounts