VB Forum / General / February 2006

I would like to create a list of numbers from 0 to 9 where each number only
appears once.
I can generate this list via brute force with logic checks...  but thought
there might be an easier way???

I have a project I'm working in VB6, where I'm reading from an Excel
spreadsheet.  I have certain cells I have to read while moving across a
numbers of columns, then at a point I have to move back to column 1, but down
a number of rows and start reading across again and so on.

I need to split a large file into parts
each part has to be 100 or less records
This is the code I have but it seems a little clunkey
I was wondering if there is a better way to do it

I have also posted this in the "Programming Jobs" section but I think
this is a much more suitable place. Please read:
Firstly, I'd just like to say that I'm very uneducated with
programming. Well, I have large experience with PHP and other

Is there a way to check for and or register an OCX component when a
vbapp.exe is executed?
Can this be accomplished in my module code?
I could do so using my installer if it can't be integral.

I'm looking for step by step guide to update my VB6 (and hence VS6).
I think this involves following in order:
1- download and install Platform SDK update.
2- download and install VS6 service packs, patches etc.(if any).

Ok, here is what I am trying to accomplish.
I have several users that update Excel sheets and email them to our
customers multiple times a day.
I also get these spreadsheets and import them into our SQL server as some

I often need to create dialogs in which a textbox (or other input control,
like datetimepicker) is paired with a label which describes the input
control.  For example:  Name:  <textboxcontrol>.  It seems devilishly
difficult to make sure that the top of the text in the label is ...

I have just installed VB6 sp6 on a new PC, it was working fine on the old
machine.
On this machine, I find I am unable to break a program running in the VB
environment by clicking Ctrl-Break so that I can debug.

I have a VB app that copies file from webserver to another server.
The app gets a list of files from the directory and stores name in a
database.
then reading the database for file names copies each file.

Am writing to a random file and retrieving from it. Have a UDT as
record. Execution only gives blank box. If I hard code it
Index = 1 to 10 I just get the last the last entry. Code is:
Private Type Bank

I have three text files (A B and C) with a few thousand names on them
(not sorted). The names on both lists are  formated identically. Some
names appear on both lists  I want to create a third and fourth list.
The fourthlist should have all the names on A that are not on B or C,

  Soon, in the next two years, we will be moving from our trusty AS400
green screens to a Windows application.. :(  Over the years I have written
many vb apps to extend the functionality of our AS400 though the IBM Client
Access program. The new windows app will be an improvement, ...

I have a .NET script that I need to translate into VB.  Does anyone know how
to do this?  If so, thanks in advance!
Here is the code.  I only need the part between START TRANSLATION HERE and
END TRANSLATION HERE translated.

Recently, my VB6 (SP5) has become VERY unstable -- it displays the "Send
Report for Microsoft" dialog box every time I quit the IDE. When stepping
through a program in the IDE, VB will crash after a few minutes with the same
dialog box.