VB Forum / General / September 2006

I'm will begin to protype an app using data that is presently stored in a
large Excel spreadsheet and I'm looking for any recommendations on using a
data control, before I start.  The database contains several thousand
records, each with about 20 fields.  Right now only one table ...

I'm trying to record a simple VB macro in MS Word. It should copy a word in
Word and paste it into an online dictionary (Internet Explorer). Manually, I
can switch between the two open windows (Word and IE) by pressing Alt + Tab.
But that does not get recorded by the macro.

I have a web form that has user input that I need to pass to my business
layer. The user input is dynamic and is not know at design time. Any
suggestions how to handle this?
Thanks

How can I change listitem backcolor? Thanks.

I have some code where I open up Excel then loop through several cases to
update several workbooks.
Basically something like this (not showing all the code just basic structure).
Try

I'm trying to clean up a vb6 app (don't ask why I can't move it to
vb.net).
I would like to take out all the config information and put it in a
config file. But I can't find an app.config in vb6.

I'd like to know how can obtain command line parameters passed to my
program.
For example, running "Project.exe a b c", how can I get a,b and c in my
program?

While I will be the target of some reactionary flamming, I would like to
make the following comments:
1.    I have enjoyed immensely being part of this group.
2.    VB has served me well and has provided a good living for me for many

I need some help setting up a DataCombo.  I searched help and printed a
couple of documents about setting it up, and I googled "DataCombo" and found
this http://www.devx.com/vb2themax/Tip/18430 which seems like the right
thing to do, but when I run my code, I get a compile error ...

hi, this is what i wrote :
Private sub text1_change(index as integer)
Dim A as boolean, b as boolean
for index = 0 to 2

When i use this:
       Dim strDate As DateTime
       strDate = Calendar1.SelectedDate
strDate contains "#9/25/2006#.  How can i make strDate have a long date in

I am getting this error:
Compile error:
Only public user defined types defined in public object modules can be used as parameters
or return types for public procedures of class modules or as fields of public user defined types.

Hi all ! I have the following situation and I have to find a fast way to sort
my array of string.  I can put the 3 millions string in an array but I don't
have a clue on how to find a fast sorting algorithm.  Quick sort will
probably do a stack overflow, bubble sort will take to ...

An app from a developer is producing an error on my win2k sp4 sys, in that
in certain circumstances it terminates with a Second Chance Exception in
MSVBM60.dll (v6.0.97.82)
The developer is unable to replicate the problem.

I'm having a problem with cookies in a virtual directory,
A cookie is created by an ASP application in the root folder i.e.
http://xxx.yyy.com
I'm unable to read this cookie in a virtual directory i.e.