Updates

Replace specific line of text file using Excel VBA

Replace specific line of text file using Excel VBA It includes both the first line replacement, and the last 6 characters replacement. Sub GenerateACEQueries() 'Script sourced from 'http://www.excelbanter.com/showthread.php?t=427791 'http://www.ozgrid.com/forum/showthread.php?t=181679 Dim strFileNum As String Dim rCell As Range ‘Declarations for parsing first line in text file (opening date) Dim vSz As Variant, vFilename As Variant...

Combine .CSV files data into single workbook

Loop through .CSV files in a folder open copy and paste row into another workbook Join the information from multiple files to single file (It can be csv or xlsx) Sub ImportExcelfiles() Dim strPath As String Dim strFile As String Dim wbSource As Workbook Dim wsSource As Worksheet Dim wsTarget As Worksheet Dim rowCountSource...

MySQL Connector/J 5.1.6 Problem in JDBC

MySQL Connector/J 5.1.6 Problem in JDBC One interesting problem which can happen to the MySQL Connector/J 5.1.6 users is, when you try to close a “java.sql.PreparedStatement” object, you will get “IllegalArgmentException”. There is a simple work around for this. Just you have to use a patch JAR file in your class path. Read More

XE: USD / INR Currency Chart. US Dollar to Indian Rupee Rates

USD to INR Chart5 Oct 2017 07:00 UTC – 14 Oct 2017 14:11 UTC USD/INR close:64.71273 low:64.67177 high:65.57255                                                        ▼ ↔ ▼ Convert Source: XE: USD / INR Currency Chart. US Dollar to Indian Rupee Rates

Published On

November 2018
M T W T F S S
« Oct    
 1234
567891011
12131415161718
19202122232425
2627282930  

This is a demo store for testing purposes — no orders shall be fulfilled. Dismiss