Im trying to create a macro to open a file folder but not a file within the folder. Can this be done or does anyone know a different way I could do it. At present I cannot run the macro without actually opening a file within the file folder and all I need to do is to open the folder within so I can open a file myself.


Any Suggestions??


Many Thanks

Try
Application.GetOpenFilename

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Hi Sir this is Gio from Philippines...... it's my first time here in
this site... i am wondering how can i solve this problem in excel and please
help me.. I used excel 2000 in creating an inventory program in the hospital.
I used this excel inventorry program in our suppply room, i used one
worksheet per item. and i have almost 300 items in the supply room or almost
300 worksheets. I saved it as a template for all i know it is safer to save
it as template rather than saving it as ordinary excel files. The program was
working well, but not when i started linking(hyperlink) it from a certain
file that i always used. Then i have save it several times as a template but
i notice that the program malfuncitons, it doesnt compute the formulas i
created and some formulas are gone. Why is this happening. when i add some
items in the inventory it wouldnt add to the current balance, why is this
happening? Will you please help me, you wer the only people who can only
help me with this kind of problem......please....

I would just import your spread sheets into ms access
"Giovanni D via OfficeKB.com" wrote in message
...
Hi Sir this is Gio from Philippines...... it's my first time here in
this site... i am wondering how can i solve this problem in excel and
please
help me.. I used excel 2000 in creating an inventory program in the
hospital.
I used this excel inventorry program in our suppply room, i used one
worksheet per item. and i have almost 300 items in the supply room or
almost
300 worksheets. I saved it as a template for all i know it is safer to
save
it as template rather than saving it as ordinary excel files. The program
was
working well, but not when i started linking(hyperlink) it from a certain
file that i always used. Then i have save it several times as a template
but
i notice that the program malfuncitons, it doesnt compute the formulas i
created and some formulas are gone. Why is this happening. when i add some
items in the inventory it wouldnt add to the current balance, why is this
happening? Will you please help me, you wer the only people who can only
help me with this kind of problem......please....