Get Time Application Was Opened
Dec 4, 2007I need to know when excel opened. Is there a way to tell this?
View 7 Replies
ADVERTISEMENT
Return To Certain Tab Each Time Workbook Is Opened
Nov 10, 2009I have an excel file on a share site which is accessed by several people. The first tab is set up as a home page which directs the person to the relevent part of the work book that they need. My problem is that as the person saves their updates it also saves the location of the workbook they were in. I want it to return to the " homepage" automatically each time it is opened.
View 5 Replies View RelatedVBA To Count How Many Time A Workbook Is Opened
Oct 27, 2010Just wanted to ask all the VBA gurus if they would know how to put the number of times (i.e. in Sheet 1, Range A1) a Workbook is opened.
I then want to basically have the code delete every sheet if ithe count is > 50.
VBA Script That Saves Opened Workbook On Time?
Sep 17, 2013I need an vba code that if my workbook is open say at 14:00 that it automatically save and close the workbook.
View 2 Replies View RelatedTrack Date And Time A File Is Opened
Aug 5, 2007I found some vba codes in this forum which record the date and time in column A when a file is opened.
Can the codes be modified such that when someone opens the file the second time on the same day, the date and time are recorded in column B?
Attached file for your reference.
Increment Cell Each Time Workbook Is Opened
Apr 11, 2008Below the code allows me to get the last modified, but I want to get the last time the file was access. How do get the "Last Accessed" Date/Time?
If CurrentTime < ActiveWorkbook.BuiltinDocumentProperties("Last Save Time") Then
MsgBox "Date Moved"
Macro Running With Time Application Is Not Flashing?
Jun 6, 2014I have macro running with time application. when msgbox pops up, excel tab on windows taskbar should flashes, but it doesn't.When switch to excel, didn't even see the msgbox until I click on any cell.
View 9 Replies View RelatedApplication-defined Or Object-defined Error :: Add Named Range At Run-time
Oct 4, 2006Trying to add a named range at run-time
Here's what I have so far ...
Application.DisplayAlerts Freezes Application
Jul 14, 2006Im copying and pasting data from one workbook to another but when I want to close the source workbook, it comes up with this message that I have much data and if I want to keep this in a clipboard. I thought I could disable this with Application.DisplayAlerts = False but when I do this, Excel freezes. Im I doing something wrong. How can I supress this window?
Public path As String
Sub Get_data()
path = "\Nlchoosa.nlOPS_Processes$OPS_ProcessesReports Sector performance"
Workbooks.Open Filename:=path & "ReportsSector Performance Reporting week.xls"
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.copy
Windows("Sector Performance report Week.xls").Activate
ActiveSheet.Paste
Application.DisplayClipboardWindow = False
Windows("Sector Performance Reporting week.xls").Activate
Application.DisplayAlerts = False
End Sub
Run Time Error 1004 Application-defined Or Object-defined Error
Mar 5, 2013I have a relatively complex report that I work with and a worksheet is no longer required. I have deleted the worksheet and reference to it hwoever when running the macro to pull all the data, it gets to the summary of all the data and i get the Run Time Error 1004 Application-defined or object-defined error pop up. ON reviewing it, it is on this line ActiveCell.Offset(0, 0).Range("a1:a" & Range_Height).Select of the below code...
VB:
Sub GetRangeName()
Sheets("TOTAL").Select
[Code].....
use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window.
Run Time Error 1004 (application-defined Or Object-defined Error)..
Apr 26, 2009I have a simple function below to put in different forumlas in different cells to get stock quotes. When I run this I get runtime error 1004 application-defined or object-defined error. The first formula goes through but vba chokes on the next formula: ActiveCell.Offset(I - 1, 4).Formula = username
Run-time Error '1004' Application-defined Or Object-defined Error
Aug 12, 2009Run-time error '1004' Application-defined or object-defined error. I am trying to use this
View 2 Replies View RelatedRun Time Error 1004 - Application-Defined Or Object Defined Error
Oct 4, 2009I was trying to use the below code
View 4 Replies View RelatedRun Time Error 1004 (Application Defined Or Object Defined Error)
Dec 4, 2009I keep getting a Run Time Error 1004 (Application Defined or Object Defined Error) when my sub reaches this line:
ActiveCell.Formula = "=SUM(D222,D224,D226,D227,D229,...)"
In the actual line of code the "..." above is another 20-30 or so cells in column "D". Probably no more than 150-170 characters in the line.
If I remove half of the cell range names it works, but I need all of the cell ranges for the equation.
"Run-Time Error '1004': Application-Defined Or Object-Defined Error"
Dec 23, 2009when I run the macro, I receive an error: "Run-Time Error '1004': Application-Defined or Object-Defined Error" See attached macro. If I click "Debug", the line "With r.Resize(,1)....... becomes highlighted in yellow.
View 9 Replies View RelatedLog Of Who Has Opened File
Jan 7, 2009Is there a way to create an outside log of who has opened an excel file and when?
I am looking to add some accountability to a project.
AutoSave Only When Opened
Jun 21, 2013I have macro enabled workbooks that the contract number increases by one everytime they are opened. Is there a way to make it auto save though when its opened. Right now I have to click save as soon as I open it. If I do not do this when I open it, when I open it again the contract number will stay the same as it was, because I save it at the end after I put all customer info in.
View 8 Replies View RelatedIdentify The Opened .xls
Mar 30, 2007I am using ADO connections in my program to insert the datas in the excel. I want to find if the excel is locked by another user. How do i do this in ADO commands.
View 6 Replies View RelatedRun Macro Once Workbook Is Opened
Oct 2, 2012I want my macro on the IR Tracker sheet to run once workbook is opened. Is this possible?
I have attached the workbook for better understanding.
Use Opened File In Formula?
Aug 18, 2014Is it possible to insert the filename automatically in formula after the input from the user?
I want to ask the user to input a filename and afterwards, call that filename in an Index-Match
I have the below formula with the sample filename:
ActiveCell.FormulaR1C1 = _
"=INDEX('[filename1.xlsx]DATA'!C9,MATCH(RC[1],'[filename1.xlsx]DATA'!C32,0))"
Range("A2").Select
Copying From One Spreadsheet To Another When Both Are Opened?
Nov 15, 2013How do I get one sheet to update from the other when I open both sheets. Somethign like an auto update. If I had two tabs on the same spreadsheet I would just use = but I can't use that with two different sheets.
View 3 Replies View RelatedSet Reference To NOT OPENED Workbook
Dec 18, 2008I've started this thread a few weeks ago but didn't get any answers on how to solve the problem or if it was even possible to solve. I would like to know if is possible to set a reference to a NOT OPENED workbook. All the code I've tried so far didn't get me anywhere:
View 3 Replies View RelatedCsv File Different When Opened Manually And Via VBA
Jan 21, 2009Opening it manually the dates in column C are all consistently date numbers. i.e. using the =ISNUMBER() function to test them, they all return True
However when I include the VBA instruction:
Alt+Tab Not Working When An Userform Is Opened
Apr 28, 2009While using an userform, is it not possible to swap to other files in the window?
I.e Alt+tab function is not working while an userform is opened.
VBA Code Stops - When WB Is Opened By Another WB
Nov 4, 2009I have 3 Work books - one (WB1) checks its version number against an online record and if they dont match it opens WB2 which then proceeds to download the updated version copy information from WB1 to its self which it then pastes into WB3
WB1 then gets deleted and WB3 Renamed to the old name of WB1
the issue i have is when i open WB2 using the button that also checks for updates on WB1.
WB2's code seems to just stop when it gets to the point of updating WB3 no error messages or nothing it just stops!
NewMasters(2).xls = WB1
Updater.xls = WB2
NewVersion.xls = WB3
Re-opened: Determining Thresholds
Jun 3, 2009 There are a lot of worksheets with a lot of similar data from which I have to determine the threshold. So if possible I would like to create a macro.
I want to know the threshold value when Y=2.
The threshold can be between different Input Values (=Stimulus Intensity (ľA)).
For example: the threshold of amp P2-N1 & P3-N3 lies somewhere between 200 and 252ľA. The threshold of P1-N1 lies somewhere between 318 and 400ľA.
Is it possible to determine the threshold value with a formula?
Massage Box When File Opened
Jan 6, 2012I would like to have a message box pop up when a file is opened requiring a user to enter information (Name), that would then put this name into a cell for later use when they are printing.
View 6 Replies View RelatedZoom To 120 When Any Workbook Is Opened?
May 13, 2014I am looking for a way to have Excel zoom to 120% whenever any workbook is opened. (My boss has poor eye sight...)
I set up a simple Macro
Code:
Sub Auto_Open()
ActiveWindow.Zoom = 120
End Sub
but I get an error that says "Run-time error '91': Object Variable or With block variable not set.
Determine If A Template (.xlt) Has Been Opened
Mar 3, 2007i'm trying to find out how i can determine if a template (.xlt) has been opened.. the name of the file generated is dynamic, and increments by 1 for each open count. this limits me from using an isWorkBookOpen() function, since i do not know the name, and my project does not allow me to save the file file before hand..
my thought was to set the .name value to the workbook object holding the template.. and then check to see if a workbook with that name is open.. but alas.. .name is readonly
how can i check to see if the template file is already open?
Disable The Vba In A File Being Opened Using Vba
May 20, 2007I have excel vba code to open .xls files on my server. Files to open are chosen by the user via a UserForm within my app, it shows them all their files in their directory on my server. How can I open their files (.xls) that they select but DISABLE the VBA from being able to run/execute, if they have any attched to the file?
I now have all code in place to open the file no problem, I just need to know how to disable the VBA part from being "turned on" when the file opens.