View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Who last opened file?

In the testing I've done, it appears the value i seek is always preceeded by
the following, if that will help find it in the file.

_p____

that's Underscore, lowercase p, and four more underscores......

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

Hi All...........

John Walkenbach has an article on his site that describes how to use WordPad
to see who was the last person to open a particular .xls file.......it's here

http://j-walk.com/ss/excel/odd/odd26.htm

My question is, how to use VBA to interrogate a .xls file and extract
this information?

TIA
Vaya con Dios,
Chuck, CABGx3