| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"For each w in workbooks "can't find ".dat" open excel sheets,
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"For each w in workbooks "can't find ".dat" open excel sheets,
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 --------------- Jacob Skaria "Ricky" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, | Excel Programming | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
Linear Mode
