Loop, Save Print Area as Published Webpage to Folder

I'm a noob at Excel VBA and need serious help on a simple code. I have a drop down list created with data validation. When I select an item on the list, there are charts and data on the same worksheet with the list which update as a result. The drop down list has 200+ items and I need to be able to type up a separate list that starts in say A50. If the separate list is say 15 items long, I need the code to loop through the separate list, copy the item and paste it in the cell with data validation list so that the charts update. Once that happens, I would like the macro to publish the print area that I set, which has the updated charts, as a webpage and then save it in a folder on my hard drive with the name of the file having the same name as the current item on the separate list that the loop macro is being applied to. I have some of the code completed but I receive an error on the part of the code that saves.

Please Login or Register  to view this content.

Bump...anyone

Actually I have an updated code...the only thing I need is for this command to loop and apply the macro to each cell down the list which starts in Cell A1 of the "List" worksheet and when it saves...to save the file with the name of the cell that the macro is currently being applied to at the moment...Please help

Please Login or Register  to view this content.