Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Newbie: Open A Directory
Hi ratman, This seems only to change the current directory. I eventually played with this and got it to work: Dim strCMD, RetVal strCMD = "Explorer.exe \\My_unc\folder" RetVal = Shell(strCMD, vbNormalFocus) Kind regards and many thanks. -- Viz- Viz
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Newbie: Open A Directory
Again, many thanks for the reply... What I would like to do is simply open a folder, rather than use any of the application's dialogs. The excel spreadsheet has a control which opens a word document which is stored on a network. I need another control (embedded in the spreadsheet) which will...- Viz
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Newbie: Open A Directory
Thanks for the reply. I have some controls in an Excel sheet which do various things (open word documents, etc.). I need another control which simply opens a directory. Any thoughts? -- Viz- Viz
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Newbie: Open A Directory
Hi All, I need to have a control open a directory, what command should I use? Many thanks in advance... -- Viz- Viz
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Winword & VBA - creating a DOC from a DOT?
Dim Document Dim Application Dim blnError Set Application = CreateObject("Word.Application") Application.Visible = True Application.Documents.Open ("c:\mytemplate.dot") This only opens the template. How do I create a new document from a template...- Viz
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
