Exchange Rate on Bank Transfer
Is there a way to modify the exchange rate on a bank transfer in the bank
transfer screen? It seems I have to enter the Exchange Rate tables and modify
the system wide exchange rate. What if the exchange rate for one transaction
is different from that of another (since I have multiple bank accounts)?
You can always change the exchange rate on the foreign currency checkbook
whether you are transferring from or to it. If the exchange rate does not
exist for the date of the transaction, the system will prompt you for a valid
exchange rate depending on whether your exchange rates ar...750 KB file saves 10 times longer than a 900 KB file
We use a spreadsheet in our office that has numerous macros. This spreadsheet is approximately 750 kb. I created another file with no macros that is about 900 kb. The 900 kb file saves enormously faster that the 750 kb file with macros
I spend a lot of time waiting for these files to save all day long. I have tried moving the macros to another sheet to see if that would help - but it only helped minutely. I have no add-ins checked (I saw that suggestion on another post). Any suggestions are hugely appreciated. Thank you.
I've never noticed a difference in time based on if a workbook cont...Box when opening File
Quick question...When I open up one of my saved files,
Visio automatically puts some kind of box (function box
possibly) around my heading and some of the text. I'll
take it off and save and it isn't there. But when I close
the file and then open it up again later it's there
again. I try to delete the box but it deletes my text
with it. I can't resize or delete the box (actually
conjoined boxes) by itself.
Any help would be greatly appreciated. Feel free to
Try changing the line weight of the shape to none.
John... Visio MVP
Nee...Email addresses in a comma-delimited (CSV) file
I am trying to create a csv from another application to be imported into
Excel. One of the columns will contain email addresses. Is there a way that I
can format the data in the column to have the addresses be 'links' when
brought into Excel.
First, hyperlinks are not just formatting. The Insert|hyperlink style of
hyperlinks are objects in excel.
Second, CSV files are plain old text. They don't hold these kinds of objects.
(And they also don't contain any formatting properties, either.)
But third, you may be able to cheat a bit.
Can you go back to the othe...Problems saving excel file from outlook
I have an EU that whenever he saves an excel file from
outlook, it will rename the file (by adding the number "2"
at the end of the file "file2.xls") and it also changes
all the embedding links in the document. (The embedding
link of F:\users\file.xls changes to c:\documents and
Are you setting a Hyperlink base for your links? See Menu
> File > Property > Summary tab. Put the original folder
location there and when you move or save the file the
links will not be renamed. Also assigning a letter to the
drive can cause problems (not ...pdf. file
Someone has sent me an e-mail with a pdf file attachment.
For some reason, unknown to me, I can't open it. Any
suggestions, tips or clues???
thanx in advance
Do you have Adobe Acrobat/Acrobat Reader installed? If you save the file to
your hard drive, can you open it?
> Someone has sent me an e-mail with a pdf file attachment.
> For some reason, unknown to me, I can't open it. Any
> suggestions, tips or clues???
> thanx in advance
do you have adobe reader?
"deb" <email@example.com> wrote in message
news:0...can cvs files be opened using excel viewer
i have a user who cannot open cvs files with excel viewer but can ope
with the full version of excel...anyone experienced this problem and i
so, can you pls post the resolution
darriel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2388
View this thread: http://www.excelforum.com/showthread.php?threadid=37522
There is nothing in the description of the Excel Viewer to suggest that it
can read anything other than true XLS files.
http://support.microsoft.com/default.aspx?scid=kb;...help attaching files
Using XP Pro and Outlook 2003.
For some odd reason, I am unable to attach files when sending emails.
Click on the 'paperclip', window opens to the My Doc folder. then when I
click on a sub folder to open, nothing happens... finally, a Microsoft Word
window opens that it is unable to open....
It is almost as if it is trying to launch Word to open the folder...
FWIW, from the Microsoft side a new Knowledge Base Article (KBA) was
released on Apr 15th.
It lists two known conflicts so far....Converting Eml files to Msg files with code
Sorry if this question is overly simple. I'm developing an integration
project between Exchange and SPS. I read the message on a public folder of
Exchange with ADO. I use ADO's stream object and save the message as a file.
Created file formatted as .EML file and has .EML extension. We want to read
this file in Outlook but it can't open the file. Because of this I need to
format this file as .MSG file. I don't need a tool. I should make this
process in code. Is there any API or code sample. Thanks in advance.
...Transferring contacts from OAB file
I am trying to transfer the entire GAL from a work PC to a home PC.
I copied the oab, ost, and pst files to an external harddrive but have
not been able to open the offline address book in Outlook at home. The
pst opens fine.
Any assistance or ideas appreciated.
Love your attempt in regards to the oab/ost, but take a peek at
<firstname.lastname@example.org> wrote in message
> I am trying to transfer the entire GAL from a work PC to a home PC.
> ...how do I get old versions of modified files?
I made a mistake and modified a file, how do I get back the old version? Thanks
From your backup, which, of course you take every evening !!!
"Power Image" <Power Image@discussions.microsoft.com> wrote in message
>I made a mistake and modified a file, how do I get back the old version?
...Open & update another file (through macro) while running macro
I am using MS Excel 2003 and I need help to solve my problem.
One excel file (suppose A.xls) in which I’ll update my graph and the data is
available in another file (suppose B.xls). What I am doing (through macro) is
that I have created one button (in A.xls) and when I pressed it; its open the
file B.xls (the data file) and at their I select month from drop down from
which its update the pivot table based on the selection month and then same I
was doing with another data excel file (suppose C.xls).
Is there any solution that when I pressed button from file A.xls its ...AOL to Outlook 2003, transfer contacts and favorites, help?
Moving from 7 years of AOL service to a new ISP and using Outlook 2003 now.
How do I avoid having to copy/paste hundreds of contacts one at a time from
my AOL address book to Outlook.
Also have lots of 'favorites' on AOL I would like to keep...
"Jakfrost" <Jakfrost@discussions.microsoft.com> wrote in message
> Moving from 7 years of AOL service to a new ISP and using Outlook 2003
> How do I avoid having to copy/paste hundreds of contacts one at a time
> my AOL addres...Excel Slooooow. It takes 4 to 6 seconds to perform each input or command
Operating System: Mac OS X 10.6 (Snow Leopard)
I have just installed Excel 2008 on a new installation of Snow Leopard and it does not work properly. It takes ages to register every input or command, like a large Lag. <br><br>EG. each figure or text, input into cells takes 4 seconds from hitting enter to accepting the input. Changing the width of a column takes 6 seconds from letting go of the mouse after dragging to the new width. etc etc. <br><br>I have checked for updates. Any ideas?
> I have just installed Excel 2008 on a n...MSN Portfolio Manager #4
HAs anyone else had trouble with Portfolio Manager. all I get is the
Internet Explorer cannot display the webpage
In microsoft.public.money, jack wrote:
>HAs anyone else had trouble with Portfolio Manager. all I get is the
>Internet Explorer cannot display the webpage
See if the first item in
> HAs anyone else had trouble with Portfolio Manager. all I get is the
> Internet Explorer cannot display the webpage
Same issue, ...Can't open Money file directly.
I have Money 2005
I have many accounts at different banks.
I can always open Money by using my password.
I just added a new account & it tried to hook it up with Net.Passport.
Now everytime i try to open my file it wants my Net.Passport.
I deleted the new account,but it still opens with Net.Passport.
I went into tools & selected to remove my accounts from Passport's server.
Still can't open Money file directly.
How can i get it back to just open my account from my PC ?
In microsoft.public.money, desgnr wrote:
>I have Money 2005
>I have many accounts at different bank...Updating .nsf lotus notes server file
Using the below code i can fetch data from the .nsf file kept in the server.
Dim LotusWizard As DAO.Recordset
Dim session As Object
Dim notesdb As Object
Dim notesView As Object
Dim NotesEntry As Object
Dim notesdoc As Object
Dim Item As NotesItem
Dim doccollection As Object
Dim datetime As NotesDateTime
i = 0
Set session = CreateObject("Notes.NotesSession")
Set notesdb = session.GetDatabase("Server", "path\file.nsf")
'Check if open
If notesdb.IsOpen = True Then
...Working with recovered Money files
Does anyone have advice or experience working with Money files recovered
through a complete format restore recovery? I have recovered 68 .mny type
files from a Harddrive that had a PC restore image overlayed on it.
This was MS Money 2007 under Vista Ultimate.
The recovered files are semi-genericly labeled with "Recovered_MS-Money_##"
they just show today's new save date and range in size from 60KB to 23,300KB.
When viewed in Wordpad the largest files have an opening line that says
"MSISAM Database" before the gibberish code begins.
I tried the Money standard r...Disable password protection on .pst files
Just wondering if there is a registry key change or something I can do using
the orktools that will prevent users from applying passwords to their .pst
files. This is at the request of our legal department who is concerned that
users may leave and their case files and such are now inaccessible to
Mary Patricia <rodgers.patricia@> wrote:
> Just wondering if there is a registry key change or something I can
> do using the orktools that will prevent users from applying passwords
> to their .pst files. This is at the request of our legal department
> who is ...Prompt for Save when closing a file
Excel used to prompt me to save my files, and now it is just closing them
without saving them. How do I get the warning to appear again?
...Page header or footer longer than a page. File 794368d5a91da8.rpt.
Anyone seen this before? It only happens when trying to run the report via
the CRM interface. The report ran fine last month. It's a copy of one of
the canned pipeline reports that comes with CRM, with a date filter applied.
Report has no parameters, just a filter. The report runs fine in Crystal.
i saw this a few weeks back and restarted the crystal services to get rid of
Microsoft CRM MVP
"Jeff Metcalf" <JeffMetcalf@discussions.microsoft.com> wrote in message
news:E8B9A1DD-777D-4746-A333-392955F912...Excel attachment file names change on their own!
Using Outlook 2003, XP & Office 2003.
I have to send a bunch of Excel files (typically around 10) to a
supplier every week. They are sequentially numbered (purchase orders)
and the order number is part of the file name.
I attach them and everything looks fine. Then I send them and look in
the sent box and one or two of the files will have renamed themselves
using the names of other files! So if they were numbered 1 to 10,
they would have changed to 1, 2, 3, 3, 5, 6, 7,7, 9, 10 for example.
If you open the attachments, they're fine - depite the name change,
the conten...Allow more than 4 digits for password in online setup
How do I allow for a password that is more than 4 digits,
when I'm doing online setup for my bank account in Money
As it is now, I can only enter the first four digits of my
password, and my bank requires 5-8 digits. Please help!
In microsoft.public.money, bellavoce wrote:
>How do I allow for a password that is more than 4 digits,
>when I'm doing online setup for my bank account in Money
>As it is now, I can only enter the first four digits of my
>password, and my bank requires 5-8 digits. Please help!
I suggest you call customer service at ...Data files
What is the difference between the **.mbf and **.mny files?
In microsoft.public.money, duhmel wrote:
>What is the difference between the **.mbf and **.mny files?
*.mbf is Money Backup File.
You cannot do salv.exe or standard repair directly to a *.mbf file.
...Bank of America and Wire Transfer layout (EFT for AP)
Has anyone created an EFT layout in v10 for the Bank of America - CRFBAFF
Just wondering if it can be done.
I'm not sure about the CRFBAFF interface layout part (I only worked on the GP
layout based on the file specs they provided), but I do have a couple of
clients using BofA for Payables EFT successfully.
> Has anyone created an EFT layout in v10 for the Bank of America - CRFBAFF
> interface layout.
> Just wondering if it can be done.
Thx... they also use EFT and it is a different layout