Thread: How to get the full path name of the open workbook in a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Flystar[_10_] Flystar[_10_] is offline
external usenet poster
  
Posts: 1
Default How to get the full path name of the open workbook in a macro
How can I get the full path name for the open workbook using a macro? I
have tried using the CurDir() function but it is not working.

eg. If I open my workbook from C:\Data\Excel\, I want to be able to get
this string "C:\Data\Excel\"

I am using excel 2000 on Win98SE


---
Message posted from http://www.ExcelForum.com/

Reply With QuoteReply With Quote