VB Forum / General 2 / December 2005

I have a problem in Excel - VB programming. For the purpose of Customer
Reporting and information, I've develop a VB module to display customer
information and a link to open an Excel file for detail information.
The excel file contain datasource in other link.. So, How to bypass ...

i have a FlexGrid (Databas)
GroupId       Group Name        MasterId
1             AAA                         1
2             BBB                         2

I would like to be able to bring up the programs menu, but I'm only
successful in bringing up the 'start' menu with:
       SendMessage hwnd, WM_SYSCOMMAND, ByVal SC_TASKLIST, ByVal 0&
Is there another Constant that defines the Programs Menu?

A VB6 program working perfectly well on most PCs will not load common dialog
OCX because of restrictions placed on a networked computer. Has anyone
remembered code to print without using the Common Dialog OCX? I'm so fed up
with the problems these runtime files create. I seem to ...

If there a simple way of determining the height/width ratio of pictures
(jpg, bmp etc) so that I can keep the proportions correct when a user
resizes an image control?
Thanks

How do I store the Form's caption up to the first "-" character in a
variable? For example, if the Form's caption was 52532-9846, then a variable
will store 52532.
Also, how do I store what is between a "-" character and a " " character in

I'm trying to use lzo compression in VB6.
I built the lzo.dll redefining __LZO_CDECL as _stdcall to have stdcall
conventions
I exported the functions I needed

I am having a problem with the StatusBar in VB6.  It does not always display
the simple text.  See example code below.  The status bar is set as Style =
sbrSimple.  The text at the end is always seen, but the text at the
beginning is only sometimes seen depending on when/where I ...

   When the condition arises I set a CheckBox.Visible = True then at a
later point I check for that condition If True Then ... Else ... It seems no
matter what I assign .Visible the value is always false.I even assigned
.Visible = True & typed ? .Visible & It showed false. Any ...

I want to make a program that works percents.  I mean that you for
instance 50% chance have that something succeeds and that you 25%
chance have that it fails and 25% chance that it yet something else
lifted.  How do I do this???

Excuse the posting from Google groups, but I'm at work.
I'm trying to create an install package for a VB6 program using the
Package & Deployment wizard (the only tool available). The package has
to include a third party ocx that is provided by it's developers as

At one time there was a desktop setting which caused items in a ListBox (and
various other things) to scroll pixel by pixel when you moved from one item
to the next. I can't remember what it was called now, but I think it was
available by right clicking the desktop and choosing ...

We've just installed MonoBASIC
http://shootout.alioth.debian.org/gp4/basic.php
Please contribute missing BASIC programs or faster more-elegant BASIC
programs.

Please help me how to read a text file from a website from internet and
display it in a textbox?
????

I have a noodle scratcher for anyone who cares to help:
I am using the following syntax in a function to gather data from an
excel spreadsheet:
rs.Open "SELECT * FROM [" + sheetname + "]", cnn