Hi all,

I was just wondering if one of you could help me out?

I need code for exporting a pdf (without installing any converter/application) (xps if pdf is not possible) of a Excel worksheet. This macro should be run whenever the worksheet is saved. Is it possible to save the pdf/xps file to a ftp server?

So, the thing I need is a macro that exports a pdf (preferably) of the worksheet to a ftp server whenever the worksheet is saved.

You'd be helping me so much if you could give it a try!

Thanks in advance