Opening a unicode CSV file from Excel
I'm currently working on an application that can export data in "CSV"
format, and then launches Excel to view the CSV data. This works
perfectly ok for ascii data.
However now I have upgraded our application to use Unicode I'm running
into problems. When I export data into a unicode CSV file and launch
excel with it's path on the command line I get a "This is not a
recognized format" message. If the same file is opened manually from
Excel the same error is shown but afterwards the text import wizard is
displayed (which works ok).
Currenly the file is 16 ...How do I add a line chart to a stacked chart?
I have 3 series as a percent in a stacked chart and would like to plot a line
in dollars through the the different stacks for each quarter - any help is
plot he dollar amount series as part of the stacked chart
on the chart select the new data set and
change axis to secondary
got to <chart><chart type> and select the line chart you want.
Play with the formating to make it ddo what you want.
> I have 3 series as a percent in a stacked chart and would like to plot a line
> in dollars through the the different stacks fo...Combining MS Money files
Is there a way to combine/merge MS Money files (not accounts, but files) into
one file that will display all acounts?
You will have to mentally designate one file as the master file and the
export accounts from the other file to qif file format. Then import the
files all together (use ctrl + click to select when asked which file to
import) into the master file.
Take backups of both files before you start!
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I ha...Outlook Issue #7
I am using Outlook2003SP1 with Exchange 2003.
When I first start outlook and open either a message or a calendar
request when I press the button(s) or select from the menu any of these
functions; send, reply, forward, reply to all, accept, decline, print,
permissions, follow up, previous, next basically any function nothing
happens. The only things that seems to work is the close, change font
and move to folder buttons/functions. Once I close the item and open
it up again everything works. I have to do this for either messages or
calendar items. I have tried creating a different mail prof...mutimedia messages coming to inbox without attached files
Sending a picture from my phone to email. I use Outlook 2002 to read and send
emails. Message arrive but not the attached picture. My phone company email
site recieves the picture without any problem. Is there a setting in
OUtlook that is stopping the picture?
...Must buy new computer...Ideas?
Hello to all! Finally my over 10-1/2 year old Dell desktop's extreme
slowness has seriously gotten on my nerves and I'm now looking for a new
one. (Surprisingly, it's working pretty well otherwise...)
Maybe this isn't the right forum? But beside the usual things like RAM and
HD GBs, are there things I should be sure to have...or be careful NOT to
have on a desktop? After n ot looking into computers for over a decade I
feel like a Martian in the Earth. lol!
Also, is it possible to transfer to the new one ALL my stuff, including
programs, etc.? Do you thin...Sending Data from One subForm to another
If I have 2 subForms on a form
subFormA and subFormB and each field has 2 text boxes , what code do I need
in my control to send tbA and tbAA to subFormB , tbB and tbBB
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3
On Thu, 14 Jan 2010 11:39:14 +1300, "Bob Vance" <firstname.lastname@example.org> wrote:
>If I have 2 subForms on a form
>subFormA and subFormB and each field has 2 text boxes , what code do I need
>in my control to send tbA and tbAA to subFormB , tbB and tbBB
Step ...Home loan recurring bill one month behind
I have a home loan setup in money 2008, and the associated monthly payment
is a recurring bill, this was done using the normal loan setup wizard.
When the payment clears the bank on say on 10/31, and the upcoming bills
shows that 10/31 is the next payment, and I try to match a transaction with
this downloaded transaction, the available transaction list shows only the
9/31 transaction, but the 9/31 transaction has already been reconciled.
Thus the home loan monthly payment matching is always one month behind.
To work around this I have to click on the recurring payment and select
enter t...Need Help Adding Line to Bar Graph
I�m working on a bar graph with 2 series of comparable data � firs
series is YTD @ Current Month, second series is Current Month. I woul
like to add 2 lines to show the system (or overall) average of bot
series. (x-axis=co region; y-axis= score)
How do I do this? I do not want a trending line. I just want
straight line to show overall average. Right now, I�m just drawing
line on the chart but I would like something that will adjust t
updated data. Any help is greatly appreciated
jcstoddard'...I used "save as" but now can't locate original file
I was using a file (November), changed the data, clicked "save as" (December.
Now, November is the same as December. Any possibility there's a temp file of
I believe you have not done as you describe.
If you had a previously saved November workbook open and made some changes
then File>Save As and named it December, November workbook will still be on
your computer in its previous state.
Unless you saved it as November with the changes.
From where did you open November workbook?
It will still be there.
Gord Dibben Excel MVP
On Thu, 1 Dec 2005 1...Default properties for new folders
How does one set the default properties applied when
creating new email folders? Currently, when I create a
new folder, it is created with the AutoPreview turned on
by default. I'd like to change that do that it is left
off by default. It's something of a pain to create a new
folder and then go in to customize it's properties.
You can do this by editing the Messages view; View-> Arrange By-> Current
View-> Define Views...
You might want to define a new view yourself and apply that view on first
use of that folder.
Robert Sparnaaij [MVP-Outlook]
www.howto-o...Need to Transfer Files Between Money and Quicken
I've got an interesting problem here. I need to transfer files between Money
2002 and Quicken Premium 2004. The first four attempts at having Quicken
read exported QIF files has been a disaster. Quicken is absolutely no help.
Their built-in help is referring me to webpages that don't exist. There is
supposed to be a tool to convert the file format, but the fine print says it
is for converting between previous versions of Quicken and Quicken 2004, but
it "may work" for converting Money files. A Quicken guru says I need to
export Money files to XML in order to bring the files i...New Email Messages
I just installed Outlook 2007 on my new PC and for some reason the new
messages I received can only be received when I press the SEND/RECEIVE
BUTTON. My Outlook at work receives these new mail messages as they are
received. So how can I configure the system to make that happen?
The Trail Hiker!!
There are two settings within the accounts
1) Send on starting
2) Auto send/receive every xx minutes - set this for 10 minutes
"hiker0531" <email@example.com> wrote in message
>I just installed Outlook 2007 on my n...Line Graphs #3
Is there a way to shade the area between two lines in a line graph, while
leaving the rest unshaded?
Yep, try this:
Jon Peltier, Peltier Technical Services, Inc.
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
"SecretaryII" <SecretaryII@discussions.microsoft.com> wrote in message
> Is there a way to shade...restoring system data from external HD .bkf files
My OS is Windows XP Media edition 2005. I recently reformatted my HD and now
I am trying to restore my Office Outlook files (.pst) plus system settings. I
have been only able to access personal files and folders. I really need the
..pst files. When I run the backup - restore wizard the check marks appear on
the two "C" drives, out of 14,471 MB on the external HD, only about 350 MB
are restored, the field "processed" reads "0" How can I restore the rest of
my system from the external HD?
On Thu, 27 May 2010 14:53:4...Prevent new comments on old posts in sharepoint blogs
How do I stop comments on certain posts in a SharePoint blog?
I have removed permissions to the specific post to the lowest possible
access and people can STILL post a comment. If I uncheck one more item in the
list of permissions, the users can no longer see the post.
...Unable to open "New" window to write email.
I am using Microsoft Outlook in Office 2003. It has been working great until
When I click "New" to write a new email I get an error window :
The messaging interface has returned an unknown error. If the problem
persist, Restart Outlook.
I have tried this several times, even restarted the computer to no avail.
Anyone have a solution????
...Stop SPAM from unresolvable email servers
I continually receive spam mail from servers that are unresolved
through DNS. We are using Exchange Server 2000, and I have selected
the setting "Perform reverse DNS lookup on incoming messages".
However, I still receive email like the one shown below...
Microsoft Mail Internet Headers Version 2.0
Received: from mail.nelsotech.com ([192.168.0.1]by mail.nelsotech.com
with Microsoft SMTPSVC(5.0.2195.6713);
Tue, 28 Feb 2006 15:28:45 -0500
Received: from -1214789064 (220.127.116.11) by mail.nelsotech.com via
How do I stop these emails? They are unresolvable and I would like to
proh...Money 2007 file wont update from one computer to another
Ok, I have a desktop with Vista and laptop with XP home. I use the notebook
when Im away at work and the Vista desktop when Im home. When I got home I
wanted my money file from the notebook to be transfered to the desktop
but... when I copy the file from the notebook to my external USB HD and then
paste it to the desktop to replace the existing one the file does not
reflect changes made on the file version on the notebook. When I copy the
file from the notebook to the USB HD and then open it it shows one balance.
but when I then paste that file to the desktop it shows a different balan...New Location/New setup
Currently I'm downsizing our office, and moving to a new location. I'm
running MS Server2003 as well as Exchange 2003. Once moved, I will no longer
require the server (since I am setting up a home office).
Are there currently any steps or procedures available to correctly shutdown
one office...and basically setup a home office with no exchange server.
Also I will be removing the current pc's from the Domain, and setting up a
few in a workgroup.
I would like to receive emails from the other employees for time being until
I completely cancel this email account. I already have a...A Short Video on Adding/Editing New Customers
If capturing customers at the POS is important to you, take a couple of
minutes and watch this video. This application also allows for edit of
Global customer information in HQ installations.
Contact us for detailed info and demo.
It would be nice if you could encode the videos with a more common codec,
and not in wmv format. This requires the GTM3 codec (GoToMeeting). Windows
Media Player 11 doesn't automatically download the codec, and I'm not going
through the trouble to download and in...Looking for Microsoft Office Binary File Format or File Signature data
I have an application which obtains numerous "unidentifiable" files
with no file extension, via FTP, and would like to run some sort of
binary filter on it to identify PPT, DOC, XLS file formats.
I did fine this: http://www.garykessler.net/library/file_sigs.html
But it seems a messy way of accomplishing this, and is incomplete. Any
clues as to finding the binary record format and/or file signatures of
Office documents (Office 2000 and greater).
...How do I activate the new mail button
When I start Outlook, the "New", "forward", "reply" and "reply to all"
buttons are not active which means I can not send mail. I have no problems
receiving mail. Also, on web pages with email links, when I click on them,
the Outlook application is not launched which is almost certainly related to
this. I think I'm missing something very simple here!
Are you in a mail enabled folder? Do you have an active email account
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert...Cannot Open 2002 Files in 2004
USA Money 2002.
Moved 2002 files to flash drive and tried to open them using Money 2004 and
I get this message "Type your password to access your files." The friedn I am
helping does not ever remember using a password. I guess the only option is
to use the Money 2002 program on the old hardrvie and see if that will allow
us to access the file.
The most typical case is where you are trying to switch regions.
Your second option requires that Money 2002 be installed. This sounds like
you are trying to upgrade a computer. BTW you can have multiple versions of
Mo...Create an Entity and Publish- issue
I am trying to create and publish a custom entity thru SDK.
The entity is created, however while publishing it leads to an
exception[“An entity contains two views with the same name. Remove one of the
views and try to publish”]
PFA Sample code which I am Executing.(Same Example of SDK).
I would appreciate, if you could help me with this issue.
// Create the entity.
EntityMetadata timesheetEntity = new EntityMetadata();
timesheetEntity.SchemaName = "new_timesheet";