View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mowen[_2_] mowen[_2_] is offline
external usenet poster
 
Posts: 1
Default Publish Excel sheets automaticly!

Hi

Can some one help me with VBA coding?

My scenario in text form a

I have two spesific sheets in a excel workbook with 30 sheet ,that
want to publish at my web page automaticly when some spesific cells ge
a new value.

Update when B4 to B16 or D6 to D16 get a new value or every 5 minutes.

Sheet name: Kampresultat and resultatliste.

source excel workbook: D:/...../myfolder/Emkonk1.0

Then these two sheets have to be saved in a html format
at D:/...../mywebs/Kampresultat.html an
D:/...../mywebs/resultatliste.html.

Then I want to publish these two html files to my web page.
Since these two files will replace already existed files at my we
pages, I have to consider that the update files should replace th
existing files.

Need more information to help me or...

best regards
Run

--
Message posted from http://www.ExcelForum.com