472,354 Members | 2,178 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,354 software developers and data experts.

VB2005 inferface with Pocket Excel

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 2138
8,127 Expert 4TB
Question moved to .NET forum.
Nov 3 '07 #2

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

Similar topics

by: Les Allert | last post by:
I have an iPaq 3600 running MS Pocket PC version 3.0.11171 (Build 11178) operating system. I want to build and run a VB.Net program that can access Excel Pocket files for retrieval and storage...
by: Steven Omntec | last post by:
I have a communications test program written in Visual C++. I use the PC's serial port and save data in a Excel database. I want to run this program on a pocket PC. 1. Do I need another compiler...
by: Steven Omntec | last post by:
I have a communications test program written in Visual C++. It uses the PC's serial port and excel database to save data. I want to run this program on a pocker pc. 1. Do I need another compiler...
by: steven_lkk | last post by:
Dear All, Currently i work on a pocket pc project which required to generate the output to pocket excel file format. But unfortunate i cant find a method to create a new excel file from my .net...
by: Darrell Wesley | last post by:
A VB2003 application upgraded to VB2005 that builds an Excel spreadsheet. Everything appears to work correctly except that the Excel object does not go away it is still in the Process list in task...
by: milk-jam | last post by:
I have 2 problems regarding my c# pocket-pc application made with vs2005. both are used in my other applications but i dont find a way to use them on my pocket pc version of the application. 1...
by: Chamila Jeewanthi Indika | last post by:
Dose any one can help me on this I want to know vb coding to save serial data in pocket excel. I searched internet and books also. But I only find to save in excel not in pocket excel. ...
by: kylancal | last post by:
When I launch a new instance of Excel from Visual Basic, my add ins don't work. I need to remove them and add them back in through code. This is very annoying as a button pops up alerting me that...
by: arindams | last post by:
I'm getting problem in pasting HTML text in Excel 2007 whereas it is working fine in Excel 2003. The data pasted in excel 2007 is showing the the HTML code which is not desired. I need to have the...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it so the python app could use a http request to get...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the synthesis of my design into a bitstream, not the C++...
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.