Counting the excel files are being opened

[vinoblm]

hi Guys,
i want to count how many times excel files are being opened. precisely, when i open an excel file, count starts and when i open another excel files,counts to two and so on. this should be recorded in the registry file.

thanks,

Vinodh.

 

[Nebu]

Hi:

Use the following code.

Set objExcel = GetObject(, "Excel.Application")
Set wb = objExcel.ActiveWorkbook
Set wb1= objExcel.Workbooks
MsgBox wb1.Count

Thanks

 

[vinoblm]

Dear,

thanks. but it doesnt work as i wanted. i want to count how many times excel
files are opened,not just any particular file, any excel file.

thanks

 

[Nebu]

Hi:

follow this link
http://www.mrexcel.com/forum/excel-...code-count-how-many-time-workbook-opened.html

Thanks