Hello,

Here is a code that I've recorded to copy a cell, open a new workbook, then paste the data.

Sub test3()
'
' test3 Macro
' Macro recorded 5/16/2005 by Marlon Elmore
'
Range("F5").Select
Selection.Copy
Workbooks.Add
Range("B3").Select
ActiveSheet.Paste
Range("B1").Select
End Sub

After hitting a macro button, I want a box to pop up, to enter a date. This date should be assigned to a new workbook as the file name. Then copy, paste the new information into the new workbook.

My hangup is how to code a as "Save As Box" that pops up and assign name to a new workbook.

This might be a though one;
Thanks,
EMoe