ThisWorkbook.Path not working...
 

any ideas why when i call "thisworkbook.path" nothing is returned?
like it's null - not even being assigned...

thanks!

ThisWorkbook.Path not working...
 

Hi rmullen

If it is not saved there is no path
MsgBox ThisWorkbook.Path


--
Regards Ron de Bruin
http://www.rondebruin.nl


"rmullen" wrote in message oups.com...
any ideas why when i call "thisworkbook.path" nothing is returned?
like it's null - not even being assigned...

thanks!

ThisWorkbook.Path not working...
 

how can there be no path saved? i thought that everything in a computer
had a path .... can you expound a ilttle more?

ThisWorkbook.Path not working...
 

ok i was an idiot ..i know what you're saying now .. the workbook
hasn't been saved. makes total sense because for some reason my
workbook (copied from a template) is cloning itself twice. thanks for
your help!!! never even thought about that!