Multi-program macro/VB/VBA

[Guest]

I would like to build a macro or something that will automate a process for
the data entry people, but every time I try to record a macro, Excel tells me
it can't. This deals with 2 different MS products, but I can't even get Excel
to do it's part and I'm no good at the VB stuff on my best day. This one is
not difficult, but it's not easy either as it has multiple parts.

What I would like this macro to do is (1) format the data - center all, (2)
remove unused cells, (3)select & set the print area, (4) save the file as an
..xls spreadsheet, (5) save it again as a static web page, (6) save it again
as an interactive web page, (7) open Front Page, (8) open 2 .htm files in
code view, (9) open the 2 Excel web page files in code view, (10) select a
range of code in one of the Excel pages, (11) copy the range, (12) paste it
into one of the .htm pages, (13) repeat the process for the other page, (14)
save both files, (15) preview the saved pages, (16) close the 2 Excel web
pages, (17) publish the 2 saved .htm pages.

Any suggestions and/or help would be greatly appreciated.

 

[Guest]

How high is your security set? Select from your menu in Excel
Tools/Macro/Security. Your security should probably be set to medium which
will require you to tell Excel you want to enable macros anytime you open
Excel. You do not want it set to high unless you have no need to execute a
macro.

Hope that helps!

Kevin