473,703 Members | 2,503 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

VB2005 inferface with Pocket Excel

1 New Member
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 2243
debasisdas
8,127 Recognized Expert Expert
Question moved to .NET forum.
Nov 3 '07 #2

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

Similar topics

1
2353
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 of data in a database format. Is this possible? What do I need to add to the iPaq to do this?
1
965
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 to do this? Which one? 2. Is there certain code that will not port over to the Pocket PC?
0
795
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 to use this program on a pocket pc? What compiler? 2. Would I need to change my program to run on the pocket pc?
0
839
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 application. Please advise on this. Thank you
6
2292
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 manager. This problem did not exist in the VB2003 version. Are there a any ideas of what might be happening? All of the Excel objects are being disposed of by setting them to Nothing and the Quit method is called for Excel. I've even used...
1
1266
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 How do i open my data in excel ?- did not fint any refrences to office in the pocket pc available refrences 2 My pocket-pc application needs to get data from a secure web service x509Certificate . how do i import the certificate looks like the...
0
1124
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. Please help me on this problem. Thank You.
0
1275
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 I am removing the addin and I can't seem to get it to stop doing this. Has anyone else seen this problem. How can I load Excel from VB2005 with my addins working or how can i get the button to dissappear that says that I have removed the add...
0
1574
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 text element as normal copy from HTML file in web browser is pasted in the opened excel cell (manual operation). I'm enclosing the code I've written in the following : Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As...
0
8755
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8667
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9116
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9013
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8961
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7860
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5922
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
2
2445
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2063
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.