VB Forum / General / October 2004

I have installed Excel10 on my computer. When I am writing a vb program that
works with excel, it connects to Excel 10 (Project/References). When I
deploy this VB program for a computer with Excel 9 my vb program crashes. I
assume it crashes because it does not find Excel10 on this ...

Using VB6.  Trying to access the Windows Task Manager to check for a running
application in the Applications tab.
Can VB6 do this?  I haven't been able to find anything.  Thanks.

i have 2 computers an di want to create a chat
application that will work with Winsock control.
i set the Winsock.RemoteHost="10.241.12..."
and the other computer IP, BUT - What shell iwrite in the

I have been experimenting with the Data Environment feature to control
tables in a Access database. I can display a table, add, delete and update
information. What I want to be able to do now is to;
a) delete all rows from a table using a command button (somehow send a

How do I load a combo box with an SQL SELECT statement.  I am trying to load
a combo box with employee numbers ( about 2000 employees ).  Currently I am
selecting all employee # into a recordset and then looping through the entire
recordset adding to the combo box with .additem.  ...

I am writing an application to do some complicated calculations on a
database. As a debug aid, I need a subroutine that will generate a
formatted report of dynamically selected fields in the database where
some non-trivial formatting is required. There are too many fields in

I am developing an applocation which reads mails in outlook inbo
alongwith attachments and all these informmation is stored in
collection which i need to pass it to a web service, which will perfor
certain operations on that collection and then return that modifie

When using an ActiveX Document can you take advantage of cookies? Also, can
you pass variables in the URL to the document like you could with a standard
ASP page? If yes to any of these can you please point me to some examples?
I was not sure of this should go into the webdev ...

I need to parse and create an excel list of each root items from a XML files
using VB. I will use the excel list generated for creating Access DB.
Sample XML:
<?xml........>

hi ......
would like to know to make sure if a certain dial up connection is
connected......thx

How can I convert a string into a function in VB?

List:
I'm using VB6::DAO::Jet Engine 3.51 to update a datebase.  With db set
to a valid dao.database, I attempt:
db.execute sqlString, dbFailOnError

I'm trying to create a debug form in a program I've written.  The purpose of
the form is to check various variable/object settings when a program is
running. (After it is compiled)  The from pops up as soon as the program
encounters an error.  I have two text boxes on the from.  ...

I've spent the last hour or so searching the MS site for this and can't find
a definitive answer. Has MS published a date for ending support of VB6? If so
can anyone provide a link to a document I can show my management?
TIA

how to read through the rows all worsheets (one worksheet at a time) of an
XLS spreadsheet from top to bottom without having to close and reopen the
spreadsheet?
like set next worksheet at top of page....?