Web Server Storing and Opening Workbooks

It is possible to save and open workbooks stored on a web server by using VBA statements. However, before you can store your workbooks on a web server, FrontPage Server Extensions must be running on the server. The following statement saves a workbook to a web site:

ActiveWorkbook.SaveAs "http://www.yojrWebSite.com/TestWkb.xls"

The following statement opens a workbook stored on a web site:

Workbooks.Open("http://www.yojrWebSite.com/TestWkb.xls")

0 0

Post a comment