I want to use the BVA code to bring up the brose pop-up screen (this the
same screen that when we click on "Open" file to brose the file to open).
After user brose and select the file, I want to capture that file name.
Can anyone help me with this?

I want to position the mouse on the screen and press a shortcut key (like
Ctrl-d) to get the mouse coordinates.  Thanks, James

hello - I have a combobox that has the source from D2:D12.  What I want
to acomplish is, if a user enters in something that is not found in the
dropdown, or D2:D12 that a yes no msg pops asking if they want to add
it, find D13 and add the text there so it's available later...make

I have this code to print rows 1 - 35 however I would just like to print the
rows that have data in col B because often I'm printing an empty page by
printing all 35 rows.  I would like the print area to print col A - F but
only when there is text in Col B of that row, how would ...

I create a couple custom add-in's and saved them in a network folder under
the name ABCToolPak.  After I created a few worksheets using the custom
functions  associated with the ABCToolPak, I moved the add-ins to a different
network folder and renamed it XYZToolPak.  I then ...

Calling all Excel programming brains,
I am trying to move and rename a file but don't know where to start,
can anybody help?
Thanks,

Just trying to find out if this is possible.
I have a textbox placed on my worksheet and it's properties set to scrollbar
vertical. Now I can typ all te text I want even if it doesn't fit because I
can scroll up and down. Now here's my question: When I want to print this

I have a small problem ... I would like to sort more than 3 columns
(actually as much as I want) in excel using vba programming. In the same, I
would need to be able to choose if a column should be sorted  ascending or
descending.

I’m looping through a bunch of columns.
I want to store the column indexes 1, 9, 18, 21 in a cell, whose named range
is Columns.
Not sure how to…

I have already tried some macros here for highlighting both the row and colum
when a cell is active. Below is the code I am currently using. Can it be
modified on the colum side to say that the highlighting start at Row 27 and
continue on, as we have froze the upper portion and do ...

I have a dumb user who keeps forgetting to change from the input sheet to the
report before doing File Print. Is there anyway I can set the menu to print a
range on the other sheet?
Can I do this without writing any code?

I know there are some great chart labelling tools out there, but I decided to
go it alone.... I can label a chart using a routine which reads a stats
report, and labels a,b or c or any combination of, depending on which groups
are different from control. Works great. But, I'm ...

I have a csv.  There are no text " delimiters.  I am trying to validate
the parsing, but within some fields there are embedded commas.  This is
in fields that have things like an email where it might say:
2/24/2006,1:23PM,Smith, John <johnsmith@gmail.com>,next field,next

Assigning small 2D arrays is easy.
This is a 3x6 array:
Array_A = [{1, 3, 6, 10, 0, 0; 1, 1.2, 4.5, 6.8, 9.2, 10; 0, 0, 0, 0, 2, 3}]
Every line is separated by ";".

Hello, I am just switching to using 2007 (beta2), and it is quite a
struggle. One thing that I can't seem to do is to find a setting where I can
run my own macros without completely switching off all macro protection. Is
there a setting tht will allow me to choose whther a macro ...