Share sheet automatic on the internet.

  • Thread starter Thread starter test
  • Start date Start date
T

test

Hello,

I've got this spreadsheet where in I want one of the worksheets to be
visible on the internet.
This particular sheet is a sheet that shows the previous sheets making
use of the camera tool in Excel.

Is there a way to make Excel save and publish this sheet every time it
is updated? Can Excel do this by FTP?
There is no need to make it interactive.

I have a server where I can make a special user and a password for
this job.
Could this be done with a macro?

Thanks!!
 
I think there is an option AutoRepublish every time this workbook is
saved.
you need chekc this option.
 
Hello,

I've got this spreadsheet where in I want one of the worksheets to be
visible on the internet.
This particular sheet is a sheet that shows the previous sheets making
use of the camera tool in Excel.

Is there a way to make Excel save and publish this sheet every time it
is updated? Can Excel do this by FTP?
There is no need to make it interactive.

I have a server where I can make a special user and a password for
this job.
Could this be done with a macro?

Thanks!!
Click to expand...

In Excel 2003 you can publish the sheet (or part of one like print area) as a
web page. Use Save as Web Page. Then click the Publish button. It can be set to
auto publish when the sheet is saved.

I do this to a UNC path which is a share on the Web Site. I have never tried to
use FTP. You could run a batch FTP though to upload the local copy to the FTP
site every so often.

The macro suggested by Mudden will give cleaner HTML but may be harder to set
up.
 
Back
Top