How to retrieve earlier saved copies of a document 11-22-09
I starting typing over most of an old document. When I went to save the new
document, I hit "Save" rather that "Save as." Now I've lost my old document.
Is there any way to get it back?
In a document that you haven't closed, you can use Undo repeatedly until you
get back the original version. If you have saved and closed the document,
however, then there is nothing you can do.
Microsoft Word MVP
"Don" <Don@discussions.microsoft.com> wrote in message
Write using Word - 2007 - Windows 7
When I try to shut word file down with the red "close" button -
Word/Windows will not close.
Even after saving the files - the "word document" simply stays open
Hope you have some help....I've been frustrated for weeks.
Even tried a Word Uninstallment (didn't work) - and tried a COMPLETE
Office 2007 Series Uninstall - No luck....
Thanks for any help you may be able to provide.
Add the CLOSE command button to your Quick Access Toolbar.
Terry Farrell - MSWord MVP
&qu...Save As error 918
I am getting error 918 when trying to save a Visio (2000) organisational flow chart as an Adobe illustrator file type (*.ai).
The messgae reads 'An error (918) occurred during action Save As. The filter is unable to recognize the file.'
Does any one have any ideas how tio overcome this?
...where can i get a excel league table template?
for a league of 12 teams each team playing 11 home and 11 away games
(remove nothere from the email address if mailing direct)
"steve" <firstname.lastname@example.org> wrote in message
> for a league of 12 teams each team playing 11 home and 11 away games
I have cells which can accpet percentages and currency values
my questions is
when i enter a value <1 i want the cell to format as % if the value is
>1 then i want it to be currency.
can some one help me out i cant do this using condityional formating.
any one have ideas ???
Use a custom format instead:
You don't say what should happen if the value is =1. I assumed currency
In article <email@example.com>,
"Alexandre Brisebois (www.pointnetsolutio...Contact Email address format
I'm trying to programmatically access the my contacts from outlook, which I
did using the following code:
var outlookApplication = new ApplicationClass();
NameSpace mapiNamespace = outlookApplication.GetNamespace("MAPI");
MAPIFolder searchFolder =
The problem is that any email address (Email1Address) retrieved which is
connected to the same local Microsoft exchange server is retrieved in the
/o=First Organization/ou=Exchange A...Custom Format : Gb/Mb/kb/bytes : Need help debugging command
I'm trying to format a few series of bytes as something that is a
little more legible, and truncating the number of decimal points.
While the link 'Local Tips on Custom Formatting eg.'
has been a great aid in getting the general drift of how to write the
custom format strings, it doesn't aid debugging something that errors.
I have the following line:
> TB";[<1073741824]((#,##0.000)/1073741824)"...Why does -1, -1, and 2 equal 4 in a pivot table
Trying to do a pivot table to calculate processing time using Beginning
Inventory + Received - Ending Inventory. Used formulas to 'Reverse' Ending
inventory thinking I could do a Pivot table on the results however the Pivots
appear to be using the absolute values. Confirmed this using Drill down to
review the data and the values are no longer showing the negative signs.
...show me the path of auto archive save at in the computer
show me the path of auto archive save at in the computer
On Mon, 24 Jul 2006 06:21:02 -0700, pat
>show me the path of auto archive save at in the computer
details plze: outlook 3002 ? 5001 ?
backup add-in ?
Youve checked properties of your pst or a folder?
By Default its the same location as your default pst
"pat" <firstname.lastname@example.org> wrote in message
> show me the path of auto archive save at in the computer
...Formatting Percentages Redux
Ages ago I asked a question about formatting percentages (specifically in
TextBox controls on a UserForm) to display a plus or minus sign as
appropriate - something that the 'FormatPercent' function doesn't support. I
received a most helpful answer from either Jay or Doug - I've slept a few
times since then and can't remember exactly who it was - describing a method
for using the basic 'Format' function to meet my needs, and things have been
working a treat ever since.
Here's the situation. I need a method whereby percentage values...Saving as PDF with multiple pages per sheet?
When I go to "Page Setup" then "Advanced" there is an option for "Multiple
pages per sheet". I'm trying to get 9 business cards on one page. I'm able to
do that with the advanced setting in "Page Setup". However, "Page Setup"
appears to only be for when printing.
How can I take (or recreate) the page setup I created so that my actual
document looks the same, so that I can then save it as a PDF with 9 business
cards showing on one page?
What size are your cards? If you manually arrange the cards then they should be
...Macro to auto save file using the format YYMM
I recorded a macro that automatically saves a file then change the formula
in cell A1 to today's date, ie =today(), then save the file. I have a problem
with the last part...is there any way I can set the macro such that the file
will be saved as "c:\YYMM ABC" where 'YYMM' is the format of the date
(probably can be taken from cell A1) and 'ABC' is my own file name?
You can get the date right in the code:
dim myFileName as string
myfilename = "C:\" & format(date,"yymm") & " ABC.xls"
activeworkbook.saveas fi...Retrieve tables from web with variable URL
http://www.bibf.be/ipc/tamenu.asp has a field "postcode", asking for
a 4-digit entry and leading to the links of all members of that postal
code when all other inputs are omitted.
The visible URL in the URL bar , however , remains unchanged.
I have a list in Excel with several postal codes e.g. 2200 2500
2222 3000 for which I want to retrieve the members tot list them up
on a worksheet. I know enough VBA to do that if I only knew the key
to build that postal code into the URL. Is there a way to do that?
Thank you very much for any help.
...Matching data from one table and copy them to another
I have two Excel tables. Table 1 contains list of animals and their
description in two columns. Table 2 contains list of animals and results of a
test. Not all animals from Table 1 mach the animals in Table 2, but most of
them do. I have to link those two tables in a way that test result from table
2 appears in Table 1 Column 3 but of course I must use animal ID column as a
reference to match data. How can I do this?
It's always a good idea to reveal ranges... That said...
Table1 = A2:B100
Table2 = F2:G200
In D2 enter & copy down:
In C2 enter &am...format differnet widths columns and rows for different pages
I would like to know how you can have different formatting for row and colunm
widths on different pages; is this possible and if so how do you do it??
You could use VBA to change the column.width for a worksheet.....
if you were talking about that?
Dnereb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26182
View this thread: http://www.excelforum.com/showthread.php?threadid=486499
By "pages" do you mean printed pages on one worksheet?
On each Excel worksheet th...Graph formatting
I would like to shade the area on a line graph between 10-80 different from
below 10 and above 80. How can this be accomplished?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"Mike Williams" <Mike Williams@discussions.microsoft.com> wrote in message
>I would like to shade the area on a line graph between 10-80 different from
> below 10 and above 80. How ...linking two tables in query
I'm trying to link two tables using an ODBC table in query. Not all
records in the left table have an entry in the right table. I've tried
all combinations of the link properties but I either get only those
records that have entries in both tables or each record in the left
table duplicated by the number of records in the right table.
Any advice gratefully received
Message posted from http://www.ExcelForum.com/
You need to create the link in Query by dragging one field onto the other, then double-click on the link line. You'll either want option 2 or option ...Default formatting of an inserted bookmark
Please assist. I have several titles in appendices that I refer to in a
document (Appendix 2.1, Appendix 4.2, Appendix 4.7, etc.). The appendix
headings have a different style associated with them than the body of the
text. When I insert the bookmark reference to the appendix, the body of my
text adopts the style of my appendix heading. This is not desirable. (The
path I’m using is: Insert/Reference/Cross-Reference/Reference type:
Bookmark/Insert reference to: Bookmark text with the Insert as hyperlink
While I can reapply formatting, I will be using this document a...Font Formats
When I type a particular word (MERLIN) into a cell in uppercase, it reverts to lower case (Merlin). Why, and how do I stop it?
On Fri, 30 Jan 2004 12:21:06 -0800, "Enti" <email@example.com>
>When I type a particular word (MERLIN) into a cell in uppercase, it reverts to lower case (Merlin). Why, and how do I stop it?
Take a look in Tools -> AutoCorrect. Chances are that there's an entry
for the word MERLIN which converts it to proper case. Jsst delete that
scorpionet who hate...inserting line that runs between columns in a table
Operating System: Mac OS X 10.6 (Snow Leopard)
I want to insert a line (really an arrow) within one row that extends between more than one column in a table. <br><br>Along the top of the table I have months and I want to show than an activity begins in one month and extends for several months -- an arrow would be just the thing. <br><br>When I try to extend the line beyond the cell, it simply won't go any further. <br><br>Thanks, <br>
There is no specific provision for that in Word. Your...applyng a multiple header row across pages in default table style
I want to set up the default table format on an RTF document that will take
the fist 2 rows in my table and repeat them as a header on all the pages the
table extends to.
so I need to know 2 things
1. how do i edit the default table style
2. is it possible to set the first 2 rows as the header.
the data in my table is generated automatically and I don't know in advance
how big it will be.
1. Use the Modify Style dialog box to modify a table style in Word. The
exact steps depend on your version of Word.
2. As far as I know, this is not possible in...DateTime format in ConditionExpression
I'm trying to write a method to retrieve multiple leads by date. But when I
add datetime condition expression, an error appers: "0x80040203 Invalid
Am I doing something wrong?
The code is
ConditionExpression condition3 = new ConditionExpression();
condition3.AttributeName = "createdon";
condition3.Operator = ConditionOperator.LessEqual;
condition3.Values = new object 
Use the "s" ...Opening a Word file which was previously saved but is now too large
Operating System: Mac OS X 10.5 (Leopard)
I have been working on a WORD document for several weeks, including images as well as text. I saved the doc as usual, but now when trying to open I get the message that WORD cannot now open the file because it is bigger than 32 megabytes. How can I recover this work?
Any help appreciated!
...Currency Format not working
Control Source: =Format([Forms]![MedicalForm]![frmMSsubform].[Form].
I have also tried the following Control Source:
In both cases, the Color is NOT Red when the value is negative.
Can someone explain why?
On Wed, 27 Jan 2010 14:50:05 -0800 (PST), iamnu <firstname.lastname@example.org> wrote:
>Control Source: =Format([Forms]![MedicalForm]![frmMSsubform].[Form].
&...How can I format a multi-sheet workbook from A4 to letter without.
I receive multi-sheet workbooks from our office overseas. They use A4 paper
to print and I need to manually change each sheet to print it. Is there a
quicker way? Like the old Global function in Lotus? Perhaps a macro?
if you are changing entire sheets or the same amount/size of cells in every
sheet, you can select those particualer cells, then hold down "ctrl" and
click they sheets you want to format. if you are selecting, say, A1:F19 then
you use my trick it will format those cells in all the selected sheets.
> I receive multi-sheet workbooks...