Search found 48 matches
- 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...
- 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.
- 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...
- 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...
- 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?
"Microsoft VBScript runtime error: Invalid procedure call or argument"
Anyother ideas?
- 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...
- 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 ...
- 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...
- 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...
- 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.
I am happy with the time savings so far.