Is there a way to look up activeworkbook.path like (D:\faceit\book1.xlsb)

[pedie]

Is there a way to look up activeworkbook.path like (D:\Face\it\book1.xlsb)
If there is a way to find this out without having to go and right click on the icon and looking up properties?

Any suggestion will be appriciated

 

[VoG]

Try

=LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1)))

 

[pedie]

Peter, I do not have the file path in a1, I am trying to find it out.


Good Afternoon!

Please look in to it again!

 

[VoG]

Did you actually try it?

 

[pedie]

lol, yes...

it gave error....but i was not even sure I just entered this formula in B1<TABLE style="WIDTH: 56pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=75 border=0><COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 56pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=middle width=75 height=17>#VALUE!</TD></TR></TBODY></TABLE>
:wink:

 

[VoG]

You need to save the workbook first or it won't work.

Excel Workbook
	C
1	",CELL("filename",A1)))]C:\Users\Owner\Desktop\[Book1.xlsm]
Sheet3

 

[pedie]

Okay I think this error is because the file is from web, I have not saved this file anywhere...it is a content of website.

When I try this in another book that was saved in desktop it work..It gave me the path....!

I'm sorry...

Will it work with any type of file??

 

[pedie]

Peter...My apologies...IT WORKED NOW when i entered the formula somewhere else...


Thanks alot....Thank you... thank you

 

[VoG]

It will only work with Excel files.