hi All,
I want a macro in the excel 2007 which opens the folder (not in Explorer).
The link will be saved in the cell sheet1 "D5".
Can any one please help me.
hi All,
I want a macro in the excel 2007 which opens the folder (not in Explorer).
The link will be saved in the cell sheet1 "D5".
Can any one please help me.
try this
paste your path in cell D5 & run the code
Please Login or Register to view this content.
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
if you want to open a particular folder for the user to select a file then use:
Please Login or Register to view this content.
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
thanks a lot, both the solutions are perfect..
Hi Glad we could help you
1. If the suggestion helps you, then Click * to Add Reputation and give your comments
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Last edited by Naveed Raza; 01-19-2014 at 09:23 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks