VB Forum / COM / January 2004

I am trying to add a block of cells but sadly can't get
excel VBA to exactly read my intentions.
I really wish cells H8 to H12 to be totalised but using
the following statement the formula returns "Sum(H1:H12)

   Having worked with VB for some time now, I recently got my head into
VC++  one thing that VC++ can do is provide you with a means of trapping(for
lack of a better word) a dll's register & unregister events. So, what I
would like to know is: Is there a way to do the same in VB?

I really need to compute elapsed time using Access and VBA, or VB6 and
Access, or VB.net and Access.
I have two date time Access table fields, one for Start and one for
Finish. I am trying to calculate net workday work hours. If a trouble

My apologies if this question is frequently asked.  I didn't see anything in
the group prior to posting.
I have a need to detect if a certain  component is registered on a user's
computer.  In this particular case, my application uses MS Word for

Can you please help me by answering what could be the maximum size of .txt
files?
Thanx in advance.
--Su Man

I was asked a typical question in a interview. The question is as follows..
Suppose you make an COM component. Now while running the application with
the COM in middle tire the component fails. Naturaly the whole appliocation
will fail. Now what are the methods you can imply in such ...

My operating system is windows 2000 and i wrote a function
with a message box i called same in asp page , msgbox is
not coming. i checked it is not unattended execution.
If anybody has idea, please?

Hei
I got while running my application as like
run time error -'2147417843(8001010d)':
Automation error

I'm doing a very simple VB app that automates Excel. The
intent is to open an Excel document and save it as a CSV.
Here's the code:
Private Sub cmdConvertToCSV_Click()

I am trying to use MSCOMM32.ocx to receive binary data.
MSDN provides two sample code for text data. (Q194922- INFO:Receiving Data
using teh MSComm Control's OnComm Event) (for Send / Receive each). I used
them as the basis and then did the following changes -

I am trying to create the textbox which is over the limit 32K. Is it
possible? Please suggest me.
Thanks.
Richard

when i use the function inside this DLL
it said cant find DLL entry point GetAddr() in D:\....
what should i do?

BlankHi
Why Mscomm control works with one modem while with another one it calls and get connected but then hang up, and raises error at mscomm.input "operation valid only when port is open"
thanks

Anyone who knows a way to create a virtual serial comm port. By use of some
API??

  i am a delphi programmer.i have developed a COM(in-process) component
using delphi.
 can anybody please tell me how to import the type library of this server
from VB6.