"For each w in workbooks "can't find ".dat" open excel sheets,

R

Ricky

I use "for each w in workbooks --- Next w" to find all open workbooks. It
doesn't seem to find .dat files opened in excel, but will find .csv files
opened in excel. How do I find all open files that have been opened by
excel2007? It seems to work fine on older excel software.
 
J

Jacob Skaria

Try the below...Sorry, right now I am unable to try this in 2007...

Sub Macro()
Dim win As Window
For Each win In Application.Windows
MsgBox win.Parent.Name
Next
End Sub

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top