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")

Excel Visual Basic - Save (As) the document as the details in a cell
 

ThisWorkbook.SaveAs FileName:=Sheets("Details").Range("K2")

there should be a space between SaveAs and FileName

--
Regards,
Tom Ogilvy

"Stephen Pepper" wrote in message
om...
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")

Excel Visual Basic - Save (As) the document as the details in a cell
 

Thanks a mill Tom,

I had spent alot of time trying to resolve the issue before I posted in
on Google. I can't believe I was only missing a space.

Thanks agian,

Stephen


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!