Visual Basic

Re: how to VB6 to EXCEL? [urgent]

7-Dec-06 4:07

ChandraRam wrote:
Where's the question??

It's gone now. There has been a trend of people deleting their posts after someone has answered.

You will see a delete button on each of your posts. Press it. - Colin Angus Mackay

ChandraRam7-Dec-06 4:56

ChandraRam

7-Dec-06 4:56

PaulC1972 wrote:
It's gone now. There has been a trend of people deleting their posts after someone has answered.

You will see a delete button on each of your posts. Press it. - Colin Angus Mackay

Are you blaming this on Colin, then? Smile | :)

Re: how to VB6 to EXCEL? [urgent]

Paul Conrad7-Dec-06 5:11

7-Dec-06 5:11

ChandraRam wrote:
Are you blaming this on Colin, then?

No. The sig is supposed to be a joke with a subtle hint of sarcasm Laugh | :laugh:

You will see a delete button on each of your posts. Press it. - Colin Angus Mackay

beginners question

matt13086-Dec-06 14:56

matt1308

6-Dec-06 14:56

I'm sure this is a very simple question for all of you.

My son is taking a programming course and is learning visual basic 6.0. The program he has to write is:
the program selects a number between 1 and 10
the person enters a guess
the program tells them if it is right or not or if they are to high or to low.

How do you program the computer to have it pick a number between 1 and 10 randomly. My son is saying something about randomized timing....but I'm not sure if that is correct.
Appreciate any help anyone can provide....

Mathew's mom

Christian Graus6-Dec-06 15:49

6-Dec-06 15:49

If he's taking a course, they should provide the info he needs. He should try to do his homework, and then post his code here if he gets stuck.

A question like 'how do I get a random number' is also easily answered with google.

VB6 is also out of date, it's a shame that anyone teaches it. It has little to no real world value.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

MatrixCoder6-Dec-06 15:58

MatrixCoder

6-Dec-06 15:58

Christian Graus wrote:
VB6 is also out of date, it's a shame that anyone teaches it. It has little to no real world value.

Especially with the .NET Framework becoming so big. With .Net you can do so much more so much easier, but I some don't realize that.

MmM.net</

7-Dec-06 2:04

MmM.net</

7-Dec-06 2:04

Christian Graus wrote:
VB6 is also out of date, it's a shame that anyone teaches it. It has little to no real world value.

thats not correct , vb6 still Exist

Mohamad A. Flefel
mflefel@hotmail.com
+962 79 5963865
C#.net & VB.net Developer

Christian Graus7-Dec-06 7:59

7-Dec-06 7:59

COBOL still exists. So does LOGO, for that matter. MS have not supported VB6 for some time. There are legacy projects to be sure, but that doesn't make VB6 worth learning, the number of new VB6 hires will continue to drop, as more and more people wake up.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Kevin McFarlane7-Dec-06 3:52

Kevin McFarlane

7-Dec-06 3:52

Christian Graus wrote:
It has little to no real world value.

All the millions of lines of code out there have little to no real world value?

Kevin

Christian Graus7-Dec-06 8:01

7-Dec-06 8:01

ROTFL - pretty damn close !!!

Actually, I didn't say that. I meant that for someone entering the job market, VB6 has little value, compared to languages that are still alive.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Kevin McFarlane7-Dec-06 8:13

Kevin McFarlane

7-Dec-06 8:13

Christian Graus wrote:
for someone entering the job market, VB6 has little value, compared to languages that are still alive.

Agreed.

Kevin

Paul Conrad6-Dec-06 16:41

6-Dec-06 16:41

matt1308 wrote:
My son is saying something about randomized timing....but I'm not sure if that is correct

With very old versions of Basic there was a statement called Randomize Timer but IIRC VB 6.0 didn't have it. I only know about the Random class in VB.NET.

I'd like to help but I don't feel like Googling it for you.

matt13087-Dec-06 1:05

matt1308

7-Dec-06 1:05

Thanks for the help, you are all correct it's a shame they are teaching outdated products....
It's just tough trying to work thru homework that you know nothing about!

Smile | :)

ChandraRam7-Dec-06 2:26

ChandraRam

7-Dec-06 2:26

I think if you look up a function called Rnd() and its sample code, you will be able to solve the problem.

obarahmeh7-Dec-06 4:54

obarahmeh

7-Dec-06 4:54

i think that there is no one here have the answer to ur question, and so they are telling u that vb6 is outdata.... , but I think that she only needs to know the idea to solve the problem ...the idea is:

first: there is a function iin vb6 which is called rand(), which takes a number between 1 and 10.
second: let the program reads a number from the screen using any object some like open dialoge or maybe text field.

then comare the entered value with the value of rand() function

if not correct, then divide the interval (1 , 10) on 2 and see if the entered number from the screen is larger or smaller that 5

and go through until u get the right number

kind regards

Christian Graus7-Dec-06 8:09

7-Dec-06 8:09

obarahmeh wrote:
i think that there is no one here have the answer to ur question

Wrong. Many of us used VB6, and all of us have access to google. VB6 IS outdated. However, the other issue is simply that if someone takes a course, they will be given everything they need to complete an assignment. Not encouraging people to first use those resources robs them of the chance to learn.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Paul Conrad8-Dec-06 18:15

8-Dec-06 18:15

Christian Graus wrote:
Not encouraging people to first use those resources robs them of the chance to learn.

Excellent point Smile | :)

Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon

The ANZAC7-Dec-06 17:54

The ANZAC

7-Dec-06 17:54

Takes a good father to at least try, rather than throw your hands in the air and let your son fend for himself.

Posted by The ANZAC

error: Type not defined

judge_1036-Dec-06 13:59

judge_103

6-Dec-06 13:59

Hello,

I have a problem with the WebFile type:

Dim myFile As WebFile

and i get the error:
Type 'WebFile' is not defined.

Anyone could help please?

thanks.

MatrixCoder6-Dec-06 14:07

MatrixCoder

6-Dec-06 14:07

There's no such thing as WebFile. What are you trying to do?

judge_1036-Dec-06 14:13

judge_103

6-Dec-06 14:13

i'm not trying to do anything, i picked up an existing code that is supposed to save a webpage into text, archive, complete, etc. and its not working because of this error... i got the code from here
If you can please check it out cuz i really need it
Thanks

Christian Graus6-Dec-06 14:53

6-Dec-06 14:53

Then you should ask the question in the forum provided by the article. If you download the article code, does it run ? It probably contains the class you can't find.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

judge_1036-Dec-06 14:59

judge_103

6-Dec-06 14:59

i alerady downloaded the code, tried to build it and run it, but the only build error this one, and i searched the whole code trying to find this class but i couldnt.
With msdn, there is something called WebFile object in the Microsoft VBA reference (here) , but its not clear because its not mentionned to which class or reference it belongs.