Insert Author And Date In Footer Of Workbook
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
ADVERTISEMENT
May 14, 2014
Ive created a simple VBA code thats suppose to insert a header and footer. The header works but the footer doesn't. Does it matter that my footer is in "Quotes"? I would like for it to say Page of Page so the footer will say 1 of 4! I feel like its something simple just not sure...
Code:
With ActiveSheet.PageSetup
.CenterHeader = "HSIS Phone Bill"
.CenterFooter = "Page &[Page] of &[Pages]"
End With
View 3 Replies
View Related
Jan 21, 2010
I would like to use macros to insert the 'location' of my excel file into the spreadsheet footer. I have the following code already:
View 3 Replies
View Related
Jan 1, 2013
how to add footer with file path name to all worksheets of a workbook. I m adding one by one and my workbook has more then 110 sheets.
View 5 Replies
View Related
Feb 2, 2014
I have the following code which is supposed to delete footers in all sheets in my workbook. Problem is that it does NOT do what it is supposed to do.
For Each Wks In ActiveWorkbook.Sheets
With Wks.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
End With
Next Wks
View 2 Replies
View Related
Mar 26, 2013
I am trying to add the sheet name to the center footer for each worksheet in a workbook. The workbook has about 80 sheets and it is cumbersome to do this manually. I am using Excel 2010.
I have tried to record a macro capturing what I do manually, but when I run the macro on another sheet, it does not add the sheet name to the center footer.
I have tried searching for a macro online and the ones I have found just crash excel.
I know I am probably missing something obvious in my macro code.
View 4 Replies
View Related
Dec 4, 2007
I'm trying to append a date variable to the end of headers for let's say 3 worksheets in a workbook. Each worksheet has a different string value, and I want to add a date variable at the end.
For example, sheet1, sheet2, and sheet3 says "Country Analysis", "Regional Analysis", and "State Analysis", respectively. I want to add the month and date to that so it would say something like "Country Analysis December 2007" for Sheet1, without hard coding it. Essentially, loop through however many worksheets and add a date variable at the end of each header on the left side.
I know how to get the date variable (format(date, "MMMM YYYY")) and the code behind the headers.
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
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
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
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
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
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
Jan 14, 2014
The amazing code I saw was from this thread Auto lock cells after data entry when file saved... where the code was made by Jafaar Tribak.
It basically locks cells that have had data inputted into them when the file is saved (with a nice prompt warning of the used cells being locked.
This is Jafaar's file [URL]
And this is my file where I'm trying to make it work in the "Employee data entry" Sheet:
[URL]
And finally this is the file after I tried to copy the code over : [URL]
Trying to make it so that in the employee data entry sheet locks cells after an employee inputs some data into said cells.
I thought that by setting an "inputrange" on the employee data entry sheet the code would track it down automatically but maybe I'm completely wrong. I cant see anything wrong with it (probably because I"m not that good at vba) but I fear I may have left out something really simple!
I seem to disable my other macros when i try to insert this code in (I have a macro that when you click on a cell a calendar pops up so you can click on a day from the calendar rather than typing out the date)
View 9 Replies
View Related
Jun 25, 2008
I have a user form that when a command button is clicked it enters the data from the from into coloums a,b,c,etc. I have code to do this but I want to add code to add a static date in coloum B based on if coloum A had data entered from the form. I need the date not to change to current date when the file is reopened. I am trying to elimate a date text box in the form. I have a link to the file http://www.box.net/shared/zdtsjv0qos
View 7 Replies
View Related
Mar 7, 2014
I have a sheet(Sample.xlsx) in which weekly data is collected and this is done by using the VBA code(Present in Copy 1 and Copy 2 button in Master US.xlsm) written by me. But in my code, it inserts a new after asking two parameters, i.e. line range(i.e. row no for eg A64) and date. I want it to automatically search row containing last date and inserts row below it and this needs to be implemented in "Insert Automatically" and "Insert Date" button using VBA code in Master US.xlsm sheet.I dont have problem with second paramenter.
Logic i want to use :
Itergation of whole page
{
If (col A<>Date)&& col A=Average(i.e. contains average word)
then
inserts row above that row
And then ask for date to enter using date variable.
then inserts row above that row containing last week data in col A.
}
"Insert Automatically" in Master US.xlsm sheet is the button which takes system date and implements the above logic.
"Insert Date" in Master US.xlsm sheet is the button which ask for only date and implements the above logic.
Sheets attached.
Master US.xlsm
Sample.xlsx
View 1 Replies
View Related
Jan 16, 2013
is there a non VBA way to insert the workbook name in a cell?
View 1 Replies
View Related
Apr 7, 2009
I want to put the vba code into each "ThisWorkbook" in each workbook that is in a folder. I want the code that is placed in each "ThisWorkbook" to run whenever that workbook is opened.
How would I go about doing that? I have this code so far to open the workbooks that are in the folder.
View 6 Replies
View Related
Apr 4, 2007
It shouldn't be this hard, from within an excel macro I am currently adding a new workbook and doing "some stuff" basically creating a report based on the first workbook.
In the new workbook I want to add a BeforePrint event to the ThisWorkBook Module. I can add it to other sheets, to code modules and other code to the thisworkbook module....but not the BeforePrint?
here is the code I've been working with, I also checked Chip Pearson's site and still can not figure it out.
Add Beforeprint To New Workbook Crashes?
View 9 Replies
View Related
Oct 18, 2008
How do I insert an existing worksheet (previously exported from the same workbook)? I need to be able to do it programmatically.
View 10 Replies
View Related
Apr 8, 2009
i have a workbook with over 100 odd worksheets of different names... i want to insert 1+ columns in every worksheet . For Example ...
in worksheet 1 name abc .. insert 1 column in column B (put clumn b data in column C)
in worksheet 2 name def .. insert 2 column in column B (put clumn b data in column d)
in worksheet 3 name ghi .. insert 3column in column B (put clumn b data in column e)
View 4 Replies
View Related
Aug 11, 2013
how to insert multiple tabs in the workbook?
i try this
Code:
Option Explicit
Sub Add_Multiple_Tabs()
Dim Tabs As Variant
Dim I As Byte
[Code]...
View 7 Replies
View Related
May 3, 2013
[URL]
"Is there a way to insert a column in a workbook that doesnt run all the way through the page?" Is a page break a potential fix?
View 2 Replies
View Related
Jul 11, 2007
I have a workbook with 61 sheets in it.
What I need to do is insert two rows at the top of each sheet. Now I know I can manually do it, or write a macro to, that bit's easy.
However, when I insert the rows, a lot of my formulas try to pick out the wrong range.
So for example, lets say we're looking at sheet 1. When I insert 2 rows at the top this style of formula still works...
=B14/B12 (it automatically becomes =B16/B14)
=SUM(B10:B11), =B12+B14, =B12*0.25, these also update automatically.
Even a reference to ='Sheet 2'!B48*2 still updates automatically. But formula's of this kind do not...
=SUM(Sheet4:Sheet10!B5)
(regardless of inserting 2 rows, this formula does not change to =SUM(Sheet4:Sheet10!B7) )
View 3 Replies
View Related
Sep 19, 2013
I have a stocklist that is currently in excel with product codes in column B. (eg 60080U-090)
I want to insert product images into column A. The product images are labelled as the style code (eg 60080U-090)
Now this is where you will chuckle, previously we have spent hours manually adding each image into the relevant cell and resizing.
Images are saved on a folder in the desktop labelled "Imagery" The excel workbook is saved in the same folder and labelled "Stock"
View 9 Replies
View Related
May 2, 2006
I am copying the times from a bi-weekly timesheet to a monthly timesheet. What I am doing is opening the bi-weekly timesheet, executing VBA code that opens the monthly timesheet and inserts the appropriate data. What is happening is if I execute the code via the VBA editor the program works flawlessly and copies the data. When I try to bind the code to a macro and execute it, it opens the monthly timesheet but just flat out stops where it should begin inserting the data. No errors or anything.
Here is the
Sub tstoitsrev3()
' Define Variables
Dim wsheet As String, wsheet2 As String
Dim wb As Workbook
Dim hourarr(9), dayarr(9), mchkarr(9)
Dim mcheck, mdiff, edate, sdate, wsmnth, yr
If there is anything I can do to perhaps help streamline the code or a smarter way of accomplishing my task please let me know. I had to upload the workbook screenshots to a seperate source due to their size. Thank you in advance for all your help and I hope to become a valuable part of the community.
WEEKLY TimeSheet:
MONTHLY TimeSheet:
On a quick side note I cannot modify the timesheets in any way other than through the code. For example, I cannot re-locate where data is placed on the time sheets.
View 9 Replies
View Related
Jun 16, 2008
I need a macro that will do the following scenarios.
1. I have two workbooks.
a. The first contains a sheet with " Names" listed in column A.
b. The 2nd contains a sheet with "Names" listed similar to first workbook. The only difference is that the 2nd workbook contains 2 other columns, "Age" in B and "Address" in C.
2. Only the 1st workbook is opened.
3. When I click a name in the 1st workbook, it will look for a match with that of the 2nd workbook.
a. If there's a match, it will copy the corresponding "Age" and "Address" and display them as comment to that name in the 1st workbook.
b. Else, it will display a comment that no record was found.
View 3 Replies
View Related
Jun 23, 2006
I'd like to inset a date automatically when ever a cell within a single
column is selected.
View 14 Replies
View Related
Sep 24, 2009
I have a "customer info column" column (b) and a "date column" column (a) is there a way that when i put a new customer into column B, that column A would automatically put the days date in which i put the new customer in column B. so b3 would have the new customers name and A3 would automatically have todays date (the day i input new customer) inserted.
so b4=new customer a4=todays date, tomorrow i input another new customer and then b5=new customer a4=tomorrows date and so on down the line.
there is no "right clickinsert date" or anything like that.
View 14 Replies
View Related
