Uploading PDF with FTP using VBA

Hello,
I'm using a macro to make a PDF from a Excel sheet or selection. So far, so good. Now i want the PDF to go to a internet adress and i also want to do that by using a macro. But i have no idea how to do it. Someone told me to do it like this:

    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "ftp://ftp.mysite.nl/httpdocs/test.pdf", _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False

But it's not working

enyone?


Moderator Edit:

Welcome to the forum, bpenn.

Please notice that [CODE] tags have been added to your post. The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.