Linked workbooks

G

Guest

Hello world :)

I'm using linked external workbooks in a main workbook
I want to know the SaveDate of the external workbooks.
I don't expect to find an excel function so i try to do it via VBA

Does anyone know in general how this can be solved
if not
I need to know where the links to the ext. workbooks are stored (i looked in
"application" an "thisworkbook" but couldn't find it.)

I'd like loop throug all linked wb on opening the main workbook and look up
their savedates to print them in cells, so i have a quick overview on how up
to date the ext wb are.

I hope i described my problem so it can be understood.
 

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

Similar Threads

How to store the reference of Workbooks in an array. 4
automatic replacing of vbe code for multiple workbooks 1
Syntax problem fassing named range into function 1
calling sub from other workbook 1
listbox getting error 380 cannot set the rowsource property 2
Unwanted workbooks on startup 2
How to reference a file in a different instance of Excel? 4
Implement a progress bar when the macro run inside another workboo 2

Top