Search found 43 matches

by gtdalsanto
Tue Dec 11, 2007 10:04 pm
Forum: Technical / Scripting
Topic: Format CSV File then Save as an XLS with VBScript
Replies: 2
Views: 6001

Works perfectly. Thanks for your quick response again.
by gtdalsanto
Tue Dec 11, 2007 8:42 pm
Forum: Technical / Scripting
Topic: Format CSV File then Save as an XLS with VBScript
Replies: 2
Views: 6001

Format CSV File then Save as an XLS with VBScript

I am having trouble formatting a CSV file, then saving it as an Excel XLS file. Currently I am using the VB code I have found on this site: 'Opens the Excel file in Excel Sub OpenCSVFile(filename) Set xlApp = CreateObject("Excel.Application") xlApp.visible = True Set CSVBook = xlApp.Workbooks.open(f...
by gtdalsanto
Mon Dec 10, 2007 8:32 pm
Forum: Technical / Scripting
Topic: Change Format of Excel column using VBScript
Replies: 2
Views: 16152

I should have caught that. As always, thanks for the quick reply.

Gary
by gtdalsanto
Mon Dec 10, 2007 7:03 pm
Forum: Technical / Scripting
Topic: Change Format of Excel column using VBScript
Replies: 2
Views: 16152

Change Format of Excel column using VBScript

I am opening an Excel/CSV file using VBScript. What I am trying to do is to select a column in the spreadsheet, then change the format to a custom format. I am trying to format the column as a number with a fixed size of 10 digits. So the result would be for an input of 12345, the format change woul...
by gtdalsanto
Fri Dec 07, 2007 7:50 pm
Forum: Technical / Scripting
Topic: Copy CSV to another Open Excel worksheet
Replies: 5
Views: 6526

Thanks!!! That is exactly what I was looking for. Thanks again for your quick response.

Gary
by gtdalsanto
Fri Dec 07, 2007 4:32 am
Forum: Technical / Scripting
Topic: Copy CSV to another Open Excel worksheet
Replies: 5
Views: 6526

Copy CSV to another Open Excel worksheet

I am trying to find an easy way to copy a CSV excel file into a worksheet in a totally separate excel spreadsheet. What I have so far is a CSV file that I have generated from a data file. Once the CSV file is created, I open it up in excel, and perform a select all, then a control c, which copies th...
by gtdalsanto
Mon Sep 10, 2007 2:40 pm
Forum: Technical / Scripting
Topic: HTTPRequest with ActiveXObject support
Replies: 2
Views: 2891

Thank you for the quick reply. I had been trying to use the VB solution you say with no luck, and then tried a few things with my "string" quotes, and it started working. Below is the code that works, where all I ended up doing is putting quotes around the %TestXML% string in the VB call. I original...
by gtdalsanto
Mon Sep 10, 2007 1:31 pm
Forum: Technical / Scripting
Topic: HTTPRequest with ActiveXObject support
Replies: 2
Views: 2891

HTTPRequest with ActiveXObject support

I am in the process of trying to translate the following HTML code over to the Macro Scheduler HTTPRequest command. The code below basically takes an XML string that is entered in a html form text box (document.forms[0].requesterstr.value) and POSTS this command to a site that has a port/service nam...
by gtdalsanto
Thu May 10, 2007 8:51 pm
Forum: Technical / Scripting
Topic: Embedding Bitmaps in compiled macro's
Replies: 5
Views: 5302

thats what I was looking for. Thanks.
by gtdalsanto
Thu May 10, 2007 8:37 pm
Forum: Technical / Scripting
Topic: Embedding Bitmaps in compiled macro's
Replies: 5
Views: 5302

I have tried that already, and it embeds the bitmap as ascii characters in my script tied to an identifier called [bitmap file name]_DATA:. My question, is how do you tie this text/picture/graphic file to a button or a picture on a dialog box? Do I have to somehow write this ascii text back to the l...
by gtdalsanto
Thu May 10, 2007 7:50 pm
Forum: Technical / Scripting
Topic: Embedding Bitmaps in compiled macro's
Replies: 5
Views: 5302

Embedding Bitmaps in compiled macro's

I am trying to figure out how to embed bitmaps/graphics files into a compiled macro. If someone has some documentation on how to do this, I would appreciate that.

Thanks.
by gtdalsanto
Thu Nov 02, 2006 11:27 pm
Forum: Technical / Scripting
Topic: Press/Release command used with Variables
Replies: 11
Views: 7512

Press/Release command

Marcus,

Thanks for the quick response. I had the same thought of creating a script on the fly to build the command and then run it, but I figured I would ask if there is an easier way before I go to the trouble. Thanks for the code snippet, which will save me some time.
by gtdalsanto
Thu Nov 02, 2006 3:50 pm
Forum: Technical / Scripting
Topic: Press/Release command used with Variables
Replies: 11
Views: 7512

Press/Release command used with Variables

I am trying to create a subroutine that gets the function key that is desired to be pressed. Is there a way to do this by using a veriable with the Press instruction. I don't want to have to make a subroutine with 50 if>command=F1; if>command=F2;if>command=DOWN...etc. I am trying to get the followin...
Sign up to our newsletter for free automation tips, tricks & discounts