Can you make excel auto save your workbook?
I need Excel to automaticly save my work every 2 or 3 minutes if that is
possible. Can it do that?
what Excel version are you using?
"Rhiannon" <Rhiannon@discussions.microsoft.com> schrieb im Newsbeitrag
> I need Excel to automaticly save my work every 2 or 3 minutes if that
> possible. Can it do that?
"Frank Kabel" wrote:
> what Excel version are you using?
> Frank Kabel
> Frankfurt, Germany
&g...converting a lead with customised attributes into an account
the current conversion of a lead into an account is not including
customised attributes of the lead.
how do i duplicate the customised attributes from the lead into the
You probably need to look at adding additional mappings to the relationship
between Lead and Account.
I assume you have created the fields on account, so you should be able to
map these. go into settings openthe lead entity and navigate to
relationships then select the Lead to account relationshipand add new mappings
Hope this helps, give me a shout if you get stuck
http://www.crm...How can I print to email?
I want to send the results from some sheets to people who
do not have Excel. If I attach the XLS file, it will be
useless to anyone without Excel. I basically want to send
what I see on a printout to a printer or Fax.
Any ideas? Is there a way to setup email as a printer?
This will enable me to use the same method for Word,
Powerpoint and other products without caring about the
You can send the text in the body of the mail
I don't know what Excel version you use and which mail program?
Or let them download the free Excel viewer
You can view and ...how can I show leading zeros in excel
I am trying to input some numeric data into a spreadsheet, some of the
entries have leading zeros, every time I move to the next cell, Excel changes
the data by removing the leading zeros. I have tried reformating the cells in
question in Number & General, both give me the same problem. Can somebody
Using Excel 2002. Thanks.
You could either format the cell as Text (then type your data)
or you can start with an apostrophe '000123
or you can use a custom format:
in the type box, put as many 0's as you want
The first two op...Money Can't Set up a Mortgage Right!
I have issues with Money 2003.
I bought a house Nov 2003. I set up the mortgage account and tell it
my purchase date. It starts the loan 1/1/2004 because it assumes I
have paid Nov interest at closing and won't owe anything until
1/1/2004. This screws up my net worth reports because I had a home
asset in Nov 03, but the loan liability doesn't appear until Jan 04.
Broken! I can't seem to set the loan date to force it to recognize the
Nov loan beginning date.
What to do??
Money starts the loan in 1/1/2004 because that's the date you told it the
first payment...Quicken Convert #7
Downloaded Money05 trial.
Validated 10 MB quicken file.
Followed instructions in Money for conversion, hung-up computer, twice.
Reduced size of quicken file to 5 MB.
Now receive following error message:
Your Quicken file could not be converted.
Money could not convert your Quicken file. You might have run out of disk
space or system memory.
Try closing other programs and making sure the disk you are copying your
file to has enough space. Then try converting the file again.
--------------------------------------------------------...Convert MFC App to MFC ActiveX Control?
How to Convert MFC App to MFC ActiveX Control?
I had a MFC MDI application which is also a COM server.
Now there is a need to turn this into an OCX control so that it can be used
in a dialog.
Your help will be highly appreciated.
You could try with http://www.microsoft.com/mind/0497/mfc.asp (we used it at
work, it works fine for quite some years now).
Dear Mr. Pusic,
Thank you very much for the information.
I will spend time on the paper.
"Goran Pusic" wrote:
> You could try with http://www.microsoft.com/mind/0497/mfc.asp (we used it at
> wo...How can I initialize the value?
template < class elemType >
explicit MyArray( int size = DefaultArraySize );
MyArray( elemType *array, int array_size );
MyArray( const MyArray &rhs );
delete  ia;
bool operator==( const MyArray& ) const;
bool operator!=( const MyArray& ) const;
MyArray& operator=( const MyArray& );
int size() const
virtual elemType& operator(int index)
virtual void sort();
virtual elemType min() cons...Can Function results be calculated?
I have a sheet with two columns of figures. I show the running totals of
each column in cells with basic SUM Functions, at the top of the sheet. I now
want to subtract one total from the other. How is this done? As the Function
is looking at cells that themselves hold Functions, I can't see how to do
this, short of making a longer Function that adds the column contents again
and then subtracts.
So, in summary:
I have two cells with Functions. These are:
Cell F4 =SUM(F8:F45)
Cell G4 =SUM(G8:G45)
I want to do this:
but it won't play.
Any advice most appreciated....Can OfficeX open MS Publisher files?
Does anyone know of a way that OfficeX can open or
translate files created in Publisher? It is the one thing
that I really miss and need when working back and forth
between my G4 and PC files.
On Sun, 28 Sep 2003 15:06:23 -0700, "Natalie"
>Does anyone know of a way that OfficeX can open or
>translate files created in Publisher? It is the one thing
>that I really miss and need when working back and forth
>between my G4 and PC files.
AFAIK you're SOL...
("As far as I know you're shit outta luck")
to open ...Nested If Function to be converted into a user-defined custom function
below formula (nested if formula) WORKS FINE in EXCEL 2007, but it is
not working in 2003 for known reasons (number of conditions exceeding
the limit) .
I now would like to create a user-defined custom function (UDF) in
I know how to operate the VBA Editor but I got no idea how this nested
If-Formula translates into a VBA-code.
Could somebody please help me. Help is much appreciated. Thank you
very much in advance.
Below formula (nested IF-Function...scanost can not open file
I used to be connected to a Microsoft Exchange Server & therefore my Outlook
works off an .ost file. However I no longer work for that company so I cannot
link to the Exhange Server. However my .ost file has become currupt some how
& I've tried running scanost.exe directly by going through program files, but
it will not let me run it as it says that Outlook is not closed or some
program that uses Outlook is running & therefore will not scan the .ost file.
Has anyone a idea of what I can do please?
If you are no longer connecting to the Exchange server, w...How can I list active OWA users
We have two front end Exchange servers running Exchange 2003. I need to list
the active OWA connections on each server. What is the best way to do this?
Thanks in advance
MikeC <MikeC@discussions.microsoft.com> wrote:
>We have two front end Exchange servers running Exchange 2003. I need to list
>the active OWA connections on each server. What is the best way to do this?
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
Don't send mail to this address mailto:firstname.lastname@example.org
Or to these, either: ma...Publisher 2002 , WXP and printer orientation
We had to run a recovery disk for Windows XP, reinstall
Publisher 2002, and drivers for a Brother MC1500C printer.
It previously printed fine. Now the Publisher docs. will
not hold a landscape, legal orientation. It will not show
correctly in printer preview. It prints so far and cuts
off. However the layout page will show the information.
We reinstalled both current drivers and publisher and it
still does it.
Andrea <email@example.com> posted:
> We had to run a recovery disk for Windows XP, reinstall
&g...Create form that can't be chg'd but info can be copied/pasted?
I've created a template & protected cells but I want to move data around, can
I link info, or create form that the data lays on top of, etc.
...What problems can occur if a student database is not maintained?
I am doing a homework assignment, and this is not covered in the book. When
using Microsoft Access 2007 to create databases, why is it important to
maintain that information? I regards to the topic question, what problems can
occur if a student database is not maintained?
Maintenance usually means adding new students and editing the information
for students already in the database.
You can imagine what would happen if this was not done.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"Danyel" <Danyel@discussions.microsoft.com> wrote in message...How to convert a Chinese registry value from within a US code page?
First of all, our Win32 MFC VC++ app is not written in Unicode as it should
have been. Given that - it reads uninstall information from the windows
Uninstall registry tree and writes it to a report. It writes out the
displayname of the application.
Normally this is not a problem, but when it encounters a Chinese application
name, it displays the name as question marks. I assume this is because the
string is in Unicode in the registry, but our app is not Unicode so it can't
represent the characters.
Unfortunately for the moment, converting this very large app to Unicode is
not an o...Can I protect Livemail on laptop with a password ?
I "download" all my email from Yahoo server and work with it under Livemail
Laptop is going for a warranty repair - I will have to give the repairer my
windows user password which means they will have access to my livemail
messages, contacts ec - can I further protect my email in any way while
laptop is out of my hands ?
"Croz" <Croz@discussions.microsoft.com> wrote in message news:DCD9FA83-09D0-430C-AE26-4AA406D488CD@microsoft.com...
> I "download" all my email from Yahoo server and work with it under Livemail on laptop.
> Lapt...How can I shutdown Outlook 2003 from the command line ?
I maintain my PST files on an encrypted volume, which is locked for backup
purposes as long as OL is running. I have batch file that I run my backup
routine from, but I need to shutdown Outlook before doing the backup so I
can then dismount the virtual voume and backup the volume file.
How can I shutdown Outlook from the coomand line ? KILL seems a bit
drastic, scared it will leave things a mess.
There is no command line option, but this WSH/VBScript file might work.
Set objOutlook = CreateObject("Outlook.Application")
Set objOutlook = Nothing
...Can not open entourage
Operating System: Mac OS X 10.5 (Leopard)
I have been unable to update Office for the Mac 2008 for months so today I took Microsoft's advice and uninstalled and then reinstalled Office. Unfortunately, now when I attempt to open Entourage I get "This identity can not be opened with this version of Entourage." <br>
I have tried uninstalling and reinstalling and don't know what else to try. <br>
> This message is in MIME format. Since your mail reader does not understand
this format, some or all ...Can I use VBA to add cells (over blanks) then do multiplication
I have a Word table in which the last column contains numbers (3 and 4) and
some bank cells and I want it add them and put the total into the second last
row (7 in this case). The last row contains a multiplier (3) which when
applied to the total results in 21. Below is the table.
| | | 3 |
| | | |
| | | 4 |
| | | 7 |
| | 3 |21|
How can I achieve this in VBA (under Word 2003 and 2007) remembering that
the user can add rows to the table and the last column can contain blank
Thanks in advance for any assistance,
Sub ScratchMaco(...can't populate a combo box with value
Maybe it's just impossible, but here is what I'm doing:
I've got a combobox called cmbCompany. It's Unbound and its rowsource
is 'qryRowsourceCompanies' that is:
SELECT Countries.CountryName, Companies.CompanyName,
FROM Countries INNER JOIN Companies ON Countries.ID =
ORDER BY Countries.CountryName, Companies.CompanyName;
I've set the BoundColumn to 6 so that I can instantly get an ID of a
Company the user chooses. But I'v...How can I sort "oldest to newest?"
I have a little spread shee with a column called "date" that contains dates
in a "*3/14/2001" format. That's what I see when I highlight all its cells
and click "format cells." I'm accustomed to sorting by clicking on the
column header and then the "sort xxx to xxx" icon. Five minutes ago I did
this and was offered "sort oldest to newest" and "sort newest to oldest"
menu items. I don't know exactly what I did after that, but now when I try
to do the same thing I'm only offered "sort A to Z" an...How can I reduce the file size of my Word Form?
I hope this is posted to the appropriate group. If not can you please tell
me where I should post this question?
I have a form with some protected sections that is seventeen pages long.
The protected sections contain a lot of tables with calculated fields.
Before it is filled in the file is 5.48 MB. After it is completed it can be
much longer and grow exponentially in size. I have received calls from staff
members who say the file grows so large that it takes a long time to save
(five minutes at times), sometimes Word crashes and they have a hard time
attaching ...How can I resize/restore the File > Save As window?
Somehow I have managed to expand the File | Save As window such that it now
fills the whole screen. This only affects Excel (2007).
There is no minimise button, and I cannot see the bottom RH corner to grab
it and resize the window and I cannot get hold of any edge of the window to
How can I resize/restore the File > Save As window?
Try double-click on the Title Bar
Gord Dibben MS Excel MVP
On Fri, 4 Dec 2009 16:18:15 -0000, "Chris Mitchell"
>Somehow I have managed t...