View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
T Lavedas T Lavedas is offline
external usenet poster
 
Posts: 38
Default open Workbook path

On May 7, 1:18 pm, "Boba" wrote:
"Gary''s Student" wrote in message

...

Sub listum()
For Each wb In Workbooks
MsgBox (wb.Name & wb.Path)
Next
End Sub


--
Gary''s Student - gsnu2007h


Thank you for your prompt answer,
but what you suggest is VB (not VC)
version - and my Automation application
is written in C++.


He gave you all you need to know, regardless of exact syntax. The
point being, that however you are accessing the 'Names' of the
workbooks, if you simply replace the Name property with the Path
property, you have your answer, as in ...

var sWBPath = yournamefortheWorkbookObject.Path;

OK, is that C++ enough.

Tom Lavedas
===========
http://members.cox.net/tglbatch/wsh/