Create pdf from closed workbook

[mtcas]

Hello,

To generate pdf file from active sheet, I use code below. Is it possible to generate pdf file with closed workbook? For example: In file one I have a button with code, which generate pdf file with data from another closed workbook.

Please Login or Register  to view this content.

Im trying to use this code, but I don't know why the path is still wrong. Everything is saved in C:\users\username\Documents\zpm23.xlsx. Should be where is file started macro.(desktop)

Please Login or Register  to view this content.

[kasan]

Hi,
Didn't you miss one digit in the name of file?

"Everything is saved in C:\users\username\Documents\zpm23.xlsx"

Please Login or Register  to view this content.

[mtcas]

What digit? everything is like in above code.

Ok, I think I stay with this code, but if someone know how open workbook without any flash and do something, I'll be happy.

Please Login or Register  to view this content.