simple vba code- active workbooks [SOLVED]

[asafraz81]

hi there

i have a little problem i cant solve'

i want to write a code that tells me what workbooks is active all the time.

i succeed to write a code that tells me how many open but i cant get the file name.

please help'

asaf

 

[sgmpatnaik]

Hi


Please give your code here we will check that


Thanks


SP

 

[NARAYANK991]

Hi Asaf ,


Try this :

[pre]

Public Sub Name_Open_Workbooks()
Dim wbk As Workbook
For Each wbk In Workbooks
MsgBox wbk.Name
Next
End Sub

[/pre]
Narayan

 

[asafraz81]

that works

but i want to put this inside cells.

instead of msgbox i need to put the names in a cell

 

[asafraz81]

THANKS'

I MADE IT BY MY SELF.

 

[SirJB7]

Hi, azafrz81!

Glad you could solve it by yourself, well done. Maybe you want to share your solution with the community, so as people who read this would have the issue or question and the solution or answer as well.

Regards!