is there anyway wer i can create a macro that automatically uses the save as function and saves the file in the name of a particular cell??
this is because i have created a format wer i enter the scores and after the end of the contest i want the scores to be saved but not on the original file.
Yes its possible. Do you want this to be done for several cells or just once?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
no just one cell.
can yu pls help me as to how to do it..
Have you considered saving your "original" workbook as a template?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
i do not know how to do that, ive never done anything like this before, its my first attempt with macros and im fairly new to excel
how do i save it as a template??
This isn't macros. it a normal feature of Excel.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks