1
Ok so here is a brief summary of my problem. I need a pop up form that submits input text box information to a pocket excel workbook upon a command botton click. Text box inputs are checked for validity upon individual text box exit (don't have a problem with this part).
All this could be done with Excel VBA easily, but pocket excel doesn't have VBA/Macro support. In as much, I have been trying to create a VB2005 application that I can load onto the portable device and interface with pocket excel (as the database).
I can use VB2005 to create a .csv file (with semicolon deliminators) that is readable/savable in Excel. However, I have no idea as to how I can search an an existing Excel file for the last row entry (as a starting point for the input of new information submitted by the VB2005 application). I don't need to be able to edit the existing information in the Excel file, just add new information (without overwriting content).
I have tried to add the excel file as a data source in VB2005 however only SQL server and MS Access databases appear to be supported. Anyone have any advice (I could really use it)? Thanks.
If a pocket excel - VB2005 interface is overly complex, would it be easier to just create an in-memory data table that can write to / read from an xml file that could later be reconverted to a Access table (with Access VBA) when the portable device is sync'ed with a PC?
