Thread: [Solved] list of Opened excel files
View Single Post
 
Old 04-13-2011, 09:23 AM
SDondeti SDondeti is offline Windows XP Office 2007
Novice
 
Join Date: Apr 2011
Posts: 7
SDondeti is on a distinguished road
Default list of Opened excel files

Hi,

I got some problem in finding the names of all excel opened files using word VBA.

Following code is working in excel vba but i am not able to do it in word vba. Can some one help me. Thanks in advance.

Dim wb As Workbook
For Each wb In Application.Workbooks
MsgBox wb.Name
Next

Thanks,
SDondeti
Reply With Quote