VB Forum / General / March 2005

Could anyone provide ideas on how to kill an excel process?  In our VB 6.0
app we populate data from MS Access to an MS Excel worksheet.  If you look in
task manager you could see the excel processes running in the background.  
Also, how could we identify which excel process to ...

sorry.. my file >
[url]http://www.geocities.com/yuri_boy2002/Newbie.zip[/url]
--
yuriboy2002

Currently I use DAO 3.6 library
and ODBC connection to access
SQL Server. If an error about database
occurs then a message

Q1. I need to save the selected items from a listbox(formA.lst1) into a
string(strA).
I did that by loading them into a text file then load it back into a string.
This is quite silly but it works, can someone tell me a smarter way to do

I posted this over on the database.ado board but haven't received a
good answer yet - hopfully someone here can shed some light on this.
I have an app in which the user is prompted to enter a userid and
password that are used to make a connection to an SQLServer database.

I have a table in SQL Server 2000, a field StatDate datatype datatime, 8 all
null true
When the Form open I am getting an error is the statDate is "Null" empty. so
I had to add this

I need to gather the runtime in format "HH:mm:ss" of certain processes from
its start to its end, any ideas ?
thanks,
Federico

Is it possible to have text in a listview subitem do a word wrap?  (Similar
to what you see in MS Excel when you do a <Format><Cells><Allignment> Wrap
text.)  IF yes any help is appreciated.

Well, I spent most of yesterday serfing the net trying to find out about
DDE.  I guess its been replaced by OleDB.
I've got an users manual for an application which states it supports DDE
commands and a short list of which commands it supports.  From my research

Here's an irrelevent question, I thought you guys might have a clue about
it:
How to create a WMF file ? I mean which graphic software allows us to
create/export in WMF format? And also do you know which program allows to

I am working with a third party grid which takes the width as a long and I
want to resize based on the length of the string which displays as int.
When I try to use Clng(len(string)) it does not work.  So what do I need to
do?

List:
I'm trying to add icons to my project by compiling them into into a
resource file.
The resource compiler complains that "Resource file fred.ico is not in

I have a function that accepts some of its input as a ParamArray.
If I call the function and pass it 'real' values it returns correctly eg:
TestFunction (item1,item2,item3)
My question is how to call the function with a set dynamically built items,

Hi to all
I need your help in order to solve a problem that has had several VB
programmers!!
My application run well (at least, so it seems...) until it is closed.

I am creating a MDI application and when the user hits the cross to close the
app and selects no or cancel I want them to return to the current form they
were on with any data they had entered.
It appears to unload any child forms before running my sub routine that asks