File Save As Using Macro
 

I need to save a file that is being imported by Access. The cell
referenced below is a concatenated cell pulling the data together to
form the file name. What else do I need to add to my code to make this
work?

ActiveWorkbook.SaveAs Filename:=Range("F32").Value

Thanks!
Shelley


--
sesmith
------------------------------------------------------------------------
sesmith's Profile: http://www.excelforum.com/member.php...o&userid=24765
View this thread: http://www.excelforum.com/showthread...hreadid=383320

File Save As Using Macro
 

I would precede it with Application.DisplayAlerts = False so a file exists
warning will not stop the macro.

--
Jim
"sesmith" wrote in
message ...

I need to save a file that is being imported by Access. The cell
referenced below is a concatenated cell pulling the data together to
form the file name. What else do I need to add to my code to make this
work?

ActiveWorkbook.SaveAs Filename:=Range("F32").Value

Thanks!
Shelley


--
sesmith
------------------------------------------------------------------------
sesmith's Profile:
http://www.excelforum.com/member.php...o&userid=24765
View this thread: http://www.excelforum.com/showthread...hreadid=383320