I have a macro which i run on a file weekly. When i save the file is there
anyway i can put in a input box by in which some contents remain constant and
the user can input other data.
eg: ABC will be constant and the user will put in 10-6-06

I have  a column with links but would like to create a new column with
the urls they are point ting to
for example
A1=google   but the hyperlink is www.google.com

I have  a column with links but would like to create a new column with
the urls they are point ting to
for example
A1=google   but the hyperlink is www.google.com

I have  a column with links but would like to create a new column with
the urls they are point ting to
for example
A1=google   but the hyperlink is www.google.com

In column A there a bunch of cells
I want to extract all the hyperlinks associated with the cells in
column A into Column B
for example

I'm trying to hide rows without using autofilter (I need to execute
code when filter choice is changed and don't want to have to use
Worksheet_Calculate because of all the complications it can cause), so
I"m using a dropdown from the forms toolbar.  My problem is the

Is there any way to import certain data from multiple workbooks held i
a directory and sub directories below that.
I recieve 8 workbooks every month from 8 suppliers. They are saved in
subdirectory under c:\audit. For example: supplier1 subdirectory-wit

I need to set up a form to help in adding data to a worksheet.
How would I go about setting up a form for the following Worksheet:
Reciept | Date | Details | Amount | Security | Entertainment | Gambling

My Spreadsheet has worked fine until it was shared on a network.  Now when it
is opened on another computer a new macro is created and the function does
not work.  Does anyone know of issues with networking and macros???
Thanks

I have a macro that brings up an Input Box which takes a filename
(fnames$) and saves an excel sheet as that filename, I need this to
create a folder first then save itself in the folder. The folder name
would be the same as strProjectNumber...

I am not sure if this is possible.  
I have a excel database that have a lot of information.  What I want to do
is, creat another worksheet within the workbook, and select only the cell
that have information in the database worksheet.  

Hello,
I have the following hardcoded function in a worksheet:
=IF(ISNA(MATCH(1,('[Option 11 CSV.xls]May'!A1:A10000=20)*('[Option 11
CSV.xls]May'!B1:B10000=6)* ('[Option 11 CSV.xls]May'!C1:C10000="F")*('[Option

When setting up numerous modules I like to have them numbered so that all
like info is in the same "grouping";  ie: group 1 (1 thru 19) is all custom
menu Stuff)
group 2 (2 thru 29) is all print stuff;  etc................

Even though this applies to excel, it might be slightly off topic. But
this can't be that uncommon a problem, so I'm hoping someone has
already invented this wheel.....
I need a report with this:

I am using macros, with Userforms to run reports that gets it's data from
SQL.  Some of the reports take a little time to generate.  Is there some way
to display the progress of the calulating cells complete in a message box to
let the user know that the program hasn't locked up?