LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open workbook on close Mike[_114_] Excel Programming 0 January 8th 07 10:24 PM
Open Workbook in current directory Elijah Excel Programming 3 November 30th 04 09:05 PM
Close Open Workbook David Coleman Excel Programming 1 December 30th 03 05:53 PM
Close Open Workbook Bob Umlas[_3_] Excel Programming 1 December 30th 03 05:50 PM


All times are GMT +1. The time now is 08:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"