Search found 15 matches

by terencepjf
Sat Jun 07, 2014 10:22 am
Forum: Technical / Scripting
Topic: Access Violation - Using Web Recorder
Replies: 1
Views: 2601

Access Violation - Using Web Recorder

I'm running MS14 (latest) in Windows 7 on Parallels Desktop and trying to use the webrecorder but I get an access violation every time I click on the cross-hair button in MS

Would appreciate some help in troubleshooting this issue (attached image)

Thanks
by terencepjf
Tue Nov 26, 2013 7:05 pm
Forum: Technical / Scripting
Topic: Removing the first character in a very large file
Replies: 5
Views: 7274

Thanks to all for the suggestions - I got powershell to work!
by terencepjf
Thu Nov 21, 2013 4:46 pm
Forum: Technical / Scripting
Topic: Removing the first character in a very large file
Replies: 5
Views: 7274

Thanks Rain; I've steered clear of Powershell as we are still on XP Pro, but it's time to dive right in based on this need..
by terencepjf
Thu Nov 21, 2013 12:58 pm
Forum: Technical / Scripting
Topic: Removing the first character in a very large file
Replies: 5
Views: 7274

Removing the first character in a very large file

Hi; I have a MS script that dumps contents from an Oracle database via sqlplus and for some reason it puts a funky character at the start of the file that make the contents unreadable. -I042,I042:I(A),AMPS,IA,4,07/21/2013 06:00 AM,88.812897 I042,I042:I(B),AMPS,IB,4,07/21/2013 06:00 AM,75.329751 (The...
by terencepjf
Mon Mar 28, 2011 2:42 pm
Forum: Beginners
Topic: XLRun does not do anything
Replies: 1
Views: 3790

Please cancel this post - I had the macro in the wrong file!!
by terencepjf
Mon Mar 28, 2011 2:33 pm
Forum: Beginners
Topic: XLRun does not do anything
Replies: 1
Views: 3790

XLRun does not do anything

Hi; I was trying out the XLRun features and I can't get an Excel sub or function to execute.. [code] //Open Excel File XLOpen>%SCRIPT_DIR%\finance.xls,1,xlBook //XLGetCell>xlBook,Sheet1,5,4,theValue //MessageModal>Cell value: %thevalue% Let>i=1 Label>Loop Random>80,vNum XLSetCell>xlBook,Sheet1,%i%,2...
by terencepjf
Thu Feb 10, 2011 4:02 pm
Forum: Technical / Scripting
Topic: BrowseStyle property gets parent folder NOT Sub-Folder
Replies: 2
Views: 3681

Marcus; my apologies I had the following line in my subroutine

ExtractFilePath>strFileName,strPath

Thanks
by terencepjf
Thu Feb 10, 2011 3:05 pm
Forum: Technical / Scripting
Topic: BrowseStyle property gets parent folder NOT Sub-Folder
Replies: 2
Views: 3681

BrowseStyle property gets parent folder NOT Sub-Folder

Hi; I need the user to select a folder or sub-folder via a dialog, but when I set BrowseStyle to fbFolder the return string in Filename contains the PARENT folder not the subfolder eg: C:\Folder\Sub-Folder Selecting the Sub-Folder via the dialog returns C:\Folder in the Filename property I'm using V...
by terencepjf
Sat Jan 10, 2009 6:22 pm
Forum: Technical / Scripting
Topic: Using dbquery (Optionally set fieldnames to 1)
Replies: 5
Views: 6259

Marcus; I get the data all right, but I want to get the field names as a top row for reference.

Can you provide an example please?

Thanks
by terencepjf
Sat Jan 10, 2009 6:01 pm
Forum: Technical / Scripting
Topic: Using dbquery (Optionally set fieldnames to 1)
Replies: 5
Views: 6259

Marcus; I'm trying to get the field names as in a header row as in... [code] SRT>PrintHeader Let>r=0 Repeat>r Let>r=r+1 Let>f=0 Repeat>f Let>f=f+1 Length>rsRecordset_%r%_%f%,vlen if>f=1 Let>WLN_NOCRLF=1 If>vlen=0 WriteLn>filename,NULL ELSE WriteLn>filename,result,rsRecordset_%r%_%f% ENDIF WriteLn>fi...
by terencepjf
Sat Jan 10, 2009 5:24 pm
Forum: Technical / Scripting
Topic: Using dbquery (Optionally set fieldnames to 1)
Replies: 5
Views: 6259

Using dbquery (Optionally set fieldnames to 1)

Hi; I tried using this switch (Ver 11) and not getting the desired results... DBQuery>dbh,SQL,rsRecordset,numrecs,numfields,1 ... WriteLn>filename,result,rsRecordset_%r%_%f% I get the following: 17;rsRecordset_1_2;rsRecordset_1_3;rsRecordset_1_4;rsRecordset_1_5... This is really strange as I get the...
by terencepjf
Sat Jan 10, 2009 5:16 pm
Forum: Scripts and Tips
Topic: Tip - Remote connection to MS SQL using Vista 64-bit OS
Replies: 1
Views: 14845

Tip - Remote connection to MS SQL using Vista 64-bit OS

I just moved to Vista 64 bit OS and had trouble connection to a remote MS-SQL database with a non standard port. Here's the fix for Vista 64 bit OS There are 2 ODBC data managers - the default is the 64-bit version found in the Control Panel. This one will NOT work Steps to setup: 1) Navigate to: C:...
by terencepjf
Sun Dec 14, 2008 4:01 pm
Forum: Technical / Scripting
Topic: Getting New Email Message counts
Replies: 3
Views: 9012

Getting New Email Message counts

Hi; does anyone know a way to get a count of New Email messages:

1) Without downloading all the messages
2) Count of messages in Inbox Sub-Folders

RetrievePOP3 works but the files need to be downloaded and no subfolders messages can be retrieved.

Thanks in advance
by terencepjf
Thu Dec 20, 2007 6:39 pm
Forum: Beginners
Topic: Help with complex Calc
Replies: 2
Views: 5023

Thanks

Not sure what happened; you're right it works...
by terencepjf
Thu Dec 20, 2007 12:06 pm
Forum: Beginners
Topic: Help with complex Calc
Replies: 2
Views: 5023

Help with complex Calc

Hi; I'm new to Macro Scheduler and having trouble with complex expressions. I need to get the coming Sunday's date: This works: where result is DOW=5 Let>var={7 - %result%} Let>var={%var% + 1} VBEVal>DateAdd("d", %var%, Date),nextsunday MessageModal>%nextsunday% However, the complex expr does not: L...
Sign up to our newsletter for free automation tips, tricks & discounts