By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,882 Members | 2,482 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,882 IT Pros & Developers. It's quick & easy.

VB2005 inferface with Pocket Excel

P: 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?
Oct 31 '07 #1
Share this Question
Share on Google+
1 Reply


debasisdas
Expert 5K+
P: 8,127
Question moved to .NET forum.
Nov 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.