Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening A Folder Using VB Code
Hi,
I need some help with opening a folder by using a macro located within Excel. To open a file, it is straight forward as you use the following vb code: Workbooks.Open Filename:= _ "C:\Documents and Settings\Administrator\My Documents\Book1.xls", UpdateLinks _ :=3 However, is it possible to open a folder, say "My Documents" and secondly, how does one write this in VB code? Any help would be appreciated. Many Thanks in advance. Kiza --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening each file in a folder using msoFileDialogFolderPicker | Excel Discussion (Misc queries) | |||
opening file from ftp folder | Excel Discussion (Misc queries) | |||
Changing Opening folder | Excel Worksheet Functions | |||
Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
when opening folder | New Users to Excel |