R
Rebecca Derr
After I export from Access to Excel using:
DoCmd.OutputTo
I have to do some formatting programmatically, after which I save the file (an example):
objExcel.Workbooks(1).SaveAs strFileName, , , , , 0
the 0 at the end turns off the creation of a backup file...reference:
http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas(VS.80).aspx
Mark Ryerson wrote:
Access exports and .XLK
03-Mar-09
I have discovered that any data exported from Access 2007 to Excel has the "always create backup" flag turned on. Unfortunately, I have not discovered a way to disable that on a global basis yet.
Previous Posts In This Thread:
Excel 2007 Bug .XLK Auto Recovery
Auto Recovery is suppose to save a temp file to C:\Documents and
Settings\[username]\Application Data\Microsoft\Excel. I set it up in Excel
Options to save the Auto Recovery files in that location. However, when I
close an Excel 2007 file (that I've saved in My Documents), there is an extra
file (in My Documents) with a "Back of" prefix followed by the filename.
Three issues: 1. It's not temporary, 2. It's not in the correct location and
3. I don't wish to uncheck the Auto Recovery; I'd like Excel 2007 to work as
advertized
Thanks
--
John
The "Back of" file has nothing to do with Excel's auto recovery feature.
The "Back of" file has nothing to do with Excel's auto recovery feature.
Auto recovery files are saved by Excel with some jibberish name (ending in
XAR) and they are only useable by Excel itself when it deems necessary,
i.e., after a crash. I don't know where the file you have came from
--
Ji
Thanks, Jim.First, I want to correct my typo.
Thanks, Jim
First, I want to correct my typo. I should have said "Backup of" instead of
"Back of".
But I still have the dilema. I see the .XAR temporary file in the correct
location and Excel 2007 removes it when I close Excel. However, can anyone
tell me how to stop Excel from creating an additional file (same name as
original) with the "Backup of" prefix in My Documents
--
Joh
:
With the problem workbook active, open the File, Save As dialog.
With the problem workbook active, open the File, Save As dialog. Then open
General Options from the Tools menu. Uncheck "Always create backup". I
think this has to be done individually for each workbook in which it has
been set
--
Ji
o
i
messag
Exce
when
a
filename
locatio
work
I don't believe it; it worked! Thanks!
I don't believe it; it worked! Thanks
Microsoft
If you're monitoring this newsgroup, please fix Excel 2007. Users shouldn't
have to do this on some of their Excel files. Talk to the Word and PowerPoint
teams. This only happens in Excel
--
Joh
:
Every version of Excel I have worked with back to Excel 5.
Every version of Excel I have worked with back to Excel 5.0 required you t
follow Jim's steps to always create a backup
Gord Dibben MS Excel MVP
The issue was that Excel 2007 sometimes creates 2 'backups' (.XAR and .
The issue was that Excel 2007 sometimes creates 2 'backups' (.XAR and .XLK
which is one more than I think we need, especially when one (.XLK) never goe
away
-
Joh
:
The .xar file is used for AutoRecovery.
The .xar file is used for AutoRecovery. You shouldn't depend on it being ther
as a backup.
It's created just in case excel crashes (or windows crashes). It should be
deleted if the original workbook closes without incident. If there's a crash,
you should see a prompt the next time you open excel that will allow you to
recover your work.
Training Spec. wrote:
--
Dave Peterson
I don't depend on it as a backup.
I don't depend on it as a backup. I manually save my work every 15 minutes or
so. We also have tape backups on our server and, if it is very important, I
make a extra folder for my extra backup file. What I don't like is that Excel
2007 SOMETIMES decides that I want a backup (.XLK) and saves it where my
original file is saved. It clutters the folder.
--
John
:
Jim told you how you can turn off the creation of the backups.Training Spec.
Jim told you how you can turn off the creation of the backups.
Training Spec. wrote:
--
Dave Peterson
Yes, and I thanked him for it.
Yes, and I thanked him for it. My issue is with Microsoft Excel 2007 making a
decision to SOMETIMES check 'make a backup'. I would like to check it when I
want it checked, not when Excel decides to check it.
--
John
:
I've never seen that option get turned on by excel.
I've never seen that option get turned on by excel.
Maybe you created a workbook from an existing workbook that had option checked.
Or maybe you used a template file that had this option checked. But I don't
believe that excel changed it for you.
Training Spec. wrote:
--
Dave Peterson
Access exports and .XLK
I have discovered that any data exported from Access 2007 to Excel has the "always create backup" flag turned on. Unfortunately, I have not discovered a way to disable that on a global basis yet.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Introduction to Windows Workflow Foundation 4.0
http://www.eggheadcafe.com/tutorial...e-04d037dcd7df/introduction-to-windows-w.aspx
DoCmd.OutputTo
I have to do some formatting programmatically, after which I save the file (an example):
objExcel.Workbooks(1).SaveAs strFileName, , , , , 0
the 0 at the end turns off the creation of a backup file...reference:
http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.saveas(VS.80).aspx
Mark Ryerson wrote:
Access exports and .XLK
03-Mar-09
I have discovered that any data exported from Access 2007 to Excel has the "always create backup" flag turned on. Unfortunately, I have not discovered a way to disable that on a global basis yet.
Previous Posts In This Thread:
Excel 2007 Bug .XLK Auto Recovery
Auto Recovery is suppose to save a temp file to C:\Documents and
Settings\[username]\Application Data\Microsoft\Excel. I set it up in Excel
Options to save the Auto Recovery files in that location. However, when I
close an Excel 2007 file (that I've saved in My Documents), there is an extra
file (in My Documents) with a "Back of" prefix followed by the filename.
Three issues: 1. It's not temporary, 2. It's not in the correct location and
3. I don't wish to uncheck the Auto Recovery; I'd like Excel 2007 to work as
advertized
Thanks
--
John
The "Back of" file has nothing to do with Excel's auto recovery feature.
The "Back of" file has nothing to do with Excel's auto recovery feature.
Auto recovery files are saved by Excel with some jibberish name (ending in
XAR) and they are only useable by Excel itself when it deems necessary,
i.e., after a crash. I don't know where the file you have came from
--
Ji
Thanks, Jim.First, I want to correct my typo.
Thanks, Jim
First, I want to correct my typo. I should have said "Backup of" instead of
"Back of".
But I still have the dilema. I see the .XAR temporary file in the correct
location and Excel 2007 removes it when I close Excel. However, can anyone
tell me how to stop Excel from creating an additional file (same name as
original) with the "Backup of" prefix in My Documents
--
Joh
:
With the problem workbook active, open the File, Save As dialog.
With the problem workbook active, open the File, Save As dialog. Then open
General Options from the Tools menu. Uncheck "Always create backup". I
think this has to be done individually for each workbook in which it has
been set
--
Ji
o
i
messag
Exce
when
a
filename
locatio
work
I don't believe it; it worked! Thanks!
I don't believe it; it worked! Thanks
Microsoft
If you're monitoring this newsgroup, please fix Excel 2007. Users shouldn't
have to do this on some of their Excel files. Talk to the Word and PowerPoint
teams. This only happens in Excel
--
Joh
:
Every version of Excel I have worked with back to Excel 5.
Every version of Excel I have worked with back to Excel 5.0 required you t
follow Jim's steps to always create a backup
Gord Dibben MS Excel MVP
The issue was that Excel 2007 sometimes creates 2 'backups' (.XAR and .
The issue was that Excel 2007 sometimes creates 2 'backups' (.XAR and .XLK
which is one more than I think we need, especially when one (.XLK) never goe
away
-
Joh
:
The .xar file is used for AutoRecovery.
The .xar file is used for AutoRecovery. You shouldn't depend on it being ther
as a backup.
It's created just in case excel crashes (or windows crashes). It should be
deleted if the original workbook closes without incident. If there's a crash,
you should see a prompt the next time you open excel that will allow you to
recover your work.
Training Spec. wrote:
--
Dave Peterson
I don't depend on it as a backup.
I don't depend on it as a backup. I manually save my work every 15 minutes or
so. We also have tape backups on our server and, if it is very important, I
make a extra folder for my extra backup file. What I don't like is that Excel
2007 SOMETIMES decides that I want a backup (.XLK) and saves it where my
original file is saved. It clutters the folder.
--
John
:
Jim told you how you can turn off the creation of the backups.Training Spec.
Jim told you how you can turn off the creation of the backups.
Training Spec. wrote:
--
Dave Peterson
Yes, and I thanked him for it.
Yes, and I thanked him for it. My issue is with Microsoft Excel 2007 making a
decision to SOMETIMES check 'make a backup'. I would like to check it when I
want it checked, not when Excel decides to check it.
--
John
:
I've never seen that option get turned on by excel.
I've never seen that option get turned on by excel.
Maybe you created a workbook from an existing workbook that had option checked.
Or maybe you used a template file that had this option checked. But I don't
believe that excel changed it for you.
Training Spec. wrote:
--
Dave Peterson
Access exports and .XLK
I have discovered that any data exported from Access 2007 to Excel has the "always create backup" flag turned on. Unfortunately, I have not discovered a way to disable that on a global basis yet.
Submitted via EggHeadCafe - Software Developer Portal of Choice
Introduction to Windows Workflow Foundation 4.0
http://www.eggheadcafe.com/tutorial...e-04d037dcd7df/introduction-to-windows-w.aspx