SaveAs
Posted by mike on January 30, 2002 8:00 AM
What is the VBA syntax to save an individual sheet in a workbook as another file as values without links to the original file. (so I can e-mail).
Any idea's on this one?
Posted by Juan Pablo G. on January 30, 2002 8:09 AM
Try with
ActiveSheet.Copy
Cells.Copy
Cells.PasteSpecial xlValues
Application.CutCopyMode = False
Range("A1").Select
Juan Pablo G.
Posted by sonja on April 25, 2002 12:03 PM
Custom fill series format...
After I use the custom fill series to fill linking data, I can't change the date format in the column that I just filled. Please help!!
