ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VB code to determine address of activeworkbook (https://www.excelbanter.com/excel-discussion-misc-queries/171772-vbulletin-code-determine-address-activeworkbook.html)

Kevin

VB code to determine address of activeworkbook
 
Hi

is there a simple line of code which determines what the file address is of
the activeworkbook
--
Kevin

Wigi

VB code to determine address of activeworkbook
 
Hi

ActiveWorkbook.FullName

and

ActiveWorkbook.Path

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Kevin" wrote:

Hi

is there a simple line of code which determines what the file address is of
the activeworkbook
--
Kevin


Kevin

VB code to determine address of activeworkbook
 
fullname works for what i need

many thanks
--
Kevin


"Wigi" wrote:

Hi

ActiveWorkbook.FullName

and

ActiveWorkbook.Path

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Kevin" wrote:

Hi

is there a simple line of code which determines what the file address is of
the activeworkbook
--
Kevin



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com