list of Opened excel files

		Microsoft Office Forums > Microsoft Word > Word VBA
list of Opened excel files

FAQ

Thread Tools

Display Modes

04-13-2011, 09:23 AM

SDondeti

Windows XP list of Opened excel files

Office 2007

Novice

Join Date: Apr 2011

Posts: 7

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
seach an Excel list elements in word document	7ajar	Word VBA	5	03-16-2011 12:38 PM
Importing many vcf files in excel	shiflerg	Excel	0	01-26-2011 09:16 AM
Creating mailing labels from list in excel	wordnoob2	Mail Merge	0	12-13-2010 03:46 PM
Opening multiple Excel files within the same Excel window.	lost9471	Excel	2	05-01-2010 01:57 PM
Creating a Distrubution List from Excel	webphotogeek	Outlook	0	01-10-2008 11:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:47 PM.