vb code to save a spreadsheet to file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm stuck....I have one spreadsheet in which there is a form which get
completed by other users. What I would like to do is be able to save this
sheet to a different file using the date to file it under. Also as read only.
Many thanks.
 
ASU,
Did you look at the .SaveAs method ?
MyWB.SaveAs Format(Now(),"YYYYMMDD")

regarding Read Only, use SetAttr.

NickHK
 

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

VB Error in spreadsheet with no VBA code 2
Excel using VB - save problem 6
VB Code to Auto Save Multiple Files 0
2007 VB Controls Backwards Compatibility 4
How do I find what is in a spreadsheet 4
Combine two spreadsheets into one 3
Saving a spreadsheet from .Net Web Forms application under Vista 4
retrieve data into a spreadsheet from a copy of that spreadsheetwhich is saved as its own xls file 10

Back
Top