View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen Pepper Stephen Pepper is offline
external usenet poster
 
Posts: 1
Default Excel Visual Basic - Save (As) the document as the details in a cell

I am publishing an Excel form on a webpage that is set-up to return to
an email address and would like the workbook to Save As the
information in a particular cell.

I have tried variations of the following with no luck. Can anyone
help please.

ThisWorkbook.SaveAsFileName:=Sheets("Details").Ran ge("K2")