visual basic express read/write to excel question

i have downloaded vbe 2010 and thats where im pretty much stuck . i do logic programing this type of code is killing me . is their an easier way . this is what i got , an excel spreadsheet runs my project .all i need is access to cell B1 to input a text string , and access to cell E1 so i can see what my value is , thats it , two little windows on a vbe screen . i just dont like the look of the spreadsheet when i convert to an exe. so i figured vbe screen would cover it up . am i wrong as hell or what
thanks

[ Moved ]

Export to TEXT, and then read the file. Problem solved!

this is a voice control program . i just need it to look neat . i talk into cell B1 , my spreadsheet runs a calc. then my value seen in cell E1 . ive looked all over the web and cant find code that doesnt include a button . i need full time access to cell B1 and a full time view of cell E1 because the software will run 24-7 .is their another option to convert my spreadsheet to a stand alone program without looking like a spreadsheet ?

Does it really need to be a spreadsheet, does it even need to use Excel?

eventually it will be all code , a stand alone program . i have perfected voice control that can apply to anything . i am meeting with prosthetic companies next week hopefully to apply it to a bionic hand . ill be making videos of some applications this weekend . do you have other suggestions for hiding the sheet for now .

Not really, I don't know enough about what you are doing and Excel would be so far down my list of options that it would not be considered. Typically I would use a database or a flat file depending on what I need and then write code to handle any calculations and display needed but then I have no idea what this spreadsheet looks like nor what data is in it or what kinds of calculations it may be doing.

If you don't want to see the sheet but need the data from it then I would consider exporting the data to a TAB delimited or CSV file and then use the data in the program and eliminate Excel from the equation.

I'm guessin david was breast fed by daddy. Is there a way I can get a private message to datamiser ?

I prefer to keep questions and answers in the forums so others may be helped. Also there are others here who may be able to add to the topic and help you in the process.

Ok can you do a visual basic app that has one text box that writes to cell B1 and a window that looks at cell E1 ?

I do not use Excel in my apps, I really hate working with it.
Like I said before unless there is some specific reason to use Excel then I would not use it. I would export the data to a different format and work with the data.

Here are some chunks of stuff I've used before:

Code:

---

        Dim oExcel, oBook, oSheet As Object
        oExcel = CreateObject("Excel.Application")
        oBook = oExcel.workbooks.add
        oSheet = oBook.worksheets(1) ' the sheets are 1 based - not zero
        oSheet.cells(1,1).value = "Hello World" ' the cells are 1 based - not zero
        msgbox(oSheet.cells(1,1).value)
        oBook.saveas("Tester")
        oBook.close()
        oExcel.quit()
        oSheet = Nothing
        oBook = Nothing
        oExcel = Nothing

---

probably want to try an "open" on the workbook or worksheet object then a loop to monitor the cell in question.

It's pretty simple with the Microsoft Office Interop namespaces... http://msdn.microsoft.com/en-US/libr...=vs.80%29.aspx

Why are you using Excel though? Just to see if you can input the data to a spreadsheet? :S The calculation part of it can be done with functions in Excel directly.

If you don't want to do it the COM way, then you could attempt uncompressing the archive (compressed with the DEFLATE/Base64 method like most zip archives) to reveal all of the XML files that are used for the spreadsheet, and edit those.

Write Excel:

Code:

---

sheet.Range("B1").Text = "XYZ"

---

Read Excel:

Code:

---

sheet.Range("E1").Value

---

I use a VB.NET Excel component.