vba: knowing which workbook is open now.

[lezawang]

Hi
I ended up and a problem when i tried to preview print a wk. The code below will not work because the workbook that was open, its name was workbook2. Thank you so much

<code>

Sub mywk()
Application.Workbooks(1).PrintPreview
End Sub

PS: sorry what is the tag used to include my code? I forgot it! I tried to user <code> </code> but did not work. Sorry

</code>

 

[Yongle]

Try

ActiveWorkbook.PrintPreview

PS: sorry what is the tag used to include my code? I forgot it! I tried to user but did not work. Sorry

Click on # icon above post window for code tags