469,273 Members | 1,620 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,273 developers. It's quick & easy.

VB2005 inferface with Pocket Excel

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
1 2018
debasisdas
8,127 Expert 4TB
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.

Similar topics

1 post views Thread by Les Allert | last post: by
1 post views Thread by Steven Omntec | last post: by
reply views Thread by Steven Omntec | last post: by
reply views Thread by steven_lkk | last post: by
6 posts views Thread by Darrell Wesley | last post: by
1 post views Thread by milk-jam | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.