var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Excel File Read
I had an example of how to do this and somehow lost or misplaced it.
Need to run a routine on 98 invoice files to read into DB and do AR aging on them.
to capture the names and now need to read cell by cell into pre-existing invoice DB. Tables are tblInvoice and tblInvoiceDetail. I uploaded the documenter output on structure.
dir *.xls /b > inv_xls.txt
Invoices are modified from the default MS Office Invoice templates by Village Software.
I tried using the Transferspreadsheet command, but the macros in th SSs kept them from opening.
The example I had, previously, centered around the command ActiveWorkSheet, which is about as much as I can remember.