Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Personal Information (Author etc)
I want to create a servey form which will record certain information.
But when i save excel doument it should not save any personal data so that no one would know who created the document. Is there a Macro code which will acheive saving the document without any personal information. Thanks in advance, Shashi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Personal Information (Author etc)
You are looking to remove the meta data and there is lots of different meta
data stored. Exactly what do you want to delete. There is different code for each peice of data, and some of the data can not be removed via VBA. If you want to remove all of it there a a bunch of off the shelf programs to do it for you. Here is a link... http://support.microsoft.com/?kbid=223789 "Shashi Bhosale" wrote: I want to create a servey form which will record certain information. But when i save excel doument it should not save any personal data so that no one would know who created the document. Is there a Macro code which will acheive saving the document without any personal information. Thanks in advance, Shashi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Personal Information (Author etc)
Found this article recently. It links to a Microsoft
utility that saves the Excel file without metadata. However, I believe this would have to be installed on everyone's machine and used when they save it. I would like a VB script that does the same thing, so that it would ride with the spreadsheet, but I haven't found one yet. http://blogs.ittoolbox.com/bi/spread...rchives/001195. asp Don -----Original Message----- You are looking to remove the meta data and there is lots of different meta data stored. Exactly what do you want to delete. There is different code for each peice of data, and some of the data can not be removed via VBA. If you want to remove all of it there a a bunch of off the shelf programs to do it for you. Here is a link... http://support.microsoft.com/?kbid=223789 "Shashi Bhosale" wrote: I want to create a servey form which will record certain information. But when i save excel doument it should not save any personal data so that no one would know who created the document. Is there a Macro code which will acheive saving the document without any personal information. Thanks in advance, Shashi . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing unneeded information | New Users to Excel | |||
display previously hidden author information in excel 2003 | Excel Discussion (Misc queries) | |||
Excel: protect author information | Setting up and Configuration of Excel | |||
Illinois Personal Information Protection Act | Excel Worksheet Functions |