VB Forum / General / February 2008

A question cropped up in excel.programming, it went unanswered for a while
until I chimed in with a partial response -
http://tinyurl.com/3ycmkd
Paraphrased, Excel/VBA does not expose a resize event of the Excel's main

I have a program that encrypts its password and stores this in the
registry.(OK I know this is not rocket science) but what I want to know is,
could I store this in the registry as a string of *
Convrt it like the PasswordChar does with VB Textbox and then change it back

Has anyone had bad experiences with CodeSmart for VB6?
I am trying the demo version but cannot do some of what i want to try
because my app is large.

I am using the inet control to call a web service.
The Requesttimeout is set to 120, but after 30 seconds
I get a state changed to disconnecting (9), disconnected(10),
then error(11) with error code  12002 and description "timeout".

I have a string variable represnting a date. How can i find out which
format of the DateTime it is in? Like is it in this format dd-mm-yyyy
format or this mmddyy format or what?
thanks,

Is there any way I can display the RH menu that is displayed in a text
box control?
I want to be able to type text into the text box, but I want to disable
the RH menu

We have a home grown out of process automation server written in C++.
When I use the following lines it works
Dim objSvr as Object
Set objSvr = CreateObject ("ProgID")

VB6SP6
How to do a search and replace in IDE?
e.g. Search for Chr and Replace with Chr$
Code can be

i need help on how to go about accessing windows protected stoarge area.I am
trying to develop a tool to figure out lost passwords/user names
thanks

I am creating a report in Visual Studio. This how much of a moron I
am, but I believe I'm writing in Visual Basic. On the report I want to
create columns for CurrentMonthInvoiceAmount,
MonthLessOneInvoiceAmount, etc. (doing a rolling 12 month Customer

I'm looking to upgrade from Access 97 to Access 2000. The code in question
was all written in VB5 Sp3 using Dao 3.5 as a reference. I've tried
referencing DAO 3.6 but still get Err 3343 "Unrecognised Database Format".
Searching this site led me to a service pack upgrade that ...

In sheet1 I have Row 7 as header. From row 8 there is data.
In header have items in columnB, quantity in columnF, channel in
columnH & date in column I.
I want a routine which will give me a summary in sheet2 based on

I hope this is the right place to post this question. I have a VB6
application that has been using automation to run code in Excel for years
and all of a sudden, it can't find the function in Excel that I'm calling.
I'm posting my code below but it's fairly straightforward. I ...

Has anyone installed SP1 on vista to determine whether it affects VB6
apps?
Microsoft Says Vista SP1 Blocks Third Party Apps
http://www.crn.com/software/206801221

I want to display function name and line numbers in my error messages.
Does VB6 have equivalenst to C/C++'s __LINE__ and __FUNCTION__ macros ?