Adding Author To Indexing File
Jul 2, 2014
I'm trying to get a document together that will spit out an index of all the files in a folder/subfolder with various attributes like title name/ hyperlink to the file/ type/ etc. How to add a function that will create a column/pull data for the author of the files I am indexing.
Code:
Public fPath As String
Public IsSubFolder As Boolean
Public iRow As Long
Public FSO As Scripting.FileSystemObject
Public SourceFolder As Scripting.folder, SubFolder As Scripting.folder
Public FileItem As Scripting.File
Public IsFileTypeExists As Boolean
[Code] ...........
How to get a column that lists the author of the document.
View 2 Replies
ADVERTISEMENT
Jul 2, 2014
I'm trying to get a document together that will spit out an index of all the files in a folder/subfolder with various attributes like title name/ hyperlink to the file/ type/ etc. How to add a function that will create a column/pull data for the author of the files I am indexing.
[Code] .....
Here's the website: [URL] .....
How to get a column that lists the author of the document.
View 3 Replies
View Related
Mar 20, 2007
I have around 1000 files in a folder saved by different users at my company. I would like to be able to examine each file using VBA and write to a spreadsheet the username of the person who created and / or last saved that file. I can't find any reference online or in VBA help about this,
View 9 Replies
View Related
Jul 3, 2013
I have some password protected excel worksheets that required editing as they are from earlier versions, an earlier time and all need to be updated. This would be fine if it was myself who actually made the worksheets, but the person who did retired a couple of years ago and has dropped off the map (no contact details etc).
I know how to remove passwords, when I was the one who set them. The big problem here is, they are all macro enabled and for some reason the free down load password removal applications do not unlock worksheets that are macro enabled.
View 1 Replies
View Related
May 25, 2013
can we change the author of shared excel and will this allow the changed author to make changes in no. of days to track history
View 6 Replies
View Related
Apr 3, 2014
I have the following code which successfully opens the specified workbook and copies the values to the active workbook, but then gives an error on the line of extracting filename, and when extracting last author. However, the code works fine if I use 'getopenfilename'.
[Code]......
View 8 Replies
View Related
Oct 31, 2013
I have a PO Template which I wish auto insert below information in the footer.
a) User Name
b) Create date
c) Last modify user
d) Last modify date
e) Print date
f) No of pages (Say Page: 1 of 3)
When the PO is issued, the softcopy will be saved in a Server.
In certain circumstance, the existing PO will required to be revised. Most cases, it might not be the same user who created this.
For tracking on identity, I wish the last modify user, date and print date to be captured and printed in the footer note?
Whether I can lock the footer information as well? So that all user will not be able to edit these information?
View 2 Replies
View Related
Sep 13, 2009
It is possible to lock the Author of the Worksheet in File --> Properties --> Summary Tab..?
I am using Excel 2003 & 2007..
View 8 Replies
View Related
Dec 30, 2013
I am a lacrosse coach and am keeping track of key stats that our team values that cannot be found in the box score (ex: 'Secondary Assists'). To do this we have created a group of rather simple Excel spreadsheets to keep track of these. We have one master file will all the total data from the season and 10 or so secondary files for each game that we played. To this point, I have been adding the data from the different game files to the master file manually and it is very time consuming.
My question, is it possible to copy a row of data from one of the secondary files and have excel add that data to the existing data in the master file?
View 2 Replies
View Related
Sep 22, 2009
find a row containing text. Like when opening a PDF file with Excel, all the pdf code is in column A. I would like to create a formula that would search column A for the text "Example" and have the row number be the result.
I've tried using index, match, find, search, etc.. and nothing seems to work.
View 5 Replies
View Related
Oct 22, 2007
I have to find the maximum value of a column (J16:J115) and refer to the name in column A corresponding with the number found... everything works perfectly with :
=INDEX(A16:A115;MATCH(LARGE(J16:J115;1);J16:J115;0))
But when there are two maximum values it only gives me the first one... is there a way I can get both (or more) names in different cells ?
View 9 Replies
View Related
Jan 6, 2010
In the attached file the
„«All the data is available in the details sheet
„«Input field is B20.
„«There are 6 Rate Schemes. All the input fields are present in all
„«Again there are 3 Subline of Business
Need .. when I put a input field and select a C15 and C17 the Exposure Curve, Flexa, Other should get displayed.
Hope I made the scenario understandable.
View 2 Replies
View Related
Dec 9, 2008
I want to combine & I may be dense, but I just haven't gotten the hang of building multiple functions yet, especially when it comes to knowing when to add zeros & ones, for the index & match functions, as an example.
indexing a range from another spreadsheet, but when I tried to use it again on a different range & copied & pasted and changed the ranges, I get #REF!, which I know means I screwed something up, I'm just not sure what & I don't know what the 1's & 0's mean.
=INDEX(RiskLevel,MATCH(1,INDEX(FREQUENCY(E5,RiskScore),0),0))
View 7 Replies
View Related
Jun 3, 2009
I have two worksheets that are formatted differently. One has a list of employees and the other has the same list of employees but with associated employee IDs. I need to pull the employee IDs to the other sheet.
Let's call the two worksheets A and B. On Worksheet A (the one I'm working with), here's the format (column A):
Employee Name
Doe, Jane
Doe, John
Roberts, George
In worksheet B, here's the format (column A | B | C):
Last Name | First Name | Employee ID
Doe | Jane | 1105
Doe | John | 1106
Roberts | George | 1107................
View 9 Replies
View Related
Aug 22, 2006
In the attached sheet, I'm trying to get excel to return the top 5 values in an array, based on the preceding cell. This example is for a Football League, in which the QBs, RBs and WRs all have different salaries. The objective is to return the salaries of the top 5 paid people in each. Don't need to return the name, just the salary amount, so that an average can then be taken to figure future salaries.
View 5 Replies
View Related
Feb 23, 2014
I am trying to create a form where my staff can use a drop down box to select their role on the drop down bar on the "Template" tab- M12 (highlighted orange) that can reference to same role on "sheet 2" and show the corresponding data in column C, highlighted in green. The output of the formula starts on "Template!23" - highlighted in yellow. I have started to use an array formula but cannot fully utilise it as I need the row reference needs to be variable. Is it possible to use multiple "ifs" to account for the changing inputs on the drop down bar? What do you think? <attached>
View 5 Replies
View Related
Nov 11, 2009
I am trying to index and match information and trying to show the multiple values that go with it. Then I am trying to do the same with vlookup.
View 4 Replies
View Related
Nov 2, 2013
indexing complete data sets for each entered value. see example to better understand what I am trying to do. I have been trying for weeks.
Steve
INDEX.xlsx
View 14 Replies
View Related
Dec 10, 2009
I'm trying to improve a code that Indexes a series of prices to a day (the first day of a range). I'm doing this to numerous named ranges. The code that i build takes ages to do this:
View 9 Replies
View Related
Aug 29, 2008
I have a folder with about a thousand files in it, each one holds one worksheet.
What i need is a new file which lists all these file names in column A and, in column b, the value from cell A1 in each file against the file name, i.e.
book1 Apple
book2 Banana
I can list the files in the folder using dos, but cant rip the a1 cell values out,
so I need to open each workbook in turn, record the file name, and then record the value in cell A1 against it.
View 9 Replies
View Related
Nov 24, 2008
I would like to create and Index/List of all the Hyperlinks in a workbood and the locations of those links. It can be a little as just the tab/worksheet the hyperlink is located. I can then import those links into a spider to check to see if they are broken or not.
The following code is close, but I need it to loop through the workbook and list the locations as well.
Sub test()
For Each h In ActiveSheet.Hyperlinks
With ActiveCell
.Value = h.Address
.Offset(1).Activate
End With
Next h
End Sub
View 9 Replies
View Related
Feb 6, 2014
I copied and pasted text (last names) from Website A into File A. Then did the same from Website B into File B. I wrote index match formulas to compare columns between files. I've done this literally hundreds of times, and it's always worked. This time, however, I get ZERO matches - even though there are lots of them. Troubleshooting was straight-forward: it has to be website B. (Strange thing is, I HAVE used text from website B before in similar applications with no problems.) Something in the way they present the data is preventing matches. (Everything works when I manually type over text from Website B.) It's not an upper case/lower case problem. I tried copy-pasting values only - to no avail.
View 4 Replies
View Related
Oct 10, 2013
What is wrong in this Indexing code.
Code:
Range("R6").Select ActiveCell.FormulaR1C1 = "=IF($Q6="","",INDEX('Worker-Exempt'!B:B,MATCH($Q6,'Worker-Exempt'!A:A,0)))"
I get application 1004 error msg.
Cross Posting
HTML Code: [URL] ........
View 9 Replies
View Related
Mar 28, 2009
I was able to come up with a formula that returns multiple results when indexing rather than just the first match.
Now the problem I have is that my source table is going to vary in size. My source table in the formula I got working below is a dynamically named range 'ImportedData'. The data in this table will always start on Row 8 but the last row of the table will vary, so the bold/red areas of the formula need to be dynamic.
how I might modify this formula to allow for the dynamic table size?
=IF(ROWS(B$19:B19)
View 9 Replies
View Related
May 30, 2014
In range B4:M4 some cells contain values and some are blank. I am trying to write a formula that will omit the blank values and just give me the nonblank values. The code below returns the FIRST nonblank value, but I can't seem to figure out how to drag it across a row to get the others. I want to ensure that the numbers stay in the same order (so no largest/smallest formulas), but the blank cell values need to be removed.
This would then need to be repeated for (B5:M5, B6:M6, ETC).
[Code] .....
View 2 Replies
View Related
Feb 12, 2010
I am indexing dates from one workbook to another.
There are some blanks in the list that I am using, and I need to the blanks to stay as blanks in the sheet that I am indexing to, however they are displayng as 00/01/1900.
View 4 Replies
View Related
Jun 16, 2007
I am trying to white a macro that takes a file path from a cell value and opens that file. When there is no file path in the cell, it prompts a dialog box. This part is pretty much working. However, I would like the file path selected from the dialog box to be added to the cell in the original workbook.
Sub Reports()
Dim path1 As String
path1 = Range("B20").Value
On Error Resume Next
'checks if there is already a file path'
Workbooks.Open filename:= _
path1, Updatelinks:=1
'if no file path then opens dialog box'
If Error.Number <> 0 Then
Application.Dialogs(xlDialogOpen).Show Arg1:="*.*"
End If
End Sub
View 3 Replies
View Related
Oct 22, 2009
Sheet2:
col A = contains the style#
col B = contains the color of the style
col C = contains the size of the style
col D = contains the qty of the style,color, size
Sheet1:
I would like to do the following:
A1 = input the style #
B1 = input the color of that style
C1 = input the size of that style
then D1 should automatically contain the qty of the mentioned style, color, and size.
View 4 Replies
View Related
Jul 3, 2014
Below Macro which I am using to extract .PDF files. Now, I also want to see the Date moified while extracting the .PDF files. Hence, adding date modified to this macro.
Sub get_pdf_name()
Dim FR As Long, sh As String, FPath As String, FName As String
sh = Sheets("Sheet2").Name
FR = Sheets(sh).Range("A" & Rows.Count).End(xlUp).Row + 1
[Code] .....
View 1 Replies
View Related
Aug 31, 2006
I need to add about ~200 items to Combo From Other Excel File (with no duplcates).
How to make it.
Private Sub UserForm_Activate()
With cboComp
.addItem "item"
End With
End Sub
View 3 Replies
View Related
