Results 1 to 10 of 10

SaveAs

Threaded View

  1. #1
    Registered User
    Join Date
    06-04-2009
    Location
    australia
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    15

    SaveAs

    Hi, i am trying to save a range on Sheet1 as a web page. i have managed to save the entire workbook as a webpage but am struggling to get the right syntax for just the range on sheet1. when i do this manually i select the range, set the print area, then choose file-save as web page- and choose selection:print area or republish if i have done this before. i am not sure also where to add the directory i wish to save it to. the file name always changes, so i can either: use the name of the file or i can use the same file name that is entered into a cell (cell never changes). i hope this makes some sort of sense. here is the code i used to save the entire workbook

    myName = This Workbook.Fullname
    myHtmlName = Left(myName,Len(myName)-4)&".htm"
    ThisWorkbook.SaveAs Filename:=myHtmlName:=,FileFormat:=xlHtml
    thanks for any help
    Last edited by slipperyjim; 06-04-2009 at 11:06 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1