Search : in
By :

Open a folder in excel

Last answer on Oct 17, 2009 5:57:02 am BST PM, on Sep 30, 2009 8:45:24 am BST 
 Report this message to moderators

Hello,

What is the vba code to open a folder in excel, i have tried assigning a hyperlink to a command button, but this opens the folder from the root and not from the sub directory. e.g. C:\Home\Folder... (Just to clarify, i need to open a folder and not a file)

Does anyone know how i can get around this??

thanks

PM

Configuration: Windows XP Internet Explorer 6.0
Excel 2003

Best answers for « Open a folder in excel » in :
VBA: How to know everything about the file folder ShowVBA: How to know everything about the file folder Preliminaries In module In sheet1 module Preliminaries Open a new workbook Add a module In module ' Declare variables for wizard. Public balloon1 As Balloon Public balloon2...
ITunes cannot locate my ITunes folder ShowITunes cannot locate my ITunes folder Issue Solution Issue I just bought the iPOD TOUCH. I have iTunes 8X, but it won't open saying .. "The folder "i Tunes" cannot be found or created, and is required. The default location for...
No folder options in Windows Explorer ShowNo folder options in Windows Explorer File corruption and virus infection may lead to absence of the folder option in Windows Explorer. To recover “Folder Options", go to Menu Start and select “Run” . Type...
Hyperlinks ShowIntroduction to anchors Hypertext links or hyperlinks (anchors) are HTML elements that, when clicked on, enable readers to visit a new address. Hyperlinked text is underlined by default. Hyperlinks are what connect web pages to one another. They...
Ask your question Reply

1

LouisSteph, on Sep 30, 2009 8:50:10 am BST

Dear PM,

Please consider checking the solved problem through the following link:

http://en.kioskea.net/forum/affich-118204-open-an-excel-file­-from-aform-in-vba

and hope that it helps you in your difficulty.

Thank you.

   
Reply to LouisSteph

2

PM, on Sep 30, 2009 10:50:54 am BST

Hi,

This doesnt contain the information i need, do you know of anything else that will work.

thanks

PM

   
Reply to PM

3

 LouisSteph, on Oct 17, 2009 5:57:02 am BST

Hi PM,

Are you looking for more suggestions actually?

Thanks in advance.

   
Reply to LouisSteph
Ask your question Reply
They need your help