Can this work and if so how?

[Guest]

Hi All

I have a program that is made up of a few .xls files and I have been asked
to try and get it to work over the internet. The files have quite a bit of
vba code so it needs to stay a .xls file. Is this possible?

Thanks in advance

Jason

 

[Shaka215]

Hi All

I have a program that is made up of a few .xls files and I have been asked
to try and get it to work over the internet. The files have quite a bit of
vba code so it needs to stay a .xls file. Is this possible?

Thanks in advance

Jason

Look into using using scriptbased FTP application that can be executed
in DOS to execute a particular command...then use SHELL (DOS) to load
the program with the default script tied in with the program. I've
gotten this work several times but it's extremely complex to try and
explain it. Basically you will need to have Excel run VB script to
upload/download from an FTP server (using the scriptbased FTP
application). Hope that helps you out.

-Todd