Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,986
Default save as .xls (97-03 format) with code

remember that xl07 has the 4 digit file extension and xl03 has only 3 digits.
I believe what you are seeing is the built in warning system to let you know
that you might be doing something you don't want to do.
"JNW" wrote:

I've got some code that closes a code generated workbook and saves during the
close.

Workbooks(Workbooks.Count).Close _
savechanges:=True, _
Filename:=FName & "Myfile.xls"

FName is the folder location.

When running the code in xl2007 the code generated/closed/saved files can
only be opened in xl2007.

When running the code in xl2003 the files can be opened in both 07 and 03,
but when opening in 2007 there is a warning message first.

Has anyone seen this? and more importantly, does anyone know how to remedy it?

Thanks,
--
JNW

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to conditional format all black after date specified in code? wx4usa Excel Discussion (Misc queries) 3 December 26th 08 07:06 PM
Code Date Format Depending on Computer format Myriam Excel Discussion (Misc queries) 0 July 17th 07 03:26 PM
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: harpscardiff[_10_] Excel Programming 8 November 10th 05 12:24 PM
Placing a code before Save & Save As Alex Martinez Excel Programming 1 September 27th 05 06:35 AM
code for converting data format in another format mistral Excel Programming 0 August 19th 04 04:50 PM


All times are GMT +1. The time now is 08:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"