Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel inside of a VB.net app

Status
Not open for further replies.
dcranford

dcranford

MIS
May 18, 2000
131
US
Is it possible to have a form; tabbed I guess, that has a control(s) so that exe's could be run inside of? I've searched for this but not knowing the exact keywords, controls, or commands I'm coming up blank. To keep it simple, if it's possible, I'd like to create an app that will open two programs in a tabbed form so if I click on Tab1, I'd see Excel and if I clicked on Tab2, I'd see Notepad. Obviously, this isn't VB 101 so I don't expect a free grand solution. But I'd really apprecite a path to go down to research.

Thanks
Deon
 
Sort by date Sort by votes
Since word can do it, I suppose so. At least excel is an ols-object so that should work. Don't ask me how I'v never done it.

Christiaan Baes
Belgium

My Blog
"In a system where you can define a factor as part of a third factor, you need another layer to check the main layer in case the second layer is not the base unit." - jrbarnett
 
Upvote 0 Downvote
I guess my thought is that maybe you can open and edit some things like Excel and Word by using a web browser control on each tab.

I'm not sure what you accomplish in all of this though as the Task Bar does sort of the same thing.


Senior Software Developer
 
Upvote 0 Downvote
Apparantly the best method is to use the webbrowser control and navigate to the excell document.

.Net doesn't have an oledb containre like vb6 used to have.

You could use an activex control but I haven't found one yet.



Christiaan Baes
Belgium

My Blog
"In a system where you can define a factor as part of a third factor, you need another layer to check the main layer in case the second layer is not the base unit." - jrbarnett
 
Upvote 0 Downvote
The apps are custom apps for healthcare; standard windows apps; not web based. I had seen some discussion on MDI (or maybe SDI) that made me think that an exe could be run inside of this; some Windows control maybe that can be assigned an exe that runs inside of a form. I was only using Excel as an example...didn't mean to mislead anyone.

And this may not be what I'm looking for. Maybe there's something else. The goal would be to have this vb app open when the user logs in and then inside of it there would be two or three apps ready for use. It just seemed cool to have a "tab" system dedicated to the medical apps that one person needs while another individual needs others.
 
Upvote 0 Downvote
How many people would be using this "tabbed" application if you created it? I guess what I'm getting at is that if it would make their life easier to have quick access to both apps then you might look at adding a monitor to each system (space and money allowing of course) to make them dual-monitor systems. That way the could open both apps full screen and see/work them both at the same time.

Senior Software Developer
 
Upvote 0 Downvote
This is small town USA I'm afraid. Medical workstations barely have enough room for a flat-screen much less two. I've got code written to interact with an SQL database for username/password security. The app I've written so far opens what they need just fine with the exception of the web app (see my earlier post from today about duplicate letters on a web form). These are non-computer folks...data entry mainly. At least in my mind it would be somewhat of a timesaver.
 
Upvote 0 Downvote
What about Microsoft Office Spreeadsheet control?

Tools > Choose toolbox items > Com Controls >....

==============================================

Seen a free set of apps called "floppy office"



________________________________________________________
Zameer Abdulla
Help to find Missing people
 
Upvote 0 Downvote
I appreciate all of the input. Realistically, there's probably no real world need for this type of control. And Sirious is right...that's what the Taskbar is for.

Thanks again.
 
Upvote 0 Downvote
It's very possible to have a windows form (with or without tabs) that can start Excel or other apps. To use excel inside of your app, I would drop a button on the form and with in the button's click event, start excel.

Have a look here:

Also do a google search for vb.net excel or something similiar. There are a lot of examples.
 
Upvote 0 Downvote
ok... we are not talking about excel here. It was only an example.

Second, what he wants is for his applications to load as if they were child forms contained within his custom application. In other words MDI or sometimes called TDI.

Senior Software Developer
 
Upvote 0 Downvote
Sirius is right...I was only using that as an example. I didn't know that there actually was a way to incorporate Excel into a VB form. I was looking for a process or procedure and I knew that the real name of the app wouldn't be familiar to anyone so I grabbed Excel out of thin air. Once again, Sorry for the mislead.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ken01
  • Question
Extraction of Picture box point / pixel colors. 3
Replies
13
Views
1K
klima
K
2009luca
  • Locked
  • Question
CHECK color of shape 2
Replies
5
Views
234
strongm
strongm
2009luca
  • Locked
  • Question
population of italy live/real time
Replies
11
Views
275
strongm
strongm
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
124
Swi
Swi
sal21
  • Locked
  • Question
Check of valute change in text file 3
Replies
15
Views
318
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top