I 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 am trying to write an SQL query using parameters in an Excel Worksheet and then return the results to the current sheet ar cell B11. I have found it imposible to make it work in SQL so am trying to run it from VBA to pass the parameters. These are named cells StartDate and EndDate in cells A2 & A3 respectively and should replace the constant dates below. I am working in Excel2003 & MS SQL 2012.
I have tested the query on SQL server with fixed values (which are still in it). It works fine & I have pasted it in.
I took an existing query I found & tried to modify it for Excel2003 but ... Whatever syntax I use, I get a Run-time error 424 when I get to a line with 'connection'
Code:
Sub DateQuery()
With ActiveWorksheet.connections("ndserver01").oledbconnection
' .Connection = "OLEDB; DSN=Excel Files; provider=SQLOLEDB; Catalog=NDM_Sage200;Data Source=ndserver01"
.Refresh BackgroundQuery:=True
.CommandType = xlCmdSql
[Code]...
What have I done wrong
Excel 2003, Windows XP SP3
I cannot solve problem 1, thus I tried workarounds, however there are also problems with them (problem 2, problem 3). I do not use .activate or .select in my code. I have recreated the problem in sample workbook.
Problem 1:
I get a blink when I call another sub from Worksheet_SelectionChange event.
Event is located in Sheet module, CellChange procedure - in seperate module
Sample ...
I 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 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 RelatedI'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 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 Related