Search results for query: *

The code I have will add a prefix string to the left each csv file record. The code so far will append a fixed string to each record of the file. Const ForReading = 1 Dim oFS : Set oFS = CreateObject( "Scripting.FileSystemObject" ) Dim sDir : sDir = "z:\test" 'Target...

I have a csv file, "List.csv", comprised of a single item per record. I would like a VBScript that will read each record and append it to a standard string. All strings will be saved to a single new file "Output.csv". For example: List.csv contains: aaa bbb ccc Output.csv XXXXXaaaYYYYYYaaa...

thanks for both

I am trying to run following found code to compact access databases with several problems: 1: I would like the access database to open on the screen to allow me to see something is going on 2: The code as found has different lines depending on Access database type (97, 2000, etc). The code...

Macro code as follows (line that crashed macro is noted): Sub macro1() ' Ticker Import Function Range("A2").Select With ActiveSheet.QueryTables.Add(Connection:= _ "TEXT;Z:\My Virtual Machines data\VM find stock signals\office\EOD data\complete list current fundamental.txt"...

I am trying to find a macro to open Excel and run a macro. I have tried the following script and while Excel does open and the macro starts it does not complete. Of course the macro has been tested and runs when executed "normally". {code] Set xlObj = CreateObject("Excel.application")...

I the VM read/write data from/to the host computer, e.g., no data is resident on the guest computer. Thanks k

I am currently running VMware workstation 6 communication to the network through bridge via Gigabit router. I am exchanging MASSIVE volumes of data from the VM to a SATA hard disk. Occasionally communications fail (as evidenced by a message "could not find XYZ"). Is there a better, i.e...