I 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 RepliesI have this code, and it's not working: ...
View 9 Replies View RelatedIs there a way that I can have an excel document "autosave"?
Specificaly I would like: If a value in a specific cell's value is changed I would like the document to automatically save the document as the name of the value that is typed into that cell when the user closes the document.
I'm not sure if this is possible, but it would be great if there was some way to do this.
I am trying to use the following macro to autosave a document to a pdf file. It works except it always saves it as the same name. Is there a way I can make it save it and when it saves it, title it as the contents in cell A5?
Code:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:UsersTRFoundationDesktop529431.pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
True
I'm trying to write a macro in excel that will save the document every couple of minutes. After searching the forums here for a bit I found something that might work:
Sub test()
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 30
waittime = TimeSerial(newHour, newMinute, newSecond)
Do
ActiveWorkbook.Save
Loop
End Sub
The only thing about this is that it runs constantly and won't stop saving. Is there a way to do this where it will only save every 5 minutes or so?
I am using the following code to automatically save the workbook when excel is being closed.
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Close SaveChanges:=True
End Sub
This seems to be working fine (in the respect that when the user closes excel it saves this file without a prompt), the issue i have (and i appreciate it is a small issue) is that excel remains open but without any open workbooks. Is there a way i can amend my code so that excel closes too.
I m executing some macros in my file. After executing I need to save my file automatically (which is already saved). Means I dont need to press "CTRL + S".
View 4 Replies View RelatedI have copied the below coding from the forum.
View 3 Replies View RelatedI have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks
I am a heavy user of excel and often have many workbooks open at the one time.
I wonder if anyone could help with some VBA code to automatically save a copy of a workbook on a monthly basis (Say the 1st of each month, or the nearest date to that if it has not been saved on the 1st.)
I would like this to be done without user input, and to be saved with the current workbook name + the current date. It can also be saved in the current workbook folder. I am using Win XP Pro and Excel 2003. This would also obviously need to check if the file currently exists, we can say the filename is Cars and the directory is C:Data. Finally I do not wish to stop the users from saving their own version with save or save as.
Please review the following and advise the one Best Connection needs to save in Excel 5.0/95 format without prompting me about incompatability issues
Sub Tomo() ....
I have seen a number of discussions on this subject. I used Roy's code posted here and wanted to make a small change. I want to give the user a warning msg, few minutes before the autoclose would be scheduled to occur. This would give the user a chance to change cell selction or do somethig to reset the timer. If the message goes unanswered, the autoclose should occur as scheduled.
I am attaching a workbook with the macros installed in workbook, standard module and worksheet.
It dosn't seem to do what I want. It seems to work, but it acts differently everytime I run it.
Can someone please look at the attached workbook and help me fix it?
Is it possible to disable the autosave feature in vba?
View 3 Replies View RelatedIs 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.
I 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 RelatedI 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.
Is 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
How 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 RelatedI'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 RelatedOpening 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:
While 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.
I 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
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?
I 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 RelatedI 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.
i'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?
I 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.
Is there any way to access all the applications which are opened through only Excel.. Like creating a menu which will list all applications that are running.. like Word., other excel workbooks,Notepads etc?
I run a macro which runs saves the active file to a different location to ensure that I retain the original like so -
If ActiveWorkbook. Name = "KEY_DATA_CFT77" + ".xls" Then
ActiveWorkbook.SaveAs Filename:= _
"H:HOME imcEXCELKEY_DATA_2006KEY_DATA_2006_01KEY_DATA_CFT77_01.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
End If .................................
Is it possible to write code that can identify how a workbook has been opened i.e. has the workbook been opened by another workbook or has it received a double click event on the workbook itself.
If it is possible I would like to place the code in the open event of the workbook that is being opened.