|
Okay,
I have a program that I am working on in VB.net.
I need to use Excel to pull in data from particular cells into a text box.
Any help would be appreciated.
Actually, I am in need of some one to actually help me do the database thing.
Its simple. (I just don't have the knowledge and I got thrust into this)
MSN has a stock qoute feed that you can set up with any symbol(-MSN-GE-IBM-MSFT) I am trying to use Excel as my database.
When I type in IBM into the search field I would like the data to populate into 5 seperate text boxes (Ask price-Ask Size-Bid Price-Bid Size-Volume)
Again, any help would be appreciated. I work for a small (5 people) finance company and I am the tech guy.. I am fine with building PC's and doing software installations but this is a little beyond me.
thanks!!
Kevin Sewell
Looking for a few good programmers
|
|
|
|
|
Send me some more details to richardgrimmer@hotmail.com, and would be glad to help - that sort of thing is pretty much my "bread and butter" at the moment!!
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
My application creates an Excel Spreadsheet and fills it with data and formulas. Excel is not visible while the program is running and is made visible at the end. there are no "ScreenUpdate = False (or True) statements in the code. It runs fine in windows XP Professional and Windows 98 2nd Ed. However, when it is run on windows 2000, the excel screen fails to update properly. there are "legacy" images from the VB.Net forms on the Excel screen. The screen resolution on the Win 200 machine is 1024 X 768. The resolution on the XP machine is 1280 X 1024, and 1024 X 768 on the Win98 machine.
I have no idea what the proble m might be, Does anyone have any ideas?
|
|
|
|
|
You might want to try updating the video drivers first...
RageInTheMachine9532
|
|
|
|
|
I tried updating the driver and found that the most current version is already installed.
What next?
Thanks!
|
|
|
|
|
Short of replacing the video card with something else and testing it, I don't know what to tell you. If definately sounds like a driver problem though. Even if the drivers are current, it doesn't mean they're perfect.
RageInTheMachine9532
|
|
|
|
|
Greetings
We are exporting Microsoft Outlook mail folders in to text files. We then are pulling them in to the application where they muct be displayed on the screen in a list. They are supposed to be tab delimited. I try to replace chr(13) with "
" in the filestream and it is not working. I have looked at the text files and they have a little box that separates each email address. Yet, I do not seem to be able to find the correct ASCII character that is this box.
I have tried char(9), char(10), chr(11), char(13), vbcrlf, environment.newline, you name it. I cannot get it to break.
Does this make any sense? Let me know if you have the answer.
Rob
Does
Rob Taylor
www.tconsult.com
|
|
|
|
|
That little box is a generic character symbol. It can be used many, many, MANY times in a font. You can't just look at that box symbol and identify the correct character code. It can change from font to font. You can find out what the character is by loading the string into a String variable and then look at the chars array of the String variable to ID the code of the character.
RageInTheMachine9532
|
|
|
|
|
A StatusBar on my main form has been quite happy sitting at the bottom of the form for several months now but today it just got up and moved so it is somewhere else on my form, somewhere I don't want it. I have a lot of docking windows on there and it has snuggled in with them. How do I get it to go back to the bottom of the form? I can't drag it there, I can't cut and repaste it.
Is there anything I can edit or do to get it back there?
Rugby League: The Greatest Game Of All.
|
|
|
|
|
Hey all,
i am trying to include a small webserver in one of my application,
so far i have found a very nice example, but it is in c#
i've been trying to convert it, but i always hit the same error(to many to sum up)
i'm talking about:
http://www.codeproject.com/Purgatory/webservergui.asp
if any one has converted it or know a vb.net variant.
can you post a link?
Thanx in advance
Jorge
|
|
|
|
|
Dear friends, i wanted to know that how can i write code behind toolbar panels.. when eevr i double click on toolbar it takes me to buttonclick event of toolbar.. but how can i code behind the buttons i placed upon toolbar?
|
|
|
|
|
When you click on a toolbar, the toolbar's ButtonClick event is fired and the button that was click is passed in ToolBarButtonClickEventArgs - its button property contains the index of the button (from the Buttons collection).
You could deal with it using a: Select Case yourToolBarName.Buttons.IndexOf (e.Button) for example.
|
|
|
|
|
thank you sir with this help.. but do i always need to use Select Case for dealing with Buttons of ToolBar.. can you please send me a lil code snipper for this..
thank you
|
|
|
|
|
No, you could use If...End If.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vastmSelectCase.asp
I've assumed an Open button, a Save button and a SaveAs button. For the Open button, I've pointed it at what might be the routine you've already written to handle a traditional menu item called mnuFileOpen.
Select Case toolbar.Buttons.IndexOf(e.button)
Case 0
mnuFileOpen_Click(Nothing, Nothing)
Case 1
SaveFile()
Case 2
SaveFileAs()
Case Else ' Other values.
'Since you should know how many buttons you've got, you shouldn't
'need a Case Else.
End Select
Don't forget that if you've used separators, they'll be on this list. E.g. If you have a separator after the Open button, you should code:
Case 1
Case 2
SaveFile()
etc.
|
|
|
|
|
i instantly need a code , in VB.NET, that ACTUALLY RUNS for uploading files to the hard drive.
theres an article by manoj rajan , on uploading files using VB.NET.
its a 4-5 lines of code and it just doesnt work.
so any instant help in this regard?
Plz reply SOON
|
|
|
|
|
You never mentioned where your uploading from, what protocol, what type of client or server, nothing... I can only assume this is a POST from an HTML page? Or maybe an FTP upload? ...? ...?
RageInTheMachine9532
|
|
|
|
|
no protocols involved.it is a post from an html page.
uploading files to my hard drive.
also tell me what is meant by uploading files to teh web server, where are they actually located when i do that
|
|
|
|
|
seemeenejaz wrote:
no protocols involved.it is a post from an html page.
Then the protocols involved are HTTP and TCP/IP.
The files you send to the web server, in an HTTP POST, are stored either whever the web application is stored or whever the application puts them.
You haven't given any details about what your trying to do, so it's hard to come up with meaningful answers...
Are you trying to upload website pages to a web server? What kind of server (UNIX, IIS, ...)? Is this an app to upload apges anywhere on the server?
RageInTheMachine9532
|
|
|
|
|
Dave i am trying to upload simple word, power point, PDF documents.
i am developing a virtual univeristy application.
the purpose is that the students should be able to view soft copies of books in their browsers.
suppose i have a book of Computer Communicaiton by Andrew S. tennenbaum,
A student searches for the said book by some query string, the results appear in a datagrid like hyperlinks. as soon as he clicks the hyperlink, the book opens up in his browser, now he may either choose to view it or save it his hard disk.
i should be able to upload books(soft copy) to some central server, like my pc.
similarly students wud also require to upload their submitted course work to some central server.now tell me how wud they achieve this?
that they upload their work and it is uploaded to the server, in that case that is my machine?
please correct me if i am not on the right track.
also tell me will it be more feasible if and the students uploaded their stuff to a database?
if yes then do tell me how to upload to SQL server ?
my application is in ASP.net (with VB.net)
Urgent reply needed
Thanks
|
|
|
|
|
The file would be uploaded to the web server. If that is the machine under your desk, so be it. You can check into an article here[^] on CodeProject that will demonstrate this. You could send the posted file up to a database but it will make it very difficult to open the file in Word or Excel without using a second client to download the file from the database. A better solution might be to manage your own filesystem on the server sorting the files by, maybe, class (CIS-101), then student name,... it's up to you how you want to manage the uploaded files...
RageInTheMachine9532
|
|
|
|
|
where is the web server located in a PC?do u mean that the files will be uploaded to nay location i specify?
|
|
|
|
|
If you're asking this question, you're in serious trouble with this project! 
The location of the files depends on the web server software that is running on the machine. If it's Microsoft's Internet Information Server (IIS), then the default root directory of the web server will be in C:\Inetpub\wwwroot. If this directory doesn't exist, your machine doesn't have IIS installed.
The files will get uploaded to the directory that the page is hosted in. Maybe, something like C:\Inetpub\wwwroot\myASPnetApp. Once the file is uploaded to the web server, you can either move it to a more appropriate location or upload it to a database.
RageInTheMachine9532
|
|
|
|
|
why in the world am i in trouble if i may ask?
i do have the IIS
|
|
|
|
|
Because these are the most basic of details on the subject of running a web server, managing the file system, and storing things in an appropriate place to make administration easier. These are details that have nothing to do with writing code. If you don't know them, you're going to have a very difficult time writing code to get the machine to do these things for you.
RageInTheMachine9532
|
|
|
|
|
i have no prior experience in DOT net.i am learning and implementing at the same time
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
