Search results

Thanks for the reply, boblarson. I don't know if I understand what you mean. I'm thinking somehow splitting the source into two files. 1st file with column 1 to column 256, 2nd file with column 257 to 360. Is there anyway you can specify the starting column in the source file to read from...

I revised my code: ================ Sub CalcPV() Dim cn, rs As Object Dim inputPath, inputCF, inputRate, outputPath, outputFile As String inputPath = Sheets("Sheet1").Cells(3, 4) inputCF = Sheets("Sheet1").Cells(4, 4) inputRate = Sheets("Sheet1").Cells(5, 4) outputPath =...

Here is my code so far: Sub CalcPV() Dim cn, rs As Object Dim strcon As String Dim strsql As String Dim inputPath, inputCF, inputRate, outputPath, outputFile As String inputPath = Sheets("Sheet1").Cells(3, 4) inputCF = Sheets("Sheet1").Cells(4, 4) inputRate = Sheets("Sheet1").Cells(5, 4)...

I know I'd have to use a loop, but I'm stuck on the syntax since I need to open a csv file that has max columns of 360. But my output will actually be just one column, since it's the present value at time 0.

I'm using Excel 2003 now.

Hello, I'm trying to do the following task: Input files --> csv file 1 with 360 columns of cashflow --> csv file 2 with corresponding rates for the 360 columns Task --> calculate present value based on the cashflow and rate file (i.e. file 1 column 1 * file 2 column 2 + file 1 column 2 *...

Thanks for the quick reply. It works!!

I'm trying to add a column called "RecordID" to my table based on the unique field "AccountNum". The "RecordID" would be a sequential number starting from 1. Hopefully this can be done in a query. i.e. original table: AccountNum 242 256 298 308 output table: RecordID AccountNum 1...