Sorry, I should have previewed before I sent the above reply. You will have
to do a little spacing to see how the columns are set up.

Thanks Again Matt@Launchnet

Launchnet wrote:
Thanks everybody . . .
With all your suggestions, I have come up with what I think is a very good
way of doing this if the code can be written.

1st . . . Example

Row Col A - Holds Path & File Name Col
B holds the Macro Buttons
15 c:\my documents\classhandouts1.xls Macro
Button (All use same macro)
16 c:\............\........\artworkphase2.xls
Macro Button (All use same macro)
etc c:\AnyPathTo File
Macro Button (All use same macro)

I have the user type in the complete path with file name in column A, which
is only 1/8" wide.
I have set the alignment formatting to reduce to fit cell as I don't
necessarily want it displayed
I have copied a Macro Button to each cell in Column B across from column A.
I want to use as many of the same macros as possible, simply by copying and
adding 1,2,3,4,etc.
The operator changes the Button Displayed Name to whatever they want on each
Button
Button can be any width for easier reading.

I want to have the operator click on the Button across from let's say A16
which is located in col. B
The Macro 1st goes to cell A16, which holds the complete path to open the
included file name.
SO FAR, I can do this much.
Next, the Macro needs to read cell A16 as a variable ( I think ),
Then, the Macro needs to open a new instance of Excel along with the Path &
File Name in A16
NOTHING TO IT ..... For you that is. Forget it if I have to write
the code.

This is a very clean way of running this application and I don't care where
their path is or where "My Documents" directory is, as the user does the set
up and also adds more files later on to open more files, which includes
copying one of the macros, re-naming it and changing the Button Top Name.

What do you think.

Matt@Launchnet

Nick -

[quoted text clipped - 23 lines]
Thanks Much
Matt@Launchnet


--
Please take a look at www.openoursite.com Click on: "Keywords" and then
Click on "Matt's Story" and if you are a man, you should be very happy that
you read my story. God Bless for everyones help.

Message posted via http://www.officekb.com