Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel: Automatically Saving as Web Page


  • Please log in to reply

#1
Danimagus

Danimagus

    Member

  • Member
  • PipPip
  • 29 posts
Hello all--Judging by the subject headings I see in this forum, I can tell that my problem is a relatively simple one. Well, hopefully, anyway.

I suppose I ought to simply say what I'd like to have Excel do and perhaps some of you could tell me how that might be accomplished.

Currently, I've successfully created a network of spreadsheets, where the value of one cell is pulled and copied into another cell in another spreadsheet (that value is then used to create a graph). The goal is to export that spreadsheet (the one containing the pulled value and resulting graph) as an html document, and to have this happen automatically.

So far, I've created a macro that saves any number of spreadsheets to html whenever it's run, but this isn't quite good enough. I'd like to have this document save as html automatically, whenever there is a change to one of the source spreadsheets (the ones from which cells are copied).

Does anyone know how this might be done?
  • 0

Advertisements


#2
Danimagus

Danimagus

    Member

  • Topic Starter
  • Member
  • PipPip
  • 29 posts
I've managed to get the files to save as html after either a certain amount of time or at a certain time. Now, immensely awesome a feat as this is, I'd still like to create a macro that causes files to be saved as html whenever they're changed and saved in the conventional sense. Suggestions?
  • 0

#3
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
what do u mean

after u type something in ?

w8 do u get the data from somewhere esle?
  • 0

#4
Danimagus

Danimagus

    Member

  • Topic Starter
  • Member
  • PipPip
  • 29 posts
What I've got going is a couple of interconnected spreadsheets. The one I'm working on updates a couple cells to match corresponding ones from another, separate spreadsheet. This works just fine--I'd like to create a macro that causes *my* spreadsheet to save as HTML whenever someone makes a change and saves one of those other worksheets mine's connected to. Make sense?
  • 0

#5
stu_design

stu_design

    Member

  • Member
  • PipPipPip
  • 217 posts
theres vb code that allows for the workbook to detect a cell change

Stu Design

take alook in built in vb editor and select Thisworkbook


click the second combo box and select SheetChange

you should see this

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

hope thats a little help

Stu Design

End Sub
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP