Search found 48 matches

by jwestan
Fri Sep 25, 2009 5:32 am
Forum: VBScript
Topic: Changing fields in CSV File
Replies: 1
Views: 1228

Changing fields in CSV File

I was wondering if there is a better way to solve this problem. I have a csv file that is created but created with incorrect values and need to change those values to zeros. I have created a script that does that but I am creating a seperate file to write the contents of the csv file. I am searching...
by jwestan
Thu Sep 24, 2009 3:46 am
Forum: VBScript
Topic: Changing ShellState from Classic to XP
Replies: 2
Views: 2167

Changing ShellState from Classic to XP

Thanks jvierra, that did the trick.
by jwestan
Thu Sep 24, 2009 3:29 am
Forum: VBScript
Topic: Changing ShellState from Classic to XP
Replies: 2
Views: 2167

Changing ShellState from Classic to XP

Thanks jvierra. So if I want to replace the 20th value of the array. I would do something like this? When I try to set the value I get a SWbemObjectEx: Invalid parameter message. Any ideas? Const HKEY_CURRENT_USER = &H80000001 Set oReg=GetObject("winmgmts:.rootdefault:StdRegProv") strK...
by jwestan
Wed Sep 23, 2009 7:01 am
Forum: VBScript
Topic: Changing ShellState from Classic to XP
Replies: 2
Views: 2167

Changing ShellState from Classic to XP

I am trying to change the ShellState from Windows Classic to XP and have found several topics on-line but dont know which is the best way to change that it. For example just changing the registry setting at position x or if there was a better way. Or have regedit import a registry file? Also if VBsc...
by jwestan
Mon Sep 14, 2009 6:15 am
Forum: VBScript
Topic: Creating a SQL Query in Excel Spreadsheet
Replies: 4
Views: 3463

Creating a SQL Query in Excel Spreadsheet

Thanks rasimmer, I made the changes and am still getting the same error at objActiveSheet.QueryTables.Add objRecordset,objExcel.Range("A1"). Stating
"Microsoft VBScript runtime error: Invalid procedure call or argument"
Anyother ideas?
by jwestan
Mon Sep 14, 2009 4:50 am
Forum: VBScript
Topic: Creating a SQL Query in Excel Spreadsheet
Replies: 4
Views: 3463

Creating a SQL Query in Excel Spreadsheet

I am trying to create an Excel spreadsheet with a SQL query already in it. I was able to create a Macro in Excel to see the VBA code but have not been successful at porting it over to VBScript. I am having trouble with the .QueryTables.Add. I am getting an Invalid call or arguement error. Have not f...
by jwestan
Tue Sep 08, 2009 6:27 am
Forum: Other Scripting Languages
Topic: Displaying Word.htm in InnerHTML
Replies: 6
Views: 5455

Displaying Word.htm in InnerHTML

So would it look something like this for vbscript in a HTA? I am still getting an Unspecified Error. Sub window_onLoad Dim ie : Set ie = CreateObject("InternetExplorer.Application") ie.Navigate("C:Test_3.htm") Dim ieInner : ieInner = ie.Document.body.InnerHTML DataArea.InnerHTML ...
by jwestan
Tue Sep 08, 2009 5:02 am
Forum: Other Scripting Languages
Topic: Displaying Word.htm in InnerHTML
Replies: 6
Views: 5455

Displaying Word.htm in InnerHTML

I am trying to get a Word document that was saved as a .htm file into a DataArea.InnHTML span and I keep getting an Unspecified error. I would like to keep this as a file as this is instructions for using the HTA and would like to only update a file and not have to modify the HTA but keep the format...
by jwestan
Tue Sep 08, 2009 5:02 am
Forum: Other Scripting Languages
Topic: Displaying Word.htm in InnerHTML
Replies: 6
Views: 5455

Displaying Word.htm in InnerHTML

I am trying to get a Word document that was saved as a .htm file into a DataArea.InnHTML span and I keep getting an Unspecified error. I would like to keep this as a file as this is instructions for using the HTA and would like to only update a file and not have to modify the HTA but keep the format...
by jwestan
Sun Aug 30, 2009 11:35 pm
Forum: VBScript
Topic: MS access Connection then write to Excel
Replies: 16
Views: 9270

MS access Connection then write to Excel

No, it ran the same whether it was in or out of the HTA.

I am happy with the time savings so far.