Convert .txt and .xls to .qif ?
How can one convert .txt and .xls to .qif format?
My old bank statements are in .txt and .xls format and MS Money only
recognizes .qif format...
In microsoft.public.money, Dilip Asarpota <Dilip
>How can one convert .txt and .xls to .qif format?
>My old bank statements are in .txt and .xls format and MS Money only
>recognizes .qif format...
Didier has a nice set of links of conversion tools at
http://xl2qif.chez-alice.fr/xl2qif_en.php describes XL2QIF, Didier's
Excel to QIF addin, ...printing publisher file
I am having trouble printing a file conversion from publisher to adobe. The
page printed will only print the top 30% or so. The print range selection of
either "all" or "current view" doesent seem to change the outcome.
thanks for the assistance.
Assuming you mean that you are converting a Publisher file to a .pdf file,
which program are yoiu using to do the converting?
MVP Microsoft [Publisher]
How to ask a question
"carman3758" <firstname.lastname@example.org> wrote in message ...Importing Outlook 2003 file into 2002
Trying to import my Outlook 2003 pst file into my laptop
which runs Outlook 2002 and it does not recognize the
file. Appears that Outlook 2003 is not backwards
compatible with Outlook 2002.
Any suggestions besides installing Outlook 2002 on the
laptop (would prefer not to do this for various reasons)?
In Outlook 2003, use the File->export->Data Management File. Select the
Outlook 97-2002 version and export your items to that format. Then, copy
that file to your Outlook 2002 system (wherever you want) and then use
Outlook->File->open to access the items.
Milly Staples...Can't open XLS file
When I double-click on the XLS file, empty XLS will open and following
message is displayed:
“Windows cannot find ‘document name’. Make sure you typed the name
correctly, and then try again…”
The only way to open my files is to 'drag and drop' them into an already
Thanks for any advice
I bet you could open excel and do File|open to open those workbooks, too.
Sometimes one of these works:
Tools|Options|General|Ignore other applications (uncheck it)
--- or ---
Close Excel and
Windows Start Button|Run
Windows Start Button|Run
excel /regse...Converting text to numbers, but not blank cells
Hi, I've got a large survey data-set in Excel 2003. Some values are
pure text, some are numbers but were recorded as text. There are also
many blanks in each collumn.
So, I am trying to convert the numbers from text format to a number
format. I know the basic tricks (=VALUE(), or Type 1, Copy, Paste
Special--> Multiply + Value). The only problem is that all of them
convert a blank into a 0. I really need to keep the blanks as blanks.
Does anyone have a trick or a macro that would make sure that blanks
remain as blanks when converting text to number? Thank you!
If you copy an empty cel...re-combining multi-part files (.dat)
outlook split a large PDF file into 4 parts on send. how
do i re-combine them?
thanks & happy new year
Outlook doesn't do this on its own - are you using Outlook or Outlook
> outlook split a large PDF file into 4 parts on send. how
> do i re-combine them?
> thanks & happy new year
...Pocket PC two files???
I have a file which contains my personal accounts and such. I also have a
file that contains the accounts for my grandparents. Is there a way to sync
both files onto my Pocket PC using Money 2004 ? It would be nice to switch
between each account.
From the Money for Pocket PC Readme:
"To change the deskop Money file that you are synchronizing with, you
must select the new file from the Money synchronization Settings
screen found in ActiveSync Options on your desktop PC. Simply opening
a new Money file on your desktop PC will not alter which file your
Pocket PC synchronize...Can you FTP a file/data directly into Excel
Has anyone ever FTP a file/data directly into an Excel worksheet from
At present I manually FTP these files when they are created and dro
them onto my hard drive then i export it into Excel for processing
This is becoming very time consuming as the number of files are growin
did you try data(menu bar)-get external data-new webquery
remove $$$ from email addresss to send email
TDR <TDR.email@example.com> wrote in message
> Has anyone ever FTP a file/data directly into an Excel w...Saving A publisher file to CD-R or CD-RW
My mentor used MS Publisher to write a book and saved it on his
computer's hard drive. He was trying to save it to CD-R and CD-RW but
for some reason the E: (CD) drive kept saying that the file was 'read-
only'. But the read-only attribute was not selected in the file's
properties. Also when he tried the 'Save as' feature, the File type
automatically selected was 'Publisher Files'. And again, if the file
wouldn't save on a CD-R or CD-RW because it kept saying 'read-only',
then would using a Flash Drive/USB PenDrive help to save the publisher
do...Word 2007 won't open files on double-click in Win 7 in VMWare
I am running Word 2007 in a Win 7 64-bit virtual machine. It is running quite
nicely with one exception: if Word is not running and I double-click any Word
document (or try opening any text document using Open with...), then Word
starts up and gives an error: "Unable to send command to program." If Word is
running, double-clicking any of the above opens fine.
I have tried the following:
- uninstalling Office and re-installing it -> no result
- formatting the computer and re-installing everything -> the error returned
after one or two uses of Word and Outlook
S...Help, Quicken convert -trouble with Online Transactions or Setup
System = Money 2003, Window 98SE, Logging in with Passport.net
When I installed, Setup, Migrated my Quicken file (which all went well) The
installation asked me to choose my financial institutions (which I did) it
saw all my bank accounts and enabled them for online access.
The Problem is:
Each accout has a different user name and password (and it has to be that
way because of the way my bank does it). So when I set it up, I used the
User/Password for the Account I use most frequently. Now when I "connect to
bank" using that accout the call summary says "success...Open and Convert Mac .numbers to excel file format tools
Are there any tools that allow PC user of Excel to open a Mac .numbers
extension file? firstname.lastname@example.org
...Pivot table converts data to a 1,2,3 how do I get data to correct
I created a pivot table from a range of customers (deposits). Tha data range
counted the number of entries per customer and not the dollar amount. How do
I format the data range to reflect the dollar amount not the number of
Right-click on the 'Count of Deposits' button in the pivot table
Choose Field Settings
From the 'Summarize by' list, select Sum
> I created a pivot table from a range of customers (deposits). Tha data range
> counted the number of entries per customer and not the dollar amount. How do
> I format t...how do i covert publisher 2000 file to publisher 2003 file
I have publisher 2000 files made with mathtype and canvas. Publisher 2003
will not convert,i.e. open many of the files. What is the solution?
Are you certain the Publisher 2000 files are Publisher files and not Home Publishing?
Mary Sauer MSFT MVP
"CEO Stellaris Consulting" <CEO Stellaris Consulting@discussions.microsoft.com> wrote
in message news:CEE1E4D3-883F-4C58-9D81-68CDF9F79F44@microsoft.com...
>I have publisher 2000 files made with mathtype and canvas. Publisher 2003
> will n...HELP!!!! priv1.edb file corrupt
my exchange 2003 server will not allow me to mount the
store, i get "internal error, restart imformation store
service and retry"
I put exchange onto a different server and populated the
new machine with the users mailboxes, i attempted to copy
the priv1.edb file into the new server, but users don't
have access to the messages within that database, users
can send and receive messages but all folders, messages,
contacts etc from the old server are not accessable and
the mailbox store shows 2 accounts for each user, one
account with the new mailbox info and one with the o...file handling
I need to access a user-defined data file (say, txt type) in my application,
known data type and unknown length. With serialize(), I can only write fixed
number of ar>> and ar<<. Could anybody tell me how handle it? Thanks in
If it is line based text take a look at CStdioFile, ReadString and
"Rich" <Rich@discussions.microsoft.com> wrote in message
> I need to access a user-defined data file (say, txt type) in my
> known data type and unknown length. Wi...sending image file attachment
what are some ways to send image files to reduce the load. I know how to
compress the folder. But are there other / additional ways to modify the
files to reduce the load?
> what are some ways to send image files to reduce the load. I know how to
> compress the folder. But are there other / additional ways to modify the
> files to reduce the load?
E-mail is NOT a reliable file transfer mechanism. It wasn't intended or
designed for that. It was designed to send lots of small messages. There
is no CRC check on the file to ensure integrity. Ther...Keep report page setup when converted to PDF
I'm using ReportToPDF to convert my reports to PDF files for emailing and I
was wondering if there's a way to preserve the local report page settings
when it's converted to a PDF. For example, most of my reports are formatted
for Legal paper with Landscape orientation. When I convert them to PDF, the
PDF file page setup is Letter/Portrait and so in order to fit all contents
on one page when printing, I have to manually set the page to
Legal/Landscape. Is there some way to preserve the Access report settings
in the converted PDF or am I S.O.L.? I'd appreciate any help...Can't defrag .pst file O2003
Defrag won't defrag one of my .pst files. I've run scanpst twice (errors
first time, none second). I've compacted the .pst file. File size just
under 5 GB. Free disk space 20.5 GB (55%). Does anyone know something else
I can try?
Is Outlook closed when you do this? A bootdefrag will work. Diskkeeper is
capable of doing this.
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe ....eml files in outlook express
My Outlook Express is removing what it calls unsafe
attachments. The attachments are .eml files. I am sure
they are safe as they come from close associates. How can
I change it to allow these attachments to be opened? I
use XP Pro and the newest versions of OEE and IE
Tools-> Options-> tab Security-> option Do not allow attachments...
Note that this is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the link for the right forum
http://communities.microsoft.com/newsgroups/default.asp?icp=InternetExplore...Recording music to file
How do I record music or speech (I assume through the microphone input) to a
Thank you for your help.
"Erik" <email@example.com> wrote in message
> How do I record music or speech (I assume through the microphone input) to
> a file?
> Thank you for your help.
Plug a mic into Mic In, download Audacity Free, set your sound card to Mic
In. Press the Record on Audacity and Record. The Save Project As.
Or us windows sound recorder. See this info:
htt...PDF Files created from Word 2007
If I save a file in PDF format and send it to someone as a n attachment, will
they be able to modify it if they have adobe software. If so how do I make it
so they can't change the original document
On Mar 5, 6:48=A0pm, Techtrainer <Techtrai...@discussions.microsoft.com>
> If I save a file in PDF format and send it to someone as a n attachment, =
> they be able to modify it if they have adobe software. If so how do I mak=
> so they can't change the original document
One way to prevent editing is to print o...Win2K3 SBS - Drive C nearly full
Windows 2003 SBS all MS updates
Drive C: 40GB with 5GB remaining
RAIDED 250GB hard drive with Drive D: remaining Gigs
In the Windows C:\ClientApps\ directory there are a lot of *.cab files (some
ie4 some ie6 etc. like in C:\ClientApps\ie6). I have IEv8 on the server and
it's been running for about 1 year or so. Can I delete these unneeded *.cab
files without any negative implications on my Windows 2003 SBS system?
Do you have an Exchange Server on the C drive. If so, are your logs on it
also, or on another drive. The reason I ask is that an Exchange Server, over
t...Opening file causes bogus err msg that file is already open
I'm running XP Home on a new eMachines box & running
Office 97. Whenever I open an excel file (for instance
foo.xls on my desktop), an window opens up that says "A
document with the name "foo.xls" is already open......
After I click OK, everything seems to work fine.
Same kind of thing happens with Word & Wordpad files
although the error message in those cases is slightly
different (i.e. "C:\...\foo.doc is being used by XYZ. Do
you want to make a copy?)
This drives me nuts. Any deas whats going on?
This are the usual things to fix th...Money 1999 to 2004 file transfer
I want to transfer my Money file from a Money 1999
program running on a Windows 98SE machine to another
machine in a home network that came with Money 2004 (from
Dell). I have gone through opening the Money files, both
on floppy and via the network. My Computer shows large
files under Money 2004, but nothing comes up when I open
the files within Money 2004. Am I missing a step or
Tough to say because despite all you wrote it's tough to tell what you are
doing and what is actually happening.
Use you network to copy your .MNY data file from the Win98SE/M99 machine to...