Thursday, September 29, 2016

Display Excel properties in spreadsheets [Solved]

Display Excel properties in spreadsheets

In Excel 2003, click File > Properties > Summary, you can see such properties as Title, Subject, Author, Manager, Company, etc.

How to display these properties in spreadsheets? For example, I want to A1 to display the Title, A2 to display the Subject, A3 to display the Author.
And if I change the file properties, each time I open the file, the properties displayed in the spreadsheets
will also be updated automatically.

How to achieve it?

Solutions to the Problem Display Excel properties in spreadsheets

Download SmartPCFixer to Fix It (Free)

Open the VBA Editor (Alt/F11)
Double click ThisWorkbook in the project explorer in the left column.
Copy and paste the following code into the blank area of the VBA editor on the right.
Note the comment to edit to your worksheet name.
Close the VBA Editor (Cross with red background top right.)
Save the workbook.
Open the workbook and see if it works.
(Updates each time the workbook is opened)
 
Private Sub Workbook_Open()
  With Sheets("Sheet1") 'Edit to your sheet name
    .Range("A1") = ThisWorkbook.BuiltinDocumentProperties("Title")
    .Range("A2") = ThisWorkbook.BuiltinDocumentProperties("Subject")
    .Range("A3") = ThisWorkbook.BuiltinDocumentProperties("Author")
  End With
End Sub
To find all of the available properties if more are required, Insert a standard module.
(With VBA editor open select menu item Insert -> Module.)
Copy the following code into the standard module.
Note where you need to edit to insert your required sheet name for the list.
(Suggest you use an empty sheet).
Run the code from the VBA editor.
(Click any where within the sub and then press F5 to run)
Check out the worksheet for the list of available properties.
 
Sub AllProperties()
  'Will display the list of available workbook properties
  Dim docProp As DocumentProperty
  Dim lngRow As Long
  lngRow = 1
  With Worksheets("Sheet3") 'Edit to required sheet name
    For Each docProp In ActiveWorkbook.BuiltinDocumentProperties
        .Cells(lngRow, 1).Value = docProp.Name
        lngRow = lngRow + 1
    Next
    .Columns("A:A").Columns.AutoFit
  End With
End Sub
 
The following added after original post.
A UDF (User Defined Function) could have been used in lieu of the code in ThisWorkbook but I am not sure how knowledgeable you are with Excel and VBA so have kept it simple for the moment.
If you want to use a UDF then feel free to get back to me for more
help if you need it.

  1. Access the files on your computer via MY COMPUTER
  2. Under the C: drive, access the WINDOWS folder
  3. Select the SOFTWARE DISTRIBUTION folder, followed by the DOWNLOAD folder.
  4. Delete any files within this download folder.
  5. If you are unable to delete these files, open the command prompt (CMD) as the administrator, and type "net stop wuauserv" into the CMD prompt window. Press ENTER. This should allow you to delete the files from step 4.
  6. Once the files are deleted, open and run the CMD as the administrator and type "wuauclt.exe /updatenow". Press ENTER.

Another Safe way to Repair the Problem: Display Excel properties in spreadsheets:

How to Fix Display Excel properties in spreadsheets with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Run it, and it will scan your computer. The errors will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Way to Update & Download SONY SVE14A2X1EH Wireless State Device driver,How to Update & Download SONY SVS1511X9RB Graphics Driver for D2 (Intel) v.9.17 - 9.17.10.2828,Method to Download SONY VGN-CR290N Realtek High Definition Audio Driver v.5.10.0.5433,Download SONY VGN-FS710/W Utilities DLL Update v.6.4.0.06290 driver,Method to Update & Download SONY VGN-NR460E/P Intel Graphics Media Accelerator Driver v.6.14.10.4847,How to Fix Error 0x0000c1f5 SoluciĆ³n?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error,Solution to ashoutxt.dll Missing Error,Solution to cxcore096.dll Missing Error,Where can I Find dsauth.dll File,How to Fix msde.dll Not Found Error,Best Method to Fix psizewizres.dll Error
Read More: Troubleshoot:Download problems: Updates for MS.NET Framework 4 ...(KB2604121) won't install (error Code 66A) and an unavailable network resource problem when downloading. PLEASE HELP!! Error,Dispositivo de impresoras red,como conectar. [Solved],[Solved] Do not see \"share this connection\" button in the network description,does Linksys Wireless-N Home ADSL2 Modem WAG160N Wireless Router work with Windows 7 homegroup [Solved],How to Fix - DO SEARCHES HOME PAGE IN BROWSER wont go....?,Data validation question. Maintaining and updating named ranges.,Desktop Gadget Gallery on Windows 7,delete empty rows,Deleting a page and also how can I copy an exact page lay out on a new page,Date Formula for 1st Sunday of each Month (3rd to 9th)

No comments:

Post a Comment