Store & Compress Old Workbook Versions

Mar 19, 2007

I'm looking for is ComplyXL and that costs $300 to buy. So, as a poor grad student, I'm looking for an alternative solution - either a freeware program or a hassle-free VBA code.

So here's what I need the code or program to do: When I ask excel to open a pre-existing file, I'd like it to automatically rename (& compress?) the last used version of the file & save that to a filename-specific archive somewhere (hidden?), before opening the file as requested. Alternatively, I suppose that a mirror copy of each 'just used' file could be created & saved to an archive folder whenever the used file is saved & closed.

--Note: to avoid making copies of EVERY workbook I ever use, I suppose there should also be a button in the toolbar or a file-associated setting that lets me identify which files I want this task to apply to...

Basically I'm looking to have excel automatically save versions of certain key files (like Word's 'Versioning' feature) without having to remember to 'Save As', without the versions taking up much space, and without having to store the older file versions in the same place as the most recent one.

And yes, I know that a similar problem has already been posted & solved here, but they didn't include a way to choose which files used versioning nor (if it's possible) a way to compress the archived versions to save space (maybe by adding it into a WinRAR archive somewhere?).

View 11 Replies


ADVERTISEMENT

Store Macro For Use In Any Workbook

Aug 11, 2007

I have tried to look for this in several websites and have not found the appropiate answers. So i figured one of the Wizards in this board can help me. Right now when I built a macro it has to be dependent to a file. However I like to build a macro button that when I use it, it will actually just work for any given currently open sheet.

View 7 Replies View Related

Compress The Formula Is Too Long

Nov 13, 2008

how can in compress the following formula

=IF(B3="Monthly",IF(B25="Windows 2003 Std",15,IF(B25="Windows 2003 Ent",30,IF(B25="Windows 2008 Data Center ",40,IF(B25="RHEL 5","30",IF(B25="Windows 2008 Web","15",0))))))+(IF(B3="Quarterly",IF(B25="Windows 2003 Std",40,IF(B25="Windows 2003 Ent",75,IF(B25="RHEL 5","89",IF(B25="Windows 2008 Data Center ",120,IF(B25="Windows 2008 Web","45",0))))))+(IF(B3="Semi-Annually",IF(B25="Windows 2003 Std",75,IF(B25="Windows 2003 Ent",140,IF(B25="Windows 2008 Data Center ",200,IF(B25="RHEL 5","149",IF(B25="Windows 2008 Web","90",0)))))))+(IF(B3="Annually",IF(B25="Windows 2003 Std",150,IF(B25="Windows 2003 Ent",300,IF(B25="RHEL 5","299",IF(B25="Windows 2008 Data Center ",400,IF(B25="Windows 2008 Web","180",0))))))))

View 5 Replies View Related

Compress The Lines In The Report

Feb 12, 2009

I need a macro where I can compress the lines in the report below. By other words will I end up with totals on lines with the same text information. This report can have different number of lines, so it is an advantage if the macro is dynamic.

BD 000012EXPI2CAC2009SBU48595,98
BD 000013EXPI2CAC2009SBU338903,14
BD 000013EXPI2CAC2009SBU1887610,1
BD 000013EXPI2CAC2009SBU154462,84
BD 000013EXPI2GAC2009SBU739214,99
BD 000014EXPI2CAC2009SBU111295,82

View 6 Replies View Related

Compress The Worksheet File

Mar 6, 2007

i'm using the following code to compress a worksheet, but i get an error message that i would like to surpress...

'zip
On Error Resume Next
Dim FileNameZip, FolderName
Dim strDate As String, DefPath As String
Dim oApp As Object
DefPath = "c: empsalesmanMDBed"
If Right(DefPath, 1) <> "" Then
DefPath = DefPath & ""
End If
FolderName = "c: empsalesmanMDBed" '<< Change..................

View 9 Replies View Related

Compress Worksheet File

Jul 25, 2007

i'm still have troubles compressing an external xls file from within another xls file...?

(sorry...i did a search...)

???

(have to post the current code)...

View 5 Replies View Related

Expand / Compress List With Buttons

Jan 27, 2012

I am trying to make a spreadsheet for a customer and would like to include a feature where the list of parts can be expanded or compressed with buttons.

Each SO# has a set of PO#'s associated with it, and it would be nice if the viewer can choose to see the PO#'s or not see them at will (this will make a lot more sense if you see the spreadsheet example in my link.)

Ideally, there would be a button next to each "SO#" which would expand/compress accordingly. I don't want just a universal button that would expand/compress all of the SO# at once (although having this option on the side would be nice).

here's link to my spreadsheet: [URL]....

View 2 Replies View Related

Compress Data For Annual Return - VBA

Mar 4, 2014

I have the data as below. And to submit this to the third party is needs to be compressed (a total for each Full time ANNUAL salary).

RULES

All total monthly earnings must start from 0 when a "Full time ANNUAL Salary" is added or endedIf the Annual amount misses a month I need to assume the salary has ended

I hope this makes sense.

Below is test data for one person. And the result i am hoping to get with some comments.

Employee
Full time ANNUAL salary
Monthly earnings
Pay date from
Pay Date to

[Code]....

The result of the above would be:

Employee
Full time ANNUAL salary
Monthly earnings
Pay date from
Pay Date to
Comments

[Code]...

15k started 01/06/2013 so the total for the 10k starts again, alongside total for 15k

Chris
£15,000.00
£450.00
01/06/2013
31/08/2013

[Code]...

15k started 01/12/2013 so the total for the 10k starts again, alongside total for 15k

Chris
£15,000.00
£150.00
01/12/2013
31/12/2013

[Code]...

10k ended, 20k started 01/01/2014 so total for 15k starts again, alongside total for 20k

Chris
£20,000.00
£400.00
01/01/2014
28/02/2014

[Code]...

20k ended so total for 15k starts again

View 2 Replies View Related

Excel 2010 :: Compress Images In Save As Box?

Oct 14, 2013

Here is something I have noticed with using Compress Images in 2010.

When I run Compress Images from the save as dialog box in 2007, the file size is slightly larger than if I run it in 2010. However, if I then send the resulting excel file out to people, if they are viewing it on an iPad, then they cannot see the images at all from the 2010 version but can see them fine if the excel file is from the 2007 version (with exactly the same data and images in there).

I cannot figure out why this may be. The options on both are set as "Email (96ppi)" and with "Delete Cropped areas of pictures" ticked.

View 3 Replies View Related

Compress/Join Two Tables Into 1 Under Respective Headings

Jun 5, 2008

Have two tables of data the first is shown below (the first line is headers)

DogCatReptileMonkey
SmallBigNosyFluffy
SmellyNosy

The second is (again first line is headings)

SmallSmellyBigNosyFluffy
AAGFF
BGHGE
CTUBQ

Need to create code which reads the first table, finds the categories of the first table in the second table and puts these with the original headings into a new table so in this example the end table would look like -

DogCatReptileMonkey
AGFF
BHGE
CUBQ
AF
GG
TB

My original has about 150 headings in table A and B hence why I have given an example

View 5 Replies View Related

VBA To Recognize Xl Versions

Jun 3, 2009

I have some codes that require different values when running under xl2003 vs. when running under xl2007.

View 11 Replies View Related

Macro For Different Versions

May 4, 2009

I have been working on this spreadsheet off and on for a while now. I have a macro that works in Excel 2007 and a different one that works in 2003 (thanks to the help of Mr.Excel.) My problem is, the people who will be using this spreadsheet all have various versions of Excel. Is there a way to script this macro to work for all versions, or do I have to have a different script for each version of Excel? The one I am currently in need of is a script for 2002. See below for the script for the 2007 version. If there isn't a way to make a "one for all" solution, some assistance on a script that would work on 2002 would be great! The section in red is the section that returns the error when people try to run it with earlier versions of Excel.

ActiveWindow.SmallScroll Down:=-9
Columns("B:G").Select
Selection.Copy
Columns("B:G").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Columns("L:N").Select
Application.CutCopyMode = False
Selection.Delete Shift:=xlToLeft
Range("N11").Select

View 9 Replies View Related

Installing 2 Versions (or Office On Same Pc)

Nov 23, 2008

ive got my highly expensive office enterprise 2007 disk
what is the best way of installing this so i can still use 97 and 2007. any tips?
i wont bother with outlook but i'd like to try the rest ,mind you onenote,infopath and groove are a complete mystery!

View 11 Replies View Related

Multiple Versions - One Computer

Feb 13, 2009

I'm running Excel 2007 with Windows Vista. I also have Excel 97, which I was told would not run with Vista. I've since discovered that many programs that I was told wouldn't run with Vista seem to work fine.

Is it possible to install Office 97 on the same machine with Office 2007?

View 9 Replies View Related

Differences & Incompatibilities Across Versions

Aug 26, 2008

I may be creating a small Excel-based VBA application for a client on a semi-formal basis. I personally use Windows XP with Office XP installed, but I'm concerned about the possibility of serious differences between versions of Windows and Excel that may cause my code to fail on other machines.

I don't think I need to cater to any version of Excel BEFORE that in Office XP, but I probably do need to cater for versions after it. That's Office 2003, Office 2007 and Office for Vista,

View 7 Replies View Related

'INDIRECT' Formula Across Excel Versions

May 22, 2009

I have made a file that works perfectly in excel 2007, but when I send it to a client it doesn't work as they have 2003.

View 12 Replies View Related

Ordered Table (compatable With .xls Versions)

Jan 4, 2010

The document shows a table on the left that puts the data from the table on the right into order by total (and if same, alphebetical by name). However the formula used to achive this is not compatable with previous versions of excel. Need alternative function that will bring the same outcome but work with pre 2007 versions (ie .xls file extention).

View 3 Replies View Related

XLS File Type Association With Two Versions

Apr 8, 2008

I am changing the file type association for .XLS to
C:Program FilesMicrosoft OfficeOffice11excel.exe

I'm using "Change" and "browse" to set it to that exact file. However it still starts version 12 (XL2007) which is dual installed with version 11 (XL2003).

I was successful in creating a shortcut that opens version 11, despite Microsoft's apparent attempt to thwart that; now I need to fix the file association. (Try to directly edit the Office links in your XP Start Menu - how the target is grayed out?

View 9 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

Translating Argument Of A Function Between Versions Of Excel

Jul 2, 2013

When I attempt to send a spreadsheet using a German version of Excel, the following formula does NOT work properly.

=ZELLE("adresse",C14)

The function gets translated into =CELL("adresse", C14), and what I need is, obviously, = CELL("address",C14). The argument does not get translated.

View 1 Replies View Related

Design Spreadsheet In 2007 For Use On Earlier Versions

Jul 17, 2009

Compatibility mode, in 2007, is frustrating me like crazy. I thought it was supposed to 'limit' functionality to what was in 2003. But what it seems to be doing is letting me use features that only work in 2007and then tell me when I save that 'hey, these won't work after you save'. Ugh! I can't even pick a highlight color without getting a warning and wondering what it will look like to 2003 users!

Is there a 'theme' or anything that will truly limit the features I use to those available to 2003 users?

View 5 Replies View Related

Defining System Root On Different Versions Of Windows

Feb 22, 2007

I have to run a daily report from winxp or win2k and need to change the host files a few times for access.

I tried to use %systemroot% in the file path, but for some reason vba doesn't like it.

Here's the snippet I'm using for copying over the host file based on user choice: (the thing works if I change to the actual system root path (C: etc...)

Private Sub CommandButton1_Click()
Select Case ComboBox1
Case "- Choose -"
MsgBox ("This is not a choice")
Case "BTR"

View 9 Replies View Related

Remove X Close On UserForm. Multiple Versions

Mar 2, 2008

I've found a link on OzGrid "How to remove the (X) CloseButton from Userforms" but I can't seem to get it to work with Excel 2003. The code looks like it was written for Excel '95, '97 and 2000.

View 6 Replies View Related

2 Versions Installed But CreateObject Code Creating Old Version

Nov 27, 2009

Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = False
xlApp.Application.DisplayAlerts = False
xlApp.Workbooks.Open ("somepathWebquery.xlsm")
xlApp.Application.Run "'some macro"

The only problem is, the web query will only work properly if it is in Excel 2007 (2003 will parse the table in a way that is not acceptable). However, when I tried to run the script, the stubborn Excel 2003 will show up. I even tried to uninstall the Office Compatibility Pack and the stubborn Windows will only run Excel 2003 and ask me to download the Office Compatibility Pack instead of giving me Excel 2007.

I tried to open it up using Open With...and it did not work, I even tried to regserver and unregserver and that did not work as well. Somehow Windows thought the only Excel I have is Excel 2003.

Is there anyway I could change the VB Script so that it would force Excel 2007 to open?

View 6 Replies View Related

Button Position/Coordinates On Worksheet. Discrepancy Between Versions

Apr 30, 2008

Add Multiple Buttons That Select Row Of Housing Cell. One of my Macro's places a button on a sheet using Top/Left;

Set sbut = Sheets("Listings").Shapes.AddFormControl(xlButtonControl, _
Range("J" & count).Left, Range("J" & count).Top, 50, 12)

When I try to find the row of the clicked button using the following code;

Range(ActiveSheet.Buttons(Application.Caller).TopLeftCell.Address).Activate

The code behaves differently in Excel 2002 and 2007. In 2002 it returns the row the button sits on, but 2007 returns the cell above the button. This could be because the workbook is an XLS running in Excel 2007 in compatibility mode? Is there a way to "nudge" the button down a little after it has been placed using .top/.left ? Or is the only way around this something like;

Range(ActiveSheet.Buttons(Application.Caller).TopLeftCell.Address).Activate
count = ActiveCell.Row
If Application.Version >= 12 Then
count = count + 1
End If

Is this a bug, or something that I am doing wrong ? The workbook needs to be a .xls to ensure that it works in older versions of Excel.

View 4 Replies View Related

Convert Multiple Versions Of Cell Contents To Single Version?

Feb 28, 2014

I would like to automate the conversion of multiple versions of company names contained in cells to a single company name. i.e. XYZ Inc., XYZ Co., XYZ to all cells XYZ. My data file contains numerous versions of company names. I want them to all be the same company name so sorting data is easier. I now do this manually and it is getting tedious and time consuming. Can I build a table with the different versions that then chamges the cells to a single version that I choose?

View 1 Replies View Related

Offices 2007 & 2003 At The Same Time, Choose Between The Versions When Opening A File

Jul 25, 2006

i downloaded the beta version of the office 2007 for testing. can i install this version alongside my existing office 2003 version. i want to have the 2 versions installed on my computer so that i can choose between the versions when opening a file.

View 3 Replies View Related

Index/Match (value Exists In The Tab Name "store-allproduct", Cell C2, Then Take The Value From "store-allproduct" Cell A2, And Put That Value Into "testing-allproduct Cell" A2)

Nov 6, 2009

Look at the tab "testing-allproduct" cell C2. If that value exists in the tab name "store-allproduct", cell c2, then take the value from "store-allproduct" cell a2, and put that value into "testing-allproduct cell" A2.

View 2 Replies View Related

Using For / Next To Store 3D Array

Jul 30, 2012

I am trying to write a VBA procedure that uses nested For/Next loops to store the contents of a range in three worksheets to a 3 D array and then input the array into another location.

I have no problem doing this for a 2 D array, but am completely stumped on what changes I need to make in order to perform the same task on a 3 D array.

I will post my code for 2 D arrays below and will also post the uncompleted 3 D code, although, it is currently of no use because I am so lost on the 3 D array.

How do I reference sheet1,sheet 2 etc. when declaring my 3 D array? I know how to reference the rows and columns for my 2 D array by using the cells or range object, but what to do for the different sheets.

Two D Array:

Code:
Public Sub For_Next_Two_D_Array() Dim I As Integer
Dim J As Integer
Dim MyArray(4, 4) As Integer

For I = 1 To 5
For J = 1 To 5
MyArray(I - 1, J - 1) = Cells(I, J).Value

[Code] ........

Three D array:

Code:
Public Sub Store_ThreeD_Array()
Dim I As Integer
Dim J As Integer
Dim S As Integer

[Code] ......

View 6 Replies View Related

Store VBA Variable For Later Use

Sep 16, 2009

I have some code (listed below) that will open 2 groups of files(for testing purposes, I have been using for only 2 file prefixes, but will need for upwards of 10, and more may be added in the future), depending on what files have been opened in the past (it will skip those) and then import the new ones.

I am now trying to clean up my code, and having alot of it abled to be maintained be editing a spreadsheet (administator controlled)
What I would like to do is something similar to:

defvar= cells(1,1) 'where cells(1,1) has all of the info for that file to import
Selection.TextToColumns defvar

I realize this will probably be a little more complicated than this, and may even be its own sub or funtion.

Here is my starting code, and it works fine: ...

View 8 Replies View Related







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