| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet as file
Hi!
First, I have a .xls file (AAA.xls) with a single (base) worksheet ("Baza") - content of one cell (B1) is "0001". I want to copy this worksheet (because I want to save data unchanged in base worksheet) and run macro (etc."xxx") who will take some changes, save this "changed" worksheet as a ..xls file in format "Name0001.xls" and erase that "changed" worksheet. For next time when I'll open AAA.xls cell (B1) must grow for one number (0002) and next saved file must have this number "Name0002.xls" and so on... Any suggestions? C3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set up a worksheet name as file name | Excel Discussion (Misc queries) | |||
| Worksheet to new file | Excel Discussion (Misc queries) | |||
| copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
| Saving worksheet in new file with date AND cell value as file name | Excel Discussion (Misc queries) | |||
| open file dialog-select file-import worksheet | Excel Programming | |||
Threaded Mode
