How can I save to a server?

[Kenji]

I want to upload my excel sheet to a server

I'm trying to do a

thisworkbook.saveas(http://whatever.com/upload/sheet.xls)

but it does not work. Gives me an 1004 error. Anyone know what I can do?

Kenji

 

[Jim Gordon MVP]

Hi Kenji,

You need to use an FTP program or MacOSX to move the saved file from a saved
location on your computer.

If you mount the save location as a drive on your desktop then you can
navigate using MacOSX to the proper file location and save directly.

 

[Kenji]

Thanks Jim,
I'm currently looking up on Macscript.

----
tell application "Finder"
if not (exists "VOLUME_NAME") then
mount volume "CONNECTION" as _
user name "USER_NAME" with password "PASSWORD"
end if
end tell

 

[Kenji]

The mount method worked beautifully. Thanks Jim!

Kenji

 

[Kenji]

Hi,
I am currently mounting the server, saving onto it, and unmounting the
server.

On the server log.. I saw that the Mac is lookfor a msxml.dll on the
server... and continuously tries to look for it. I inserted the msxml.dll
from a windows machine and the mac found it and does a "GET", however..
continues to look for the msxml.dll.

It's very annoying and slows down the system.. to the point it's useless.

Anyway around this? Thanks!

Kenji

 

[Bob Greenblatt]

Hi,
I am currently mounting the server, saving onto it, and unmounting the
server.

On the server log.. I saw that the Mac is lookfor a msxml.dll on the
server... and continuously tries to look for it. I inserted the msxml.dll
from a windows machine and the mac found it and does a "GET", however..
continues to look for the msxml.dll.

It's very annoying and slows down the system.. to the point it's useless.

Anyway around this? Thanks!

Kenji

Macs do not use DLLs. If you workbook is looking for one, there is probably
some hardcoded VBA left over from the PC implementation that has not been
converted properly, or a VB reference has been left in the file. I
frequently and without any problems save files, via VBA, to mounted windows
servers.