Locating my personal.xls

[Simon]

I have used the Search option but can't find it.

Where does it lie by default?

Thanks

 

[Ron de Bruin]

Hi Simon

See
http://www.rondebruin.nl/personal.htm

 

[Robert Flanagan]

Press ALT-F11 to go to the vb editor. If you see personal.xls there you
have one. Add the following to a module in it and run it:

sub whereamI()
msgbox thisworkbook.fullname
end sub

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel