ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can this work and if so how? (https://www.excelbanter.com/excel-programming/385547-can-work-if-so-how.html)

Jason Zischke

Can this work and if so how?
 
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

[email protected]

Can this work and if so how?
 
On Mar 18, 10:54 pm, Jason Zischke
wrote:
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



All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com