| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving as Web Page
Hi! Is there a code that will "Save as Web Page", the print area of the currently active worksheet and give it a file name based on referencing a cell within the currently active worksheet? I've been searching for this for some time and cannot seem to find anything. Perhaps I'm just looking in the wrong place! Thanks for any help or advise! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=531945 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving as Web Page
Dim rng as Range
set rng = Activesheet.Names("Print_Area") activesheet.copy activesheet.clearcontents rng.copy Activesheet.Range(rng.Address).Paste activeworkbook.SaveAs "C:\Myfolder\ & rng.parent.Range("B9").text & .html", xlHtml might get you started. -- Regards, Tom Ogilvy "Brian Matlack" wrote: Hi! Is there a code that will "Save as Web Page", the print area of the currently active worksheet and give it a file name based on referencing a cell within the currently active worksheet? I've been searching for this for some time and cannot seem to find anything. Perhaps I'm just looking in the wrong place! Thanks for any help or advise! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=531945 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Saving as Web Page
Thanks Tom!! -- Brian Matlack ------------------------------------------------------------------------ Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508 View this thread: http://www.excelforum.com/showthread...hreadid=531945 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Excel 2010 files as web page or single file web page | Excel Discussion (Misc queries) | |||
| Page Setup when saving a worksheet as a web page | Excel Discussion (Misc queries) | |||
| Excel saving as web page and scaling the print out to fit one page | Excel Discussion (Misc queries) | |||
| Saving as a web page | Excel Worksheet Functions | |||
| saving page | Excel Worksheet Functions | |||
![Brian Matlack[_65_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
