VB Forum / COM / October 2003

I'm populating a spreadsheet with an SQL recordset through VB code
(v6.0).
I need to HIGHLIGHT a cell if it meets certain criteria.
I need to know (and trust me, I've looked all over the net/MSDN

I need to use Excel Automation to apply an excel template to an excel
document automatically.
Some background info... Basically my application exports an excel document.
Before, users used to open up this document in Excel and applied a template

Can anybody explain me how can i use Err.Raise in a DLL,
and the err is passed to the client? In all the MS's doc
that i read all say that if you raise an err in a
component module that doesnt have an 'on error' then the

I have encountered a strange problem with binary compatibility which I could
use some help with. First a little background (I'll try to keep this
brief...)
Firstly I have several years of experience with binary compatibility in VB

I have developed one COM component using ATL .One of my interface method
returns Varaiant .Variant contains array of VT_BSTR packed using safearray.
How to read the safe array in vb.
VC++: GetParams(VARIANT *varTemp)

I have two versions of a product and I want to create a single installation
so that while installing, the user, can choose which version he wants to
install.
At the moment I have two installations, one for each version. How do I

I am modifying an exiting code to include only one ascii attachment
while sending emails through smtp.
I am having problems figuring out the correct header information that
needs to be passed in to my winsock control.

We are developing COM+ business layer using Visual Basic 6.0 ActiveX Dll.
We have few doubts or please suggest the best practice for the following
Scenario.
Client.dll consists MyClient.cls, MyView.cls, MyProfile.cls, MyEntity.cls

I have been trying to utilize the Rule.dll component
provided with the Exchange 5.5 SDK and have had minimal
success. I have compiled the component per the
instructions on MSDN and have written VB Code per the

We have an Excel macro that calls Microsoft Common Dialog
Control to display a "Save As." dialog. This works on
only some of our clients machines. We've added the
codebase attribute and if the control is not present on

I have a following problem.
I have a DLL written in the VB. An ASP file creates DLL's
objects in the
following way:

I have written an Add-In for MS Word.  Can anyone tell me the most reliable
way to get the full path to the temporary directory used by MS Word?  On my
system it happens to be:
C:\Documents and Settings\Self\Local Settings\Temp\Word\

I'm developing a VB6 application
I've got an ADO Data Control and a Recordset Object pointing to the same
table, now I insert a new record on the ADO Data Control, but that new
record doesn't appears in the Recordset Object even if I call the Requery

VB 6 doens't seem to be creating .frx from all the forms.
Does anyone know or how can it be fixed.
Your help would be much appreciated.
VB 6 SP5 OS : Win2000

How can I obtain My local ip address from a vb application ?
thanks in advance
by
Ale