Search found 84 matches

by edauthier
Tue Apr 29, 2008 3:07 am
Forum: Technical / Scripting
Topic: MSSCript control error on MS 10.1.02
Replies: 31
Views: 31085

I have never seen this before and I have installed MS compiled EXE's on some real 'stinker' PC's. Typically if there's an issue it's the script... Look to AV or complete admistrative rights to the machine at installation time. Corrupt registry? Scott, curious about machine specs, antivirus and other...
by edauthier
Mon Apr 28, 2008 4:04 pm
Forum: Technical / Scripting
Topic: Excel Save Each Row As Text File
Replies: 7
Views: 8567

Thanks alot. Here's an example final for this portion of the script. Runs very nicely with alot less code than in the past. With this base you can then apply RegEx , etc. Let>connStr=Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=%SCRIPT_DIR%\band.xls; Let>connStr=Provider=Microsoft.Jet.OL...
by edauthier
Mon Apr 28, 2008 1:02 am
Forum: Technical / Scripting
Topic: Excel Save Each Row As Text File
Replies: 7
Views: 8567

Finishing up the script and I have one lingering issue. Variable - rsSheet1_1_1 It starts at Cell A2 and I need to start at A1. It's like I need rsSheet1_1_ 0 The window message in this script returns Cell A2. Need Cell A1. Let>connStr=Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=%SCRIPT...
by edauthier
Sun Apr 27, 2008 1:30 am
Forum: Technical / Scripting
Topic: version 9 are you kidding?
Replies: 12
Views: 11636

Hats off to Marcus and company in allowing this post to remain and not remove it. Typically a moderator will remove any dreadful comments about their product. That in and of itself displays major credibility in Macro Scheduler. I do not have a more reliable piece of software.

Period.
by edauthier
Sun Apr 27, 2008 1:13 am
Forum: Technical / Scripting
Topic: Excel Save Each Row As Text File
Replies: 7
Views: 8567

Thanks for the great responses. I have one other issue to deal with. I only need data from certain 'static' columns. Still attempting to create the lightest and most expedient script. The process: - Capture all spreadsheet rows - Only certain columns - Build a somewhat structured text file - Name of...
by edauthier
Sat Apr 26, 2008 3:27 am
Forum: Technical / Scripting
Topic: Excel Save Each Row As Text File
Replies: 7
Views: 8567

Maybe I should have been more clear. I am working with MS 10 - DB Connect command. I am struggling with the array dimensions for db connect. Marcus's blog instructs.. rsSheet1_1 is the table array, etc. The first datacell contents can be found in rsSheet1_1_1 and I can increase this incrementally ac...
by edauthier
Thu Apr 24, 2008 4:04 pm
Forum: Technical / Scripting
Topic: Excel Save Each Row As Text File
Replies: 7
Views: 8567

Excel Save Each Row As Text File

Anyone have a script that they could share that perfoms this?
by edauthier
Mon Sep 03, 2007 6:38 pm
Forum: Beginners
Topic: Next Clicker on google and ebay
Replies: 6
Views: 7207

Marcus's response is probably your best option. Especially if you're working with HTML pages often, Web Recorder is indespensible. The only other thing I can think of is on Google Search Results you could use the Windows Find Function to locate hyperlinks. Open Google Home Page and run the following...
by edauthier
Sun Sep 02, 2007 1:25 pm
Forum: Beginners
Topic: Check if
Replies: 13
Views: 11452

dvd, You've been provided with the If.. then.. did you happen to test the scripts above from Support and Bob Hansen? I think you've stated that it did not work. Pleaase post your version of the script. Also, Me_again's suggestion resolves your issue entirely (i think). Are you not sure how to preven...
by edauthier
Sat Sep 01, 2007 4:48 pm
Forum: Beginners
Topic: Check if
Replies: 13
Views: 11452

I am thinking that you can do everything you want to do with Macro Scheduler and will not require CC Cleaner. If you look in the discussions and in the 'tips' and 'scripts' area you can put together a script that will automate and remove anything you'd like. The real-time throws me off a bit though....
by edauthier
Fri Aug 31, 2007 3:33 am
Forum: General Discussion
Topic: Base64 sample
Replies: 4
Views: 7599

Wow.. Thanks for the example. I decided to compile it for testing and it works perfectly. T

his is a very nice enhancement with a lot of possibilities.
Thanks again for sharing. It's nice to start with a script you can examine.

Ed
by edauthier
Tue Aug 28, 2007 6:55 pm
Forum: General Discussion
Topic: 250 Million
Replies: 0
Views: 3555

250 Million

I really never play the lottery but... that's how much the Mega Millions lottery in the US is for tonight and for some reason Macro Scheduler popped in my head and I can't resist. I've never had a need for the Random> command before and it ocurred to me that it might be useful for picking the number...
by edauthier
Tue Aug 28, 2007 4:51 am
Forum: Beginners
Topic: Check if
Replies: 13
Views: 11452

Kinda vague on a few things here.. 1 and 2 What type of Internet connection do you have? Cable, DSL, etc. Do you have a local Firewall or network FW to be concerned with? Ok... so I might set up a a routine to ping 2 differing URLs and check their responses to identify Internet connectivity. You cou...
by edauthier
Tue Aug 28, 2007 4:39 am
Forum: Technical / Scripting
Topic: How to determine the last time an executable has been run?
Replies: 3
Views: 4722

I am not clear on how many PC’s/Users you need to monitor, but if it’s not too many I might do something like the following if you have MS Pro. -Create a simple .exe with Macro Scheduler* -Find and use the ‘typical’ Adobe Icon for your new MS.exe (Icon is here- C:\Program ...
by edauthier
Mon Aug 27, 2007 3:50 pm
Forum: Technical / Scripting
Topic: Calendar drop-down box
Replies: 25
Views: 32113

I am using the input> command to have the user enter a date field and then a time field, these are then used as arguments in running an application through Run Program
I guess he just needs to deal with TIME now
Sign up to our newsletter for free automation tips, tricks & discounts