Dynamic Filename From Macro
I am trying to save a spreadsheet that is created by a macro. The
name that I want to use for this sheet is parsed from a cell so it appears as a formula in the cell. I have tried to use the cell value as the filename when executing the Save As feature in the Macro, but can't seem to get the value to be used. Am I missing something obvious? I thought that I had it working once but couldn't reproduce the steps. thanks again in advance! craig. |
Dynamic Filename From Macro
Craig
What do you have? ActiveWorkbook.SaveAs Filename:=Range("a1").Value -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Craig" wrote in message om... I am trying to save a spreadsheet that is created by a macro. The name that I want to use for this sheet is parsed from a cell so it appears as a formula in the cell. I have tried to use the cell value as the filename when executing the Save As feature in the Macro, but can't seem to get the value to be used. Am I missing something obvious? I thought that I had it working once but couldn't reproduce the steps. thanks again in advance! craig. |
All times are GMT +1. The time now is 03:41 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com