Saving As Webpage

[Guest]

I posted a message on this topic several days ago in to the programming page and got no responces, I didn't know if this was a more appropriate area. I am using Excel 2003 and Windows XP. I know my way arond excel fairly well. What I don't know is Webpage or "html". What I am trying to figure out how to do is save a workbook that I created as a webpage, but I am having some problems with functionality

My workbook contains 14 worksheets. The first one is basically a menu (all other sheets are hidden except this one). On it I have buttons from the forms toolbar. Each of these runs macros that will display one or more of the other worksheets, and hide any sheet that is not needed at the time. On some of these other sheets I use combo boxes from the forms toolbar to open other workbooks that have data that the viewer needs to see. It will copy the data, paste it into the current workbook then close the one that the data was copied from. This way users don't really have access to the raw data files (and thus can't mess them up)

The issue is the data is updated every week or so, so I am having to make multipe copies of CD's to send out each week to anyone who needs this data (to many and too large of files to send via e-mail). I was wanting to try and save this main program as a webpage so that people could access it over the internet, and thus all the raw data files would only have to be maintained in one place (on our webserver)

When I try saving as a webpage, it comes up with the screen that looks right, but none of the buttons work, you can't even press them, thus you can't navigate through the workbook, and have all the macros do what they need to do. Is there anyway to make this work, or do I have to learn "html". I have searched google and microsoft help, and from all I can tell this should work, but it doesn't. I would appreciate any help on this that you can give me, and I appologize in advance for the length of the message, I just wanted to make sure whoever looked at it had all the details

Thank you for your time and consideration

Roland Hanson

 

[David McRitchie]

Hi Roland,
You are probably being misled by thinking you have one webpage entity.

Say you have a worksheet named mySheet,
you will generate a webpage mySheet.htm
but you will also generate an entire directory named mySheet
that also has to be copied.

If you are talking about an interactive web page there are features that
are not available.
help, answer wizard, interactive features, troubleshoot ...

I posted a message on this topic several days ago in to the programming page and got no responces, I didn't know if this was a

more appropriate area. I am using Excel 2003 and Windows XP. I know my way arond excel fairly well. What I don't know is Webpage
or "html". What I am trying to figure out how to do is save a workbook that I created as a webpage, but I am having some problems
with functionality.

My workbook contains 14 worksheets. The first one is basically a menu (all other sheets are hidden except this one). On it I

have buttons from the forms toolbar. Each of these runs macros that will display one or more of the other worksheets, and hide any
sheet that is not needed at the time. On some of these other sheets I use combo boxes from the forms toolbar to open other
workbooks that have data that the viewer needs to see. It will copy the data, paste it into the current workbook then close the one
that the data was copied from. This way users don't really have access to the raw data files (and thus can't mess them up).

The issue is the data is updated every week or so, so I am having to make multipe copies of CD's to send out each week to anyone

who needs this data (to many and too large of files to send via e-mail). I was wanting to try and save this main program as a
webpage so that people could access it over the internet, and thus all the raw data files would only have to be maintained in one
place (on our webserver).

When I try saving as a webpage, it comes up with the screen that looks right, but none of the buttons work, you can't even press

them, thus you can't navigate through the workbook, and have all the macros do what they need to do. Is there anyway to make this
work, or do I have to learn "html". I have searched google and microsoft help, and from all I can tell this should work, but it
doesn't. I would appreciate any help on this that you can give me, and I appologize in advance for the length of the message, I
just wanted to make sure whoever looked at it had all the details.

 

[Guest]

Ok, I looked at what you said and I see the file that is created with all the other information. As for most of the features you mentioned, I don't think they will be a problem, they really won't need to be used. People just have to hit the buttons to navigate, actually I have used macros to remove all the toolbars and command bar, all sheet tabs are also removed, so they really can't do anything but hit the buttons.

Now I have tried looking at the folder and all the information it is creating, and it shows 14 sheets but when I open those they are all the same as the main one, I don't know if this is because they are all hidden to start with but the main program one. The real issue though is that even without putting this information on a server or trying to veiw it over the web, just opening the "html" file that is created right on my computer, the buttons still won't work. Do I need to use the buttons from the "Command Toolbar" - right now I use the ones from the "Forms Toolbar"? I guess in general I still just don't uderstand why it won't work. The buttons run the macros that do everything, but I just can't press them.

Any other advice on this would be helpful, this is just a new area of excel for me, and so far none of the normal resources seem to answer my questions.

Thanks for your time and effort on this question.

Roland Hanson