View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Macropheliac@yahoo.com is offline
external usenet poster
 
Posts: 8
Default Open a directory and close workbook

Hello!
I've been going round and round with this one. Perhaps it's not
possible, but I would like to know how to open a directory and close
the active workbook, leaving the directory open. It seems simple, but
I can't figure it out.

Dim MyDirec As String
Set MyDirec = "C:\Documents and Settings\Owner\My Documents\My Daily
Schedules"

Now what?

A heart felt thanks to anyone who may have a suggestion.

Mac