Prevent Created With A Newer Version Message

Sep 7, 2007

I am running Excel 97 on one PC and 2003 on another, both need access to a workbook and both need to amend that workbook.

In my Macros I have a line in the Workbook to save etc

Workbooks("WB Name").Close SaveChanges:=True

When I run the macro on the 97 PC I get a message stating that the "file was created with a newer version of Excel Continue with save Y/N"

I have tried

Application.DisplayAlerts = False
Workbooks("WB Name").Close SaveChanges:=True
Application.DisplayAlerts = True

but the file does not save.

View 4 Replies


ADVERTISEMENT

Prevent Save As Version Message

Oct 17, 2006

I have an extensive application which I wrote using Excel 2002 (XP - Version 10). However it will likely be used on anything ranging from 2003 - 1997. When I tested it using Excel 97 it gave me the traditional [annoying] message asking if I was sure I wanted to save it under an earlier version than which it was created.

I want to get rid of this message (a lot of my users aren't the most computer literate and the more annoying messages I can avoid the better!)
I tried using:

Application.DisplayAlerts = False


but it doesn't affect this particular message. I need to know how to keep this message from popping up. Please Help.

Under 97 (NOT on my 2002) it also gives a "Do you want to save the changes" message upon closing even though the "DisplayAlerts" is set to false. I'm not sure why this is still coming up.

View 9 Replies View Related

Compare Worksheet To Newer Version

Jul 1, 2008

during the executiuon of a macro, I would like to " record" the content of a given worksheet. Later on, I'd like to compare the recorded contents with what the worksheet presently looks like, and return True if the content of at least one cell has changed, False otherwise.

View 2 Replies View Related

Excel 2003 :: Prevent Conversion Of XLS File To A Newer Format?

Mar 27, 2013

Is there a way to disable the Convert button on the File menu and also to limit the Save As file types? I have a workbook that I maintain in Office 2003 that gets filled out by customers and returned. When a user with a newer version of Excel converts the file, it doesn't function properly when I go open it. I believe the conversion issue has to do with Active X Controls, but I'm using them to do some things that won't work with Forms Controls, so replacing them would be a last resort. Also, upgrading Office isn't an option at this point.

View 1 Replies View Related

VBA To Check Version Of Created XLSM File?

Jun 21, 2013

I'm creating a template xlsm file that has built in marcos. This file will be used by the Engineer as a template, where they fill in the data, and then send it to the team. when the case in finished, they will use clear data macro.

The Problem I want the template to have a macro runs with startup of the file that checks for the lastest template in a network folder (shared folder where they will have read only access). If the used file is the latest one, OK. If not, give a custom msg with the location on the network.

View 6 Replies View Related

Prevent Now Available For Editing Message

Jun 29, 2007

I have an accounting spreadsheet that is used by 25-30 people. This spreadsheet has a button the user can use to save this spreadsheet allowing the spreadsheet to save itself to a specific folder path base on the dates entered in the spreadsheet.

I have begun tracking certain items in the accounting spreadsheet and have added a section to the save macro that gathers data from the accounting spreadsheet and saves the data to a ‘Spreadsheet Stats’ spreadsheet. Since it was possible that more than one person might try saving the spreadsheet at the same time and try to open the ‘Spreadsheet Stats’ spreadsheet at the same time, I placed a loop in the macro that determines if the 'logging data' spreadsheet when opened is marked as "read-only". If the ‘Spreadsheet Stats’ spreadsheet is opened as "read-only", the macro closes the ‘Spreadsheet Stats’ spreadsheet then reopens the ‘Spreadsheet Stats’ spreadsheet again and again until opened without the "read-only" status. Code seen below.

Do Until Now() = start_time + 0.002082 Or Now() > start_time + 0.002082
Workbooks.Open Filename:= _
"G:EDCUSTSERV1_ACCTGIPL SpreadsheetsBilling SpreadsheetsData DropSpreadsheet Stats.xls"
Set WB = ActiveWorkbook
If WB.ReadOnly = False Then
Exit Do
End If
WB.Close
Loop

The macro works great, however, should a user try to save the spreadsheet and the loop happens to open and reopen the spreadsheet until the "read-only" status is gone, when the macro completes, a window pops up and alerts the user that the ‘Spreadsheet Stats’ spreadsheet is now available for editing.

My question: Is there any way to prevent that pop up window? I don’t want the user to think they need to edit the ‘Spreadsheet Stats’. Remember that the macro has completed when the popup window shows up, so Application.display alerts set to false

View 2 Replies View Related

Prevent Update Links Message

Sep 12, 2007

When I open an excel file it asks if Id like to update the links to other data sources. I would like to say no everytime, does anyone know the VB to avoid the popup?

View 4 Replies View Related

Prevent Close Code Until Message Confirmed

Apr 23, 2008

I have a spreadsheet with a number of fields on it which must be filled in before the file can be saved, and if the user attempts to close the spreadsheet without filling in the required fields, I want a message box to appear asking for confirmation that the user wishes to quit, if yes, the sheet exits, if no, the sheet remains open

View 2 Replies View Related

Prevent Loss Of Data - Error Message Pops Up

Sep 11, 2013

What is this error message that is popping up when I try to insert a blank row of cells?

"To prevent possible loss of data, Excel cannot shift nonblank cells off of the worksheet. Select another location in which to insert new cells, or delete data from the end of your worksheet.

If you do not have data in cells that can be shifted off the worksheet, you can reset which cells Excel considers nonblank. To do this, press CTRL + End to locate the last nonblank cell on the worksheet. Delete this cell and all cells between it and the last row and column of your data then save."

This excel document we have has LARGE amounts of data

View 3 Replies View Related

Picking Newer Of Multiple Entries

Oct 22, 2013

I have a long table like this:

Car,date last washed
Civic, 11/1/2012
F150, 5/4/2013
Corvette, 7/3/2013

If I washed the Corvette, I'd add another row to it:

Corvette, 10/22/2013

And I would like to remove the "Corvette, 7/3/2013" entry. What's the easiest (read: least user intervention) way of doing this?

View 2 Replies View Related

Automatically Convert Older XLS Versions To Newer

May 30, 2009

I have a dir with over 150.000 files in it, especially pdf, doc and xls. Now I'm looking for a script or program that will automatically search the entire directory and look for old xls files, open them and save them in a new(er) version. I'm working with a software that needs to use these XLS files in my directory but it can't use the old xls-versions. It's an impossible job to search by hand for the old versions and put them in a new(er) version.

View 11 Replies View Related

Specify Excel Version To Run VB6

Jan 15, 2009

I have Excel 2003 and 2007 on my computer and I want open excel from vb6 but they are both called Excel.exe. So it opens both of them when I run my code. I renamed one of the exe's and I was going to do it that way but then it was going to do a whole bunch of reinstalling.

Can I specify which version of excel I want to run, in vba or vb6 code ?

Maybe by specify the path some how.

View 14 Replies View Related

Version Number?

Jan 19, 2010

If I want to create an Excel file that other users would use, and want to create a specific version number of the file. Is there a place I can save that information outside of the worksheets?

For example, lets say I create a file that is version 1.0. Can I save that somewhere in "Properties" or somewhere else so that "1.0" can't be modified, and if I come out with a different version say 2.0, I can update it?

View 9 Replies View Related

Set Default Version

Aug 23, 2007

As per title, I have both Excel 2003 & 2007 installed - I need to set 2003 as the default for opening xls files when double-clicking but can't seem to override 2007 which wants to hog all the action. I've been through the File Types menu and selected the 2003 version of Excel as the default, but it doesn't make the slightest difference.

View 9 Replies View Related

Get Version Of .dll File

Feb 2, 2008

how to get version number of the .dll file (in the path C:program files....) using VBA code. The properties of that .dll file has a tab named "Version". so i need the version number displayed on that tab.

View 3 Replies View Related

VBA To Change A Particular Cell Version 2

Dec 10, 2008

In a previous thread I asked for a solution to the following problem

Cells
A1 = 1
A2 = 2
A3 = 3
A4 = 4
etc.

What I want to do is when I click on cell A1 the value is put in cell C1.
When I click on cell A2, C1 changes to to A2 value and so on.

VERSION 2
The VBA I received is good for 1 range.
Is there a way to use multiple ranges? In my example above column A is the 1st range and cell C1 changes accordingly. Now i would like to use column B as a 2nd range and have cell D1 change accordingly.

View 2 Replies View Related

Automatically Update To New Version?

Sep 25, 2009

I have an excel based appliction that I distribute to about 150 people in the US, London, Hong Kong and Singapore. Distribution is currently done by email containing a link to a Sharepoint site (the email has the link, release notes, etc). The end users open the file and save it to their desktops, overwritting the previous version. I'm finding that many users are not updating their versions as they should be.

So what I'm wondering is if there's a way to have this process automated - so that when the user opens the file, it checks a repository (sharepoint or otherwise) for a more current version, then prompts the user to download it.

View 5 Replies View Related

Trapping File Version In VBA?

Dec 11, 2012

how I could amend the following code so that my target worksheet includes file versions? The worksheet range "Folder" contains a string specifying the target folder and the worksheet range "IncludeSubFolders" is either TRUE or FALSE. I can trap FilePath, FileName, FileSize and DateModified fine but not File Version (I'm working with DLL libraries).

Code:

Dim iRow As Long
Sub ListFiles()
iRow = Range("DatabaseStart").Offset(1, 0).Row
Call ListMyFiles(Range("Folder"), Range("IncludeSubFolders"))
End Sub

[Code]......

View 1 Replies View Related

Multipage - Vertical Tab Version

Jun 9, 2007

I need to create a multipage with tabs running down the left hand side. I cannot use the normal horizontal multipage control because this would result in an impossibly wide page. Is there a vertical multipage control? I could not find one? Or a way to convert the multipage control to show vertical tabs?

Please bare in mind that this vertical multipage will be shown in a form that already includes a normal horizontal multipage (I am using multipages within multipages too!).

View 9 Replies View Related

Database Version Control

Mar 11, 2009

We have a club membership database in Excel 2003. Unfortunately too many people can change it and we sometime use an old version for a mailout when there is a later version around. We have no easy, foolproof way of establishing which is the latest version.

Is there a way that a cell in the database can automatically have the date & time it was last changed (NOT last time it was read - Windows does that). Also a user name.
Failing that, is it possible to detect when anything has changed & when you try to close the file it requests a date & user which have to be entered before it closes ( this relies on the user putting in valid info but at least it's a start).
Ideally when you re-open the file it should say in A1, A2 - last changed .... by .....

View 9 Replies View Related

Autosave To Older Version

Jan 2, 2010

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() ....

View 9 Replies View Related

Vba Version: Search For Topics

Mar 21, 2007

I've made a workbook in office2002, and it's work fine. but when i run it from PC with office2000 I've encounterd some vba erorrs. NOW I want to search for topics talking about this topics.

--- In General Idea-----
How to be sure that my work will work fine with all versions.

View 3 Replies View Related

Trial Version That Expires

Jun 3, 2007

how i can make my excel file triel and can use just for 7 days?

View 4 Replies View Related

Return Version With VBA Code

Feb 15, 2008

Is there a way to find out which version of excel somebody is using within VBA?

View 2 Replies View Related

Run Different Code Based On Version

Aug 2, 2008

I am writing an excel 'tool' that must be compatabile with both Excel 2003 and Excel 2007. I originally wrote some functions using Application.Filesearch, and had to re-write that code due to the lack of Application.Filesearch in Excel 2007 (I used the chdir method). The chdir method is much slower the way I am using it, therefore, I would like to still use the Application.Filesearch method for those using Excel 2003. Now, I have the user select their excel version and run the correct macro. Is there a way to detect the Excel Version automatically and the call the correct macro?

View 2 Replies View Related

Version Limitations On Countifs Functions?

Mar 27, 2014

I recently bought a new Dell XPS 10 tablet with a keyboard. When I copied my spreadsheets from my old notebook, none of the countifs or countif functions are working, all popping out a zero. It work completely fine on my old notebook on which I have Excel 2010 installed. On the tablet I have the pre-installed Home & Student 2013 RT. Could this version have limitations to my functions? What can I do to get my functions working again?

View 4 Replies View Related

VBA Test For Finding Excel Version?

Dec 7, 2008

Is there a way in vba to test to see what version of Excel is being used? My macro would crash if their data would exceed the 65K row limit in Excel 2003. I have a message that pops up if they do that, and it handles the problem just fine, but if they are ALREADY using Excel 2007 (or whatever comes later) I don't want the message to appear.

View 9 Replies View Related

Convert MDY To DMY With Text Version Date?

Dec 12, 2011

I have some date data use MDY format. Want to convert to DMY format. But text to columns function doesn't work as those dates are text not numbers. How can I do the convertion?

examples:

3/14/19644/18/1964

View 9 Replies View Related

User To Enter Date (US Version)

Dec 13, 2011

I have a userform where I want the user to enter the date (US Version)

I want them to enter 121311

I want the textbox which I am using to show 12/13/11 when they exit from it.

Here is my code i am using:

Private Sub mm_built_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim mm_date As Date
Me.mm_built.Text = Format(mm_date, "mmm/dd/yy")
End Sub

What shows when they exit the entry for the above is Dec/30/99

How do I get it to show correctly?

View 5 Replies View Related

References To Tables In Version 2007

Aug 18, 2007

The new table feature of Excel 2007 is IMO the best improvement over the 2003 version.

I have 3 questions about references to these tables:

1) When you reference to a cell in a table on the same row, you get the reference "#This Row". Why isn't there a "#This Column" reference?

2) Normally when you want to "fix" a reference to a cell you use the $ sign by hitting F4 (i.e. A1 -> $A$1). How can you do this with tables (Column1 will not change to $Column1 when hitting F4)?

3) When I have = sum(Column1) above Column1 and I drag this to a cell above Column2 I get =sum(Column2). However, when I have the formula {=sum(Column1)} this doesn't work. Why?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved