Software

Ask something
Discussion Locked

Changing file name in Properties in Excel

0 helpful
4 replies

by techstar2011

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I open a file in Excel or Word, and click properties, under "location" my personal name seems to be after c:\documents and setting\Norman\MyDocuments
I need to take out the name Norman or change the existing files and all files that are made to another name.

How do I do this in Excel?
When I am sending documents to people and if they click properties, they can see the name.

In word when I click, tools, options and click file locations, it says my name in there too under locations which is highlighted. If I click the modify button it just brings up the box for accessing all my documents.

4 replies

by chitosunday

You know vba? put this in a code module then
change the name "meyeeh" to what you want

Sub changeauthor()
ActiveWorkbook.BuiltinDocumentProperties("Author") = "MeYeeH"
End Sub

by link999

The "Location" setting in Excel tells you were you currently have the file saved on your hard drive. When you send the file to someone else, the "Location" setting will change to wherever they save the file.

For example, I just created a test Excel spreadsheet and saved it in C:\Temp. I reopened it and checked the "Location" setting, and it was C:\Temp. Next, I sent the test file to another user on our network. He saved it to C:\Download. When he opened the spreadsheet the "Location" setting said C:\Download.

I hope this helps.

by ayuknotna

try this...

... click on TOOLS
... scroll down to OPTIONS
... then navigate to GENERAL tabs
... go down to user name and change it

This discussion is closed to new replies.