Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell entries then save and overwrite template
I'd like to be able to delete the entries in certain cells, then sav
the file as a template (overwriting an existing template), that wa some information I have entered will be saved in the template whil other information is removed. How would I go about doing this -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell entries then save and overwrite template
Open the workbook you want to use, make the changes, do File = Save As,
specify the name of the old template and specify file type in the dropdown as .xlt. -- Regards, Tom Ogilvy "RPIJG " wrote in message ... I'd like to be able to delete the entries in certain cells, then save the file as a template (overwriting an existing template), that way some information I have entered will be saved in the template while other information is removed. How would I go about doing this? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell entries then save and overwrite template
ok, that answers my question but I didn't qualify my question wel
enough, I'd like to do this programmatically, sorry -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell entries then save and overwrite template
sPath = "C:\Myfiles\"
ActiveWorkbook.Saveas Filename:=sPath & _ "MyOldTemplate.xlt", FileFormat:=xltemplate -- Regards, Tom Ogilvy "RPIJG " wrote in message ... ok, that answers my question but I didn't qualify my question well enough, I'd like to do this programmatically, sorry. --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell entries then save and overwrite template
and for deleting cell contents, I was using this
Code ------------------- Range("D13:H13").Select Selction.ClearContent ------------------- that I captured using the macro recorder, but I get an error sayin object required or something of the like -- Message posted from http://www.ExcelForum.com |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Cell entries then save and overwrite template
for your existing code, Selection is misspelled
you could just do Range("D13:H13").Clearcontents -- Regards, Tom Ogilvy "RPIJG " wrote in message ... and for deleting cell contents, I was using this Code: -------------------- Range("D13:H13").Select Selction.ClearContents -------------------- that I captured using the macro recorder, but I get an error saying object required or something of the like. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
locating and deleting duplicate cell entries | Excel Discussion (Misc queries) | |||
Save As / Overwrite | Excel Discussion (Misc queries) | |||
How to save a file without overwrite or save a copy? | Setting up and Configuration of Excel | |||
Save .csv with overwrite | Excel Programming | |||
Save As without overwrite prompt | Excel Programming |