VB Forum / General / May 2008

I am currently opening an existing Excel file from a macro within
SolidWorks (thus written in VBA). Is there any way that when the
spreadsheet opens, it checks to see where it was opened from? If it is
opened from SolidWorks I would like it to launch a certain macro

I'm using a ComboBox (Type 2, DropDown List) to choose the desired Printer
in an application I have. The second item in the Combo's list is the user's
Default printer, and all the other printers are below that. The First item,
however, is a "special" printer, not really a printer, ...

I am trying to get VB to sort my Excel Worksheet.  When I run the program
everything in the sub runs fine except for the sort.  Instead of sorting it
moves data from one cell to another - kind of odd.  Since the sort commnand
is one long command I can't step into it and see what ...

I'm changing the way I store some settings data from the registry to a file.
Using Inno Setup I wish to place the file in the "CommonAppData" folder
which (by default) in Windows XP is
C:\Documents and Settings\All Users\Application Data

I know that when the style is set to checkbox, the select
mode can only be single. However, I would like to use
code to allow for multiselect.
Does anyone have a link to a routine that can do this?

I'm trying to clean up this very messy vb app that someone handed me.
It has dozens of modules and they seem to be scattered in several
different folders. Is there a way I can tell the path of each of these
modules.

I've seen two samples of idl pertaining to an object
source: from http://www.devx.com/vb2themax/Article/19830/0/page/4
not sure which is appropriate to arrive at a method like:
'interface

I get this error when I try to update the "groupType" using both VBS
as well as ADMOD. Why? The group I am working with has no users - it
was freshly created as a global group and I can't seem to change it to
a local (or universal) one.

Greetings all,
couple questions on collection classes
Given an object (cLayout)
I want a collection of those

I'm using a Function X that takes 3 arguments :
Function X(m As Integer, upperleft_X As Single, upperleft_Y As Single) As
Variant
Inside th event Private Sub List1_Click() :

How can I determine if a computer is using the Vista operating system within
my VB5 application.  If using Vista, I want to perform a certain task one way
and if XP another way.
Thanks,

I am using the Format command to convert a Variant to a String. The
Variant contains a hex value. My code seems to be working perfectly in
all cases except one single instance, and I can't see what's unique.
Here is the code, and a description of the output I'm seeing:

Hello again...
can anybody point me to a solution for the following problem:
I would like to activate a window by its processname (if processname is
the correct word).

THis should be easy but I cannot think of a solotion.  I have a list
of 10,000 names and I need to randomly sort them for a study I am
doing.  Any suggestions on how you would apporach this??

I'm writing to a txt file using the Print command.
One line of the text is a string that contains the # character.
For example,  the code is
Print # FF, "blah blah blah # blah blah"