Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created a very simple code that right now runs through a
list of references, pulls the relevant information into our template (ie, calculate) and prints. I need to revise (overhaul) the code so that it does a similar task but now saves each calcualtion as a web page named for the reference and the date it was exported. Can someone please help me get a shell going? Thanks, ko (my uber-simple code is below, it won't help probably) Sub PRINT_ALL() For Each c In Range("List4") Range("A3").Value = c.Value Calculate ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Next c End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
export sheets to multiple new files | Excel Discussion (Misc queries) | |||
export multiple sheets to multiple excel files | Excel Discussion (Misc queries) | |||
Does anyone have any good references for making excel sheets into webpages? | Excel Discussion (Misc queries) | |||
Export multiple sheets to 1 csv file. | Excel Programming | |||
multiple calcualtion | Excel Programming |