I have a problem with displaying the name of all open workbook

[Jastrzab84]

Hello All,

I have a problem with displaying the name of all open workbook. During the process of macro, it downloads and open automatically the excel file from internet. When this macro check the name of all open workbook by using below code then it will not show the name of downloaded excel file. It shows only when I run this code again. Do you know what it is wrong with it ?

VB:

Please Login or Register  to view this content.

Thank you in advance.

Pawel

[patel45]

-------- error -------