Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 8
Default file folder macro's

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
  #2   Report Post  
Bill Manville
 
Posts: n/a
Default

Try
Application.GetOpenFilename

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

  #3   Report Post  
Giovanni D via OfficeKB.com
 
Posts: n/a
Default

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....
  #4   Report Post  
Brian
 
Posts: n/a
Default

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....



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros and File Lost Kelli McCann Excel Discussion (Misc queries) 0 May 13th 05 12:40 AM
save excel file from a table delimited file (.txt) using macros sedamfo New Users to Excel 1 February 15th 05 05:19 AM
Deny file access if user declines macros? [email protected] Excel Discussion (Misc queries) 3 February 7th 05 04:02 PM
Macros making file saving extremely slow. Donald Speirs Excel Discussion (Misc queries) 1 January 20th 05 11:10 PM
Macros disappear after a file is imported Brent E Excel Discussion (Misc queries) 1 December 18th 04 01:25 AM


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"