I have a developer who is attempting to open an Excel workbook via VB6.
He dims and later sets the appropriate variable to an Excel.Application. He
does the same for a workbook object. The code is running off a server, with a
mapped drive of W. To troubleshoot and test, he uses ...

write macro that copies any numbers in a cell & appends those numbers
proceeded by a "." to the contents of another cell, same row?
example:
r1c1                                  r1c2

please see the code below
sub btn_click()
'lis == listbox control in userform
set rng = range("a2:a5")

This code is not working for me...I want to cycle through each sheet in
my workbook and run and IF statement.  It is not cycling through my
sheets, please help! TIA! - mike
   Range("A1").Select

Hopefully someone knows this one quickly,..if so please help
This line fails when i run my macro, however when I step through line by
line, the macro works.
ActiveSheet.ChartObjects("Chart 1").Activate

 I have two spreadsheets that I import into two seperate tabs in my
workbook.  The goal is to list projects that match from one sheet to
the other, as well as a seperate section for projects that do not
match(reconciliation).  I currently have a macro that pulls the data

I have created some hyperlinks and want to smarten up the sheet by putting
these onto 3D buttons.
Can someone please tell me how I put existing hyperlinks onto VB buttons and
run them.

The files I work with have names like : "16A-11H1H_JMDI4_265PH.CHP"
where "265PH" is a project name.
I want to write a Excel VBA scrpit, to prompt user to enter a project
name such as "265PH" and have the program to look into a directory to

I was wondering if there is anyway that you can fill the excel window with a
form (Like maximized within the excel window)?  Thanks for your help.
Lydon D. Bergin
MCP, MOS

I have a userform with a text box in it.   I want the user to enter the month
and date in the format mm/yyyy.   In the text box, I want to display mm/yyyy,
but when the user selects the TextBox1, I want it to clear out.   What do I
need to do to accomplish this?  

lets not hit enter this time!!!
I have a huge dump of data which I'm using a very basic macro to pick
up the columns I need, delete the top two rows and then sort the data
by value.

I recently learned that you cannot programmatically change the VBA Project
Password.  I like to password the VBA Editor so when I make a change to the
code I have to go the long way around to input the password.  I was wondering
if there is a code that will at least open the box ...

Hi guys;
I have On Error GoTo routine in a module.
in the error-handling routine, I have On Error GoTo 0
The first time the error is hit; process goes to "routine", correctly.

I want to execute some code whenever a filtering event has occurred
(selecting a value from the filter drop-down list). There are many events
that can occur on a worksheet (calculate, change, etc.) but none of them kick
off for a filter selection.

Can colour of text or figures be requested in formules like vlookup so that
what information you called up can be shown in its original colors