Money 2007 -- QIF import
After a little trial and error, I am able to import account transactions
from another system (not a bank statement, my actual register transactions)
with little trouble except for the date format.
(Before someone gets mad at me, I really don't think this has anything to do
with my regional settings!)
As recommended by an MVP from this forum, I open my CSV file with excel,
then use a converter (add-in) called XL2QIF to create a qif output file.
The actual "data" in a date field in my original csv file is "060106"
(mm/dd/yy) which is June 1, 2006,...Issue with local named relative range
Thanks to the Excel wizards here, I got some great tips back in
November with creating a way for a cell to refer to itself (e.g. THIS)
or the cell above it in a formula. If the active cell is A2, I can
define a name. e.g. CellAbove, that refers to A1 (no dollar signs =
relative reference). This was a pleasant surprise for me, as I had not
realized nor ever tried to create a named relative range.
However, I've now come across an issue with this technique and I hope
the wizards will assist once again.
It seems that Excel (2003 at least) always places the sheet name in
the refere...why does outlook hang on "send/receive complete" ?
On receiving email in outlook 2003 the send/receive complete keeps going for
up to 10 mins, freezing the page.I had no problems until 2 days ago & have
not changed any settings. Can anyone help?
I would suspect your antivirus might be causing this. See if there is an
update at their site. Also try a Detect & Repair on the OL Help menu.
"Frazzled Granny" wrote:
> On receiving email in outlook 2003 the send/receive complete keeps going for
> up to 10 mins, freezing the page.I had no problems until 2 days ago & have
> not changed any settings. Can anyone he...Deleated important files.
Operating System: Mac OS X 10.5 (Leopard)
I am a complete noob when it comes to mac. Thinking the applications folder was like the "start menu" i deleted everything in the Office 2008 folder that was not something i used. All that is left in there is the .app for word, excel, and powerpoint. Needless to say none of them will open.
The problem is it's a school pc so i don't have access to the office install discs. Is there some way to restore these or will i have to take it to the pc shop to get it reinstalled?
PS: i already emptied the trash =(...Outlook 2002 not remembering password issue
I am using Windows XP and Outlook 2002. Until I had my password
changed on my main e-mail account I had no issues. But after this
Outlook randomly display the pop box asking me to re-enter my password
even when I ticked the box to remember it.
This happens at random times. I have tryed the fix in 290684 - OL2002
The Save Password Setting Is Not Saved When You Connect to a POP3
Server.mht but it didn't make any difference.
The fact that it remembers sometimes then forgets is annoying. Any
ideas or fixes?
...Excel 2003 button issue
hi all, i have a button and when pressed it copies sheets to another external
workbook, the problem i'm having is when i need it to clear the content it
clears the header row. I need it to keep the header row but delete the
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Set wb1 = ActiveWorkbook
Set wb2 = Workbooks.Open("\\Business Objects\CHR\Export of SGUK.xls")
Set ws = wb2.Sheets("Sheet1")
ws.Cells.ClearContents 'i think this is where i'm going wrong.
Help would be greatly appreciated.
One way is to use the...How do I import a WORD file into EXCEL? #2
I'd like to import a WORD table to Excel but when I go to "Select Data
Source", only other EXCEL files show, not my WORD files but the Help function
indicates that all files should be showing. I've selected "Text Files" from
the Data Source; I've tried "All File Types" with no luck. Anybody have a
clue for me? ..signed, an Excel Idiot......thanks!
File>open and select all files or copy and paste
"MauiMama" <MauiMama@discussions.microsoft.com> wrote in message
news:27741FDC-23BA-478D-98AC-21760...Problem to import folders from old .PST files to Outlook 2003
Have upgraded from Outlook 2002 to Outlook 2003. I had
several Personal Maps (One Map containing the E-Mail for
each previous years, like Outlook2003, Outlook2002, etc.).
When I try to import the old .pst Personal Maps to my new
Outlook 2004 Personal Map (with the new format), the
folders inside each of the Map are not visible, and I am
not able to import any data at all. Is it possible to
create several Personal Maps in Outlook 2004, and how to I
create a new one?
What do you mean by Personal Maps?
Assuming you are talking about Personal Folders (PST files) they are
perfectly compati...Any issues with w2k SP4 and exchange 2000
Not that I know off :)
Exchange 2000 List owner
"Chris Allen" <firstname.lastname@example.org> wrote in message
...importing publisher files
Operating System: Mac OS X 10.5 (Leopard)
I have many publisher 2003 project files I would like to use, but have not found away to import them into office 2008. Any suggestions on how to convert them to a use able format?
> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: Intel
> I have many publisher 2003 project files I would like to use, but have not found away to import them into office 2008. Any suggestions on how to convert them to a use able format?
The conversion has to be done u...Permissions Issues with Public Calendar
Most of the Items from our public calendar were accidently deleted. The
missing were items restored by copying them from a .pst of that was extracted
from one of our backups. Now, we are experiencing several problems with our
1. Users cannot view items when they open the calendar, however if they go
back one month and then forward to the current month, all items are viewable.
2. Users are not able to print any items from the calendar
3. Users are not able to edit or change entries that they originally made;
however they are able to create new items.
I'm assumin...Transation sequence number issue
Happy new year everybody!!
I have a customer with this situation. his invoice must be sequentially he
can't skip a transaction number for his invoices, when a transaction is
aborted a number is skiped. i konw that one is not hard to fix but this is
the main issue when he do a return he need to have a differnt count numbers
than the transactions number for example when he sale something the
transation number 1545 is generated but is he return or do a store credit
the transaction number is 145 without affectin the secuence os the sale
transaction number. can be done?
the other probl...Deserialization issue
I have an XML file like this:
<?xml version="1.0" encoding="utf-8"?>
And I want to deserialize it, so I created a class:
When calling the 'Deserialize' method of a serializer I get an error
"There's an error in the XML document (2,2)".
If I don't use namespaces (whi...importing/exporting categories
Is there a way to synchronize or import/export categories. I have 3 email
clients. 1 desktop, 1 notebook and 1 PDA. I continually have to manually
edit my master categories list on my desktop's outlook so it jives with my
This article was helpful.
"Mike" <email@example.com> wrote in message
> Is there a way to synchronize or import/export categories. I have 3 email
> clients. 1 desktop, 1 notebook and 1 PDA. I continua...Importing Yahoo Yellow Pages Into Excel
Has anyone been successful in doing the above?
You can open the file in excel, then take a look at
to get the two rows into one row.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Carol Harb" <Carol Harb@discussions.microsoft.com> wrote in message news:E3B96450-B4E5-4E3A-887B-B7ACFBB9D514@microsoft.com...
> Has anyone been successful in doing the a...Literally displaying imported cells with <HTML> and <BODY> tags
I'm exporting contents to excel from a web application. Each row looks
"3101" "American Express" "Fort Lauderdale" "FL" "Deployed" "Windows
<B>IMPORTANT:</B> We have updated server. You must click the button
again to receive your account information.
More text goes here
However, when the file is opened in Excel only the text in the last
column is displayed (the tags and all the o...Importing Emails from an Exchange Email box
I am currently (manually) importing emails into my DB.
I am only importing the following fields from each mail item:
1) Receive Date
I would like to automate this process with code - so that the user click a
button and the fields above are imported into a table called 'Daily Results',
with field names the same as 1,2,3 and 4 above.
Can anyone advise of how to do this? I thought MS Access had an 'Import
Builder' where these setting could be saved, and recalled when required (like
a Macro) but I cannot seem to find this.
Any help would be...Large txt file import macro
I asked a longtime ago for a macro to allow large text
files to be imported over several sheets within one work
book, this worked great, however my machine has been
rebuilt and I failed to keep the macro,
can some nice person please supply a link again .
The usual code is below.
MS Excel MVP
Dim ResultStr As String
Dim FileName As String
Dim FileNum As Integer
Dim Counter As Double
'Ask User for File's Name
FileName = Application.GetOpenFilename
'Check for no entry
If FileName = "...How to remove the Mods imported into GP and where to look for; to rename these?
This is a multi-part message in MIME format.
Hello All, Happy X-Mas & Holidays
I wonder if some one could help me on this
a.. How to remove the Mods. imported into GP. I see that these can me =
imported and exported but what if someone need to remove those?=20
b.. Also, where to look for in GP Folder/Directory in case some need =
to disable these by renaming them.=20
c.. Mods. mean Modified menus and screen through modifier or VBA
-----...Outlook 2003 mail folder layout issue, all mail folders
I would like to set a default mail folder layout or view that will apply to
all mail folders. In Outlook 2003 when I click View | Arranged By | Current
View | Define Views, highlight IMAP Messages (my e-mail account is an IMAP
account, not an Exchange mail server), click Modify, makes my changes in the
'Customized View: IMAP Messages', such as:
Fields: Subject, Flag Status, From, Received, Size, Attachment,
Group By: None
Grid line style: No grid lines
[ ] Show items in Groups
How do I make Outlook 2003 ...How can I import SQL Compact on platform builder of wince 6
I wanna install SQL Compact on my device which is running wince 6.
First time after installation SQL Compact .cab files downloaded from
Microsoft website "http://www.microsoft.com/sqlserver/2005/en/us/
compact.aspx" applications using this instance of SQL running
My problem starts after restarting my device.it seems that after
restarting my application can not load SQL Compact DLLs printing this
"Can't find P/Invoke DLL sqlceme30.dll"
private void Form1_Load(object sender, EventArgs e)
string conne...import from Excel #3
Setting up new Money 2007 Home & Business install. Have current accounting
in Excel spreadsheet. Can this data be imported?
On 2006-11-13, MarkB <firstname.lastname@example.org> wrote:
> Setting up new Money 2007 Home & Business install. Have current accounting
> in Excel spreadsheet. Can this data be imported?
You could try converting the file with something like this:
NOTE: I have never used the above program. I don't know how well
...import from outlook express #5
I have Outlook 2003, I just tried to use it for the firts time and started by
importing my Express contacts. The help menu says to go to the File menu and
select import and export, but this choice does not appear there or anywhere.
DL <DL@discussions.microsoft.com> wrote:
> I have Outlook 2003, I just tried to use it for the firts time and
> started by importing my Express contacts. The help menu says to go
> to the File menu and select import and export, but this choice does
> not appear there or anywhere.
Did you create a mail profile? Did you define an account? W...Tracking issue
I have my mail set up so that I get a read receipt for all
messages, the emails I keep I take out of sent items for
full tracking. I wanted to start using the send office
document feature. (going to "new" underneath file in
outlook) When I send this type of email I still get read
receipts but when I go into sent items the tracking doesnt
record. There is no tab or anything. Is this how it works
or do I need to enable somthing?
...import outlook personal folders #2
How do i copy MO Outlook Personal Folder from saved disk to my actual Outlook
jelmann, you wrote on Mon, 23 Mar 2009 06:36:01 -0700:
> How do i copy MO Outlook Personal Folder from saved disk to my actual
Copy it to your hard disk and open it via
File | Open | Outlook Data File
MVP - MS Outlook
If from a cd, once on HD, select properties of the file & remove the read
"jelmann" <email@example.com> wrote in message