?
Solved

Determine opened workbook file name and directory

Posted on 2004-11-29
2
Medium Priority
?
171 Views
Last Modified: 2010-05-18
Hi,

I need to find out the full file path of an opened workbook in excel, using VBA.

In the user opens the spreadsheet I want to strore the current full name and path to that file.

I know where to put the code.

Cheers

G
0
Comment
Question by:GlenmoranUK
2 Comments
 
LVL 24

Accepted Solution

by:
R_Rajesh earned 2000 total points
ID: 12694047
Hi GlenmoranUK,

try:
Range("A1") = ThisWorkbook.FullName

Rajesh
0
 
LVL 1

Author Comment

by:GlenmoranUK
ID: 12694107
Fantastic!

Many many thanks.

G
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses
Course of the Month15 days, 4 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question