Writing a macro to save worksheet

G

Guest

I am currently looking for a way to prompt users to save a copy of a
worksheet into a location of their choosing (same as doing "FIle", "Save
As"). This is what i have so far:

Sub Copy_Save_OneDay_Sheet()
'
' Copy_Save_OneDay_Sheet Macro
' Macro recorded 11/17/2006 by ISD
'
'
Sheets("Roster(1 Day)").Select
Sheets("Roster(1 Day)").Copy

End Sub

Can someone help? Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Break links 1
Loop to copy paste rows base on table arrays 0
Macro to Copy hidden worksheet to new worksheet 4
Macro for all Excel Workbooks to print to PDF 2
Saving worksheet as a text file 7
Writing Macro in Excel 2002 7
Macro Related to Paste Values 2
Grouping a range of sheets 10

Top