How Do I Upload a File Through VBA?

[Kenji]

Is there a way to do this?

Kenji

 

[Jim Gordon MVP]

Hi

If you mean using FTP then you can use VBA to call an AppleScript that could
use an FTP program such as Fetch or Transmit.

VBA calls AppleScript "MacScript" in the help file. You'll find code
examples there and by searching in Google groups.

-Jim Gordon
Mac MVP

All responses should be made to this newsgroup within the same thread.
Thanks.

About Microsoft MVPs:
http://www.mvps.org/

Before posting a "new" topic please be sure to search Google Groups to see
if your question has already been answered.

 

[Kenji]

Jim,
my server is setup so I can post files to the server too.
Followhyperlink seems to not work on strings over 1000 characters, do you
know another way to "post"? Thanks!

 

[Jim Gordon MVP]

Hi again,

Based upon a quick look at the results of this search
<http://groups.google.com/groups?q=post+method+limit&ie=ISO-8859-1&hl=en&btn
G=Google+Search> it seems to me that POST is not generally reliable with
1000 or more characters regardless of the program you are using. The limit
could be with either end of the transaction.

If you are trying to upload data tables consider ODBC or XML options.

-Jim

 

[Jim Gordon MVP]

Hi Kenji,

Today I received confirmation of your observation from Microsoft. The number
of characters that can be used in the VBA command is limited to 1,024.

Did you try assigning the characters to a string variable?

-Jim