Active X Control Help

[Grant]

I am having trouble running the code below. When I run it my message test
tells me I'm connected. But I still get the Run-time error '1004' Method
"Save As' of object _WorkBook failed. I have to go to the Excel open dialog
box and Look in: Add/Modify FTP Locations. Click on ftp selction I want,
then it prompts me to enter User Name and Password. This is what I am trying
to avoid. Maybe I need to use some other way to ftp the file instead of the
SaveAs? How else can I do this?

 

[Stephen Bullen]

Hi Grant,

This is what I am trying
to avoid. Maybe I need to use some other way to ftp the file instead of the
SaveAs? How else can I do this?

Just a suggesting, but you could try embedding the username and password in
the ftp location:

ActiveWorkbook.SaveAs "ftp://user[email protected]"

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

 

[Grant]

I've tried that and it doesn't work. I get the same run time error.

 

[Stephen Bullen]

Hi Grant,

I've tried that and it doesn't work. I get the same run time error.

Darn! Then I guess the only choice is to save the file locally, then
transfer it using the FTP control.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk