i used "Application.FindFile" to open the other file. Is there any way of
copying the information from the open file into the template after the file
is found? I want to be able to open the file copy the information into the
template and and close the file at the touch of a button. The filename will
not be the same which is what is making it difficult for me.

"NickHK" wrote:

"Application.GetOpenFilename" allows you to get the path/filename of any
file.
You then have to .Open (or do whatever you want) the file yourself.
The Help file has an example.

NickHK

"enyaw" wrote in message
...
I want to be able to open any file. The code
"Application.getOpenFilename"
only opens the open file window but i cannot open any of the files from
there. The excel workbook that will use this code is a sort of template
that
has a user form allowing to add and edit the data. After the user opens
the
file i want to be able to automatically copy the contents of that file
into
the template.

"NickHK" wrote:

You can start with Application.getOpenFilename.
Once you have opened file, record a macro of your step.
Put them together and lets us if it's working.

NickHK

"enyaw" wrote in message
...
I want to create a code that at the press of a button will allow the
user
to
search for a file and open it. When the file is open I want to be
able to
copy the contents of sheet1 into another workbook called "product
calculator". Anybody got any ideas?