Help with Excel to HTML then Upload to FTP

[Nick.123]

Hi, Hoping someone can help I would like to save a copy of my excel workbook as html then upload all the files (HTML & XLS) to FTP Server. At the min the script I have does save as html however it only sends the .xls file to ftp server. How do I get the html files to send along with the folder that is created when saving as html.

Files to send
NightRota.xls
NightRota.html
-NightRota_files (folder created when saving as html)
--Sheet1
---Sheet2, etc

Please Login or Register  to view this content.

Thank You

[Chippy]

Repeat the Send command for the .html file and use mput for the files in the subfolder, for example:

Please Login or Register  to view this content.

The above puts the files in the current remote folder; if you want to put them in a NightRota_files subfolder on the remote system (to match your local computer), use the mkdir command to create the folder.

To disable prompting for each file when mput runs, use the prompt command or the -i ftp command line option.

[Nick.123]

Thank You so simple :D

I have stumbled on another issue the workbook is saved to a network drive (UNC) the command line script does not work I get an error saying cannot use UNC directory is there any other scripts that I could use to avoid this command line issue.

Thanks Again

[Chippy]

Use ThisWorkbook.SaveCopyAs or ActiveWorkbook.SaveCopyAs to save the workbook to your local hard drive and send that instead of the network drive version.

If saving locally isn't an option, post your code and say which line gives the error and the exact error message.

[snb]

some less code will be sufficient:

Please Login or Register  to view this content.

[Nick.123]

Hi Thanks for your responsive, Sorry for delay in replying I don't seem to received email notification from forum.

I tried to use the code you suggested SNB however received an error stating Syntax error something I missed? I added the required information username,password etc.

Cheers

Update

Fixed initial error using code below however I now get another error, screenshot below.

Please Login or Register  to view this content.

Capture.PNG

[Nick.123]

Use ThisWorkbook.SaveCopyAs or ActiveWorkbook.SaveCopyAs to save the workbook to your local hard drive and send that instead of the network drive version.

If saving locally isn't an option, post your code and say which line gives the error and the exact error message.

Hi, This is the script I'm using

Please Login or Register  to view this content.

I get the error from bat script as I'm trying to run it from UNC I can not run the script from local drive.