OFX download of portfolio prices?
Does anybody know of an online portfolio that will allow export of stock
prices by OFX? It would then be possible to import prices into MS Money,
once the tap is turned off. It wouldn't be as good as now, but better than
updating by hand.
I don't know of one but I do know that some folks are investigating this
avenue of attack. One thing that comes to mind for me is writing some simple
screen scraping code--or even something that reaches out to the Yahoo
Finance .CSV download--to generate the QIF. One would have to be very
careful crafting this QIF to make sure it did no ...Excel 2007 Need to permanently change Normal settings for gridlines
I am using Excel 2007 for the first time and find the gridlines delineating
the cells are so faint as to be nearly indistinguishable. I can go into the
cell formatting and modify the normal style, and it is just the way I want
it. But I can't find a way to make Excel remember this and treat it as the
new definition of the Normal style. I don't want to have to redefine Normal
every time I open a new spreadsheet. Someone please help!
The changes you describe are changing the Border color and NOT gridlines.
Go into Excel Options and cl...Esc and exit
I have a single document application that I want to terminate when I press the <esc> key. Is it enough to put PostQuitMessage(0) in the PreTranslateMessage where I test for the key? Or do I need to also use PostMessage(WM_CLOSE) and DestroyWindow() to make sure everything get's removed from memory
PostMessage(WM_CLOSE) (to mainframe) is all you should need. Its going to
prompt for any changes that may be pending if your document has changed. You
will need to deal with it if you dont want the prompt.
Ajay Kalra [MVP - VC++]
"Yasoo" <anonymous...Saving existing Outlook emails
I'm needing to re-format my harddrive and am wondering how
I can save my existing Outlook emails and settings so that
once I have the newly reformatted drive setup I can access
my saved emails and files?
do a search in your hard drive for *.pst... it contains all e-mails and
contacts... in brief, all eggs in one basket. If you have mail rules you can
export them, as you can your mail account(s).
<firstname.lastname@example.org> wrote in message
> I'm needing to re-format my harddrive and am wondering how
> I can ...Changing which database Business Portal points to
If I install Business Portal 2.5 (GP) and point it to our Great Plains
development server with an old Dynamics database, once we decide to
take it live, how do I go back and point it to the live Great Plains
server? Is this something that can only be done during the installation?
Let me preface my response by saying I only have experience with BP 3.0....
In BP 3.0 several tables are created in the Dynamics database to support the
various BP functions. Unless you plan to move or copy those tables you will
probably have to reinstall BP 2.5 in order to have them created.
Our attempt to cop...New mail appearing as old deleted item
When new mail arrives in inbox an old long deleted item appears in place of
the new mail showing in bold as new mail. The real new mail is not visible at
all and is therefore lost.
This problem also used to happen in Windows Mail so I bought Outlook 2007
but it still happens intermittantly.
What do you see in your Unread Mail folder?
"Kate B" <KateB@discussions.microsoft.com> wrote in message
> When new mail arrives in inbox an old long deleted item appears in place
> the new mail...Document not saved #5
I am trying to save a spreadsheet.
Everythgin seems fine excpet for the message "Document not saved"
Why is it telling me this and how can I save my work?
I have tried saving it to different places and I still get the same message.
When you attempt to save a workbook, you may receive the following error
Document Not Saved
This problem may occur when the following conditions are true:
The workbook was created from a template that contained an embedded object.
You have inserted a worksheet into your workbook from...Saving a calculated field
First, yes I have read the threads on storing a calculated field and that it
is bad mojo to do that. However, I have pay data that I calculate and input
to a database and it must be able to be reconciled with our ADP data. So I
need the ability to change and fix the data so it does not change as a result
of recalculations. I have a form with a field that calculates the pay based
on hours and pay rate. I have another field (the "copy" field) next to that
one that has the control source set to the database field. I have set the
default value of that field to be equal to the...Item assign to vendors
Would like to have the ability to mass assign items to all vendors.
IE: When purchasing services such as delivery or installations. These are
service items in the inventory module and are passed on to customers in the
sales cycle. They can be purchased from any vendor so would like to be able
to mass assign to all vendors.
This is particularly an issue when integrating POs and Reciepts.
Christopher L. Mast, MBA
Echelbarger, Himebaugh, Tamm & Co., P.C.
5136 Cascade Rd., S.E., Ste. 2A
Grand Rapids, MI 49546-3728
----------...Changing Titles by a formula
From cell A1:A10 I have standard titles that are linked to
another sheet. I only need to change the office and date
per each title. Is thier a way to do that making the
office and date a formula in another cell?
example of title
ABC Comp, Office 38L Sales as of 6/07/2004
I need to only keep changeing the 38L and date.
Say Office # is in Column 'C'
in cell A1:
="ABC Comp, Office "&C1&" Sales as of "&Today()
----- Heather wrote: -----
From cell A1:A10 I have standard titles that are linked to
...Create interactive pivot table chart based on item selected
I'm trying to remember how to drag a chart object to the top left cell of a
pivot table thus displaying a charted image of the detail item selected. Any
...problem in changing the text of sentences before tables
I am developing a word automation application. In a method of mine, I change
the text of some sentences of an opened word file, but the problem is when I
change the text of a sentence which located before a table, it will be moved
to the first cell of the table. My code is as follow:
void myMethod( long startingSentenceNumber, const char *toBeSearched, const
char *replacement, bool replace )
Sentences sentencesList = m_document.GetSentences();
long sentencesCount = sentencesList.GetCount();
CString replacementCStr(...save as problem
I cant save my excel file
The "save as" option is not eviable. Whats happening?
"From a prior post by Ron DeBruin,
You can reset your menubar to default.
Right click menubar. Customize > Toolbars Tab. Select worksheet
menubar. Click Reset button.
Using VBA Application :
CommandBars(""Worksheet menu bar"").Controls(""File"").Reset
Or the whole menubar
You lost the things you add to the menubar!!"
And one link that offers some sugges...can't change/delete bills and deposits
suddenly one day i realized that when i tried to change a
bill, i could click "ok" but nothing would happen. I
thought it was because i upgraded to 2004, so i deleted
the bills and rescheduled. about 5 of the bills will not
delete either. the error message is: "Money could not
write to your Money file. The operation could not be
performed or another application finished this task before
you. Please try again."
Now some of the newly scheduled bills will not allow me to
change the properties, i click ok but nothing happens when
i edit the series.
I have repaired ...Outlook 2007: When i Save a New Rule outlook Change it automatically...
I have this problem with Outlook 2007. I have 15 e-mails addresses in
my outlook, but i can=B4t create the rules for send all the received
mails to each emails folder.
I want to create a simple rule that move all the e-mail that i get
from "email@example.com" to the folder "Inbox/
firstname.lastname@example.org". When i create the rule, all works fine, i
select the correct e-mail account name, the correct destination
folder, etc... but when I hit the SAVE button in rules window, Outlook
2007 changes the account automatically to another one. Not
automatically...Change Row/Column Height & Width
I know I should be able to automatically set a row height to the max
necessary by hovering the cursor between the 2 rows I want to adjust and
double-clicking, but sometimes this doesn't always work. Why is that that -
do I need to adjust a setting? And is there any way to set it so that if
text is added or deleted the row height would change automatically so thatthe
text fit appropriately?
Set the row format to Autofit and cells to Wrap Text
Gord Dibben MS Excel MVP
On Tue, 19 May 2009 12:14:04 -0700, DaveL <DaveL@discussions.microsoft.com>
>I know I should be ...Changing Functional Currency #4
Try to change the functional currency to Z-CNY.
ERROR = Activity for this currency already exist.
Finance made 2 GL transactions.
Can we remove the transactions (Tools >> Utilities >> Financial >> Remove
History) or (File >> Maintenance >> Clear Data ) then change the functional
Which tables should I remove history or clear data.
Can someone on the board help us?
Once you process a transaction, you are stuck with the functional currency.
I have not seen a table fix for this problem on the board. Consider creating
a new database an...Change default "SaveAs" to *.msg rather than *.html
Using Outlook 03, I regularly need to save emails and prefer to save as
*.msg so the attachments are contained within the one file.
How can you change the default SaveAs command to Save as Type in a *.msg
format (rather than *.html) so the type is already *.msg without having to
use the pull down?
Outlook provides no way to change that.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"TroyB" <email@example.com>...change column name from letters to numbers?
I'm importing a 3rd party CSV file into Excel and then comparing some of
the contents to a printed spec. Each numbered field in the spec
corresponds to a column in the work sheet. I'd like to change the column
headers from letters to numbers. Is that possible?
Tools-->Options, General tab. Check the R1C1 Reference Style.
"Jerry" <firstname.lastname@example.org> wrote in message
> I'm importing a 3rd party CSV file into Excel and then comparing ...Show / Hide items in Pivot Table as required
I am using MS Excel 2003 and need a macro code for show only my selected
items only in a Pivot Table.
One excel table empstatus.xls in which fields are Employee No , Department,
Status, other fields. In status field items are Blank, Leave, Left, Resigned.
I wanted to show only blank & leave based on when I’m selecting a particular
month in my pivot table.
So is there any code to hide all data items of status and only show blank &
...Changing of range (Address) to (Cell)
I have encounter a problem with the use of range
From a recorded macro, it's listed this way
ActiveChart.SetSourceData Source:=Sheets("Trend").Range("A1:M2,A24:M28"), PlotBy:=xlRow
And I edit it to this way
ActiveChart.SetSourceData Source:=Sheets("Trend").Range("A1:M2," & Cells(StartX, StartY), Cells(LastX, LastY)), PlotBy:=xlRow
And obviously VBA compiler won't let me go this easily, it happen to give an "evil-comment" on my source range, May i know how can i solve this
Try this, assuming the...adding supplier to items in PO
When you manually add items to a PO and then select the supplier in the
header the items should be added to the items that the supplier carries if
they aren't already. This would save loads of time adding suppliers to items.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the ...Net change and percentage of change
I have a list of parts that have had price increases. One column has the old
price the other has the new price. I need to show the difference, whether it
is positive or negative and the percentage of the increase or decrease. The
difference is not a problem. The problem lies in calculating the percentage.
I don't how to do that. Can someone tell me?
> I have a list of parts that have had price increases. One column has the old
> price the other has the new price. I need to show the difference, whethe...Date & Time file was last saved
Is there away to display in a cell the date & time the file was last saved?
I know you can do this in word but is it possible in Excel 2002?
Here is an UDF
Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
DocProps = CVErr(xlErrValue)
Now you can use the following formula in one of your cells:
=DocProps("Last save time")
Obviously, the file has to have been saved.
... looking out across Poole Harbour to ...Changing Average Cost GP 9.0 Error
When we try to change the average cost information for an item per the
documentation, (tools >> utilities >> inventory >> change average cost), we
get this message. "Use the Inventory Adjust Costs window to change the cost
of one or more reciepts. The average cost of an item is recalculated when
teh changes are proceses"
We would like to change it without using the Inventory Adjust Costs window
because there are no recent purchases and receipts of the particular item in
Would anyone have any suggestions?
The average cost is the aver...