VB Forum / General 2 / February 2004

I rebuilded (compiled) an OCX. For some circumstances I had to rename the
OCX and to move it into another directory on my developping machine.
My Projects has more than hundred forms. When I open the project, every form
says "could not open reference".

I have a lot of Excel templates loaded with macros, sums, avg and
such, which I need to feed with data everyday (SQL Server). The files
have very complex formating: headers, footers, subsections,
conditional formating, groups, and more.

I have created/recorded a macro in MS Excel 2000. I have set an
autofilter in the macro passing the parameters through input boxes.
Once the Macro has run i have around 5 rows and 6 columns of data
left. I now want to select the top left hand cell (which changes, and

Any one knows what program - and where I can find it - that shows the
dependency information tree.
It was installed somehow in my PC and then vanished.
It was a very helpfull choice I had by right clicking on any 'dll' or

I don't want any part of the previous discussion on Visual Basic
versus Visual Basic.Net.
My query is about using Visual Basic for Applications; and whether it
is better to use Visual Basic 6 or Visual Basic.Net as a springboard

I'm trying to have a Project create a button when loading the project.
I've got it working if I manually create the button. But when I
recorded the macro to place the button and then have the code execute
on project startup it creates a blank button!  The button is

I'm trying to think of a way to get a user to type a string to compare with
FileDateTime - which is maybe Date As Long? Anyone know how I could convert
FileDateTime to something to compare with any typed date? Or convert any
typed date to compare with the FileDateTime response. Help ...

How do I link theOutlook Express 5.0 type library in my projects.
Do I need to register it with VB ?
Many thanks,
Richard Brooks.

I have an appl in which I can move (image)items around in a form. Works fine
with drag and drop. But once in a while (lets say 1 out of 10 or 20) the
mouse jumps to the middle of the object while I am moving. Is this some bug
in VB, Windows or what?

My question is there a way to exit a subprocedure aside from running
it to the end and aside from calling "Exit Sub"?
For example, say I have a subprocedure like this:
Private Sub FirstProcedure()

I am using winLirc to receive date from my Packard Bell Fast media IR
remote. The problem I have is that Winsock1_DataArrival(ByVal bytesTotal As
Long) Is called two times almost every time I press a button on my
remote.Way is it doing that???

I need to determine if the user is logged to domain. Basically I need to get
Domain-UserName pair for the current context. Cannot figure out which API to
use. Any help/suggestions highly appreciated. TIA!

Thanks for the previous help but now I have encountered another problem when
I am looking for the largest number. The code I have now works well unless
two or more of the inputs have the same value. If x and y are the same then
it won't compare it to z. How do you fix that? Thanks

I've made a poker game in Visual basic, and am relying on labels to tell the
user what cards have been dealt.
My question is, does anyone know a site where I could get the 52 images for
playing cards, so I could replace my labels with actual pictures of cards?

I have a number of text boxes on a form I would like to validate using
KeyPress (or something similar) as values are entered, but I would like to
move the code to a standard (.bas) module to do so. Can this be done -
intercepting the form keypress from the standard module?