Access exports and stopping the creation of .xlk


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
 
Ad

Advertisements

S

Steve Hutch

Microsoft needs to disable this xlk extension "feature" - it is very
annoying. It is so annoying that I may go back to generating .xls files from
Access 2007 instead of the new .xlsx. I know I can turn off this xlk feature
 
G

Gord Dibben

Not the default for new workbooks.

See my reply to your other post.


Gord Dibben MS Excel MVP

On Wed, 5 May 2010 11:05:01 -0700, Steve Hutch <Steve
 
Ad

Advertisements

T

thfcalendar

Pretty useless response, IMO. If you think you know the answer how about sharing it with us instead of implying things. I have this same problem andit appears to be Access that's setting the flag. Now to figure out how tostop it from happening. Maybe the MS Access MVP community will be more helpful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top