.qfx file in excel
my bank for some reason will only allow me to download my statement in a qfx
file (quicken) but i dont have any quicken programs i use excel to manage my
finances how can i open this file up???
If the bank does not have .text (.txt) or comma separated variables (.csv),
which would probably be listed as spreadsheet format, then
I would complain to the bank.
Meanwhile you could copy and paste from your checking activity
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: ....mdi Files
Operating System: Mac OS X 10.5 (Leopard)
I have some .mdi files (generated at work with some lab software). They seem to open okay on my work PC. Is there any way that I can get Office 2008 and a MAC to recognize / open these?
No, .mdi is a Windows-only format exclusive to the Microsoft Document
Imaging program... Even other Windows apps can't read or create them.
If you can get them into a Windows box open them in MDI & then Save As TIFF
to get a format that can be opened by graphics apps or inserted into other
documents as a picture. TIFF files are ...Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save
records, where as the system administrator is able to save the same
information. Please advice on this error, what has to be done.
I have disabled the windows user ID of the Database owner. Thinking of this
made Dynasa as the DBO.
Database is having enough free space available.
How big is the company database? Is it over 10GB?
"Matthews" <Matthews@discussions.microsoft.com> wrote in message
> GP Ver 6.0. Recently I...extension DLL problems
I have CPropertySheet class with three CPropertyPage" classes in an
I compile it, and run it. I get the .LIB and the .DLL files etc.
in the client application I incluce the .LIB file and then I have add a
button which when
pressed will attempt to run the following code:
CPropertySheet myWizard("Import wizard", this, 0);
this code produces the following error:
"Debug assertion failed!"
what is to be done?
> I have CPropertySheet class with three CPropertyPage" classes in an
> e...Unable to start up my Excel files
One of my users have this odd issue with his Excel 2003. He's unable to
start the files directly but instead he must start a blank excel sheet then
open his files from there. Is there a solution to this issue?
Dell 170L P4 800mghz 1gbram
Windows XP Pro SP2
Office 2003 SP2
Could the problem be that he cannot open files by double-clicking on them
from Windows Explorer, but must open Excel (which will launch a blank sheet)
and then open them directly from there using File / Open...
If so then tell him to try Tools / Options / General / untick 'Ignore Othe...File password override
I'm trying to restore a backup file. Money is asking for a
file password. I enter the password that is appropriate for
the Passport account used to lock the file, but Money will
not accept that.
I wonder if this file has a seperate file password and if
so, I have no memory of what it may have been. Is there
some way to reset it? Is there some other way in to this file?
Though I sympathize with your problem, I certainly hope there's no back
door. If there is, I'm going back to paper records. I shudder to think
that a hacker could conceivably get an older backup file an...Book1
C:\Program Files\Microsoft Office\Office10\XLStart\Book1.xl
mdalby's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=705
View this thread: http://www.excelforum.com/showthread.php?threadid=26311
The template should be named Book.xlt, not Book1.xlt.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"mdalby" <firstname.lastname@example.org> wrote in message
>...opening .dat Accounts Receivable file in Great Plains for DOS
We are trying to retrieve some information from a posted accounts receivable
report... We think its in a .dat file but have no way of opening... This
anyone know if this is possible...
Any help or suggestions would be greatly appreciated!
Can you be a little more specific? What version of GP, what report, what
"Carmine" <Carmine@discussions.microsoft.com> wrote in message
We are trying to retrieve some information from a posted accounts ...Creating a duplicate lead
Am I right in assuming there is no way to create a duplicate lead from an
existing one? I'm asking because I have multiple people within the same
company - would like to add a second lead without retyping all the address
info, etc., that would be exactly the same.
check out the free c360 Clone utility:
It'll do what you need.
> Am I right in assuming there is no way to create a duplicate lead from an
> existing one? I'm asking because I have multiple people within the same
> company - would ...csv-file problems with different regions
I have imported an American csv-file into a German Excel XP. The American
$-values are separated by a "." while the German currency values are
separated by a ",".
So now my spreadsheet reads a value of $ 18.01 as 18. January. All values
above 18.12 are ok.
How can I avoid this problem? Or, can I change the values tediously one cell
after the other? I have not found a way yet as even when I try to format a
cell user defined it automatically changes to the format used in the German
Temporarily change the regional settings on your computer to the same f...File set up query.
Can i set up an excel file to open automatically on pc start up?
The easiest is to use the Startup folder available in the Start Menu. To
access it go to Start - Programs - Startup. You can delete or add tasks here
according to your needs. They will start after Windows logon.
When you start Excel, all the files that are located in the XLStart folder
are automatically opened. Additionally, if you specified an alternative
startup folder for Excel, every file in that folder is also automatically
opened. To specify an alternative startup folder, in Microsoft Excel 2002 or
Microsof...Sorting file list by date/time...
does anybody have an idea how to program a sorting function given a
directory with files, which should red to an array which is sorted by date
and time, but contains only the filenames.
Is there a MFC function or a shell function of the OS which could ease the
job instead of doing it manually?
On Mon, 16 Apr 2007 16:39:50 +0200, "Diana Bulthaupt"
>does anybody have an idea how to program a sorting function given a
>directory with files, which should red to an array which is sorted by date
>an...Creating company wide calendars
I need your help.
I am testing Exchange 2003 and would like to create a
shared calendar that everyone in the company can access
for company events.
Is it possible and if it is, how do you create such a
Thank you for your help.
Yes, create a Public Folder for the calendar.
Microsoft Exchange MVP
"Demetrius Samaras" <email@example.com> wrote in message
> I need your help.
> I am testing Exchange 2003 and would like to ...Can I access the previous version of a saved file?
I overwrote an excel file by mistake, using the save as command to an
incorrect file. Is there any way to recover the previous file before I
"saved as" over it?
I'm using Excel 10 (XP)......WinXP.......
If I have an existing file and open it, make some changes, then do a SAVE AS
and give it a different name, the newly "saved as" file is a completely
*NEW* file and the original is still in tact with the previous file name.
Try looking for the previous file name.
"JCC" <JCC@discussions.microsoft.com> wrote in message
news:9CAD1748-1D5C...how to edit Adobe file
how to edit Adobe file
Most certainly not in Word.
pdf files, I'm assuming that is what you mean by 'Adobe files', are 'fixed'
files. Their layout is frozen so they look the same on any machine and can
not be edited.
If you still want to edit such a pdf file, you will have to convert the file
to something else, edit it, and then save the result back as a pdf. The best
tool to do the conversion of pdf files to Word documents is probably Acrobat
Professional. Unfortunately, that is a rather expensive product to use for a
few simple conversions. There are ...Creating signatures but leaving them optional
Hello -- I've just had to re-load my operating system and then Office (and
The way I used to be set up, I had a signature that I could include in an
outgoing email message by going Alt-I-S (and then I think the first letter of
the name of the signature). In more than half my emails, I don't use a
signature, but in others, I have a standard signature I want to include. So
I'd like to be able to include the signat ure with a simple key-stroke
combination, but otherwise leave messages unsigned.
I can't figure out how to do this now -- if I create a signature, i...Creating EMAIL Message -- Font is blurry to recipient
Once I send an email that I create in publisher the text appears blurry to the recipeint. Any one have any ideas how I can eliminate this problem
I am using Verdan 8pt font and i have converted it to a web publication.
Hi JV (firstname.lastname@example.org),
in the newsgroups
|| Once I send an email that I create in publisher the text appears
|| blurry to the recipeint. Any one have any ideas how I can eliminate
|| this problem?
|| I am using Verdan 8pt font and i have converted it to a web
Is it blurry only to this particular recipient? What does it loo...Replicating Formulas between excel files
Does anyone know how I can replicate formulas (verbatim) between difference
excel files? I've tried to cut and paste between the separate files, but to
my dismay it makes a reference to the original file.
The best procedure depends on how many you're trying to copy.
For one or two, you can select the *entire* formula in the formula bar,
right click and choose "Copy", then hit <Enter>.
Now you can navigate to wherever you wish, and Paste it as many times and/or
places you want.
For numerous formulas, *unformulate* them by replacing t...move files and prompt user if file already exists in target filepath
I have the following code that moves files between folders.
Unfortunately, already existing files get overwritten if the new
filename is the same. Is there a way to prompt the user in case the
file would already exist and to abort the copy kill operation?
here's my code:
Private Sub Command9_Click()
Dim strNewName As String
Dim strOldName As String
Dim strtargetfilepath As String
strtargetfilepath = DLookup("[Draft to Active]", "filepath")
strOldName = Me.Filename
strNewName = strtargetfilepath & "\" & Me.Name1
FileCopy strOldName, strNe...Want to hack the recently used file list max entries
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Would anyone care to offer a hack method to get the recently used file list to show more than 9 entries? No use telling me it can't be changed. I am asking for the "Yes" people to answer.
OK, yes... The first thing you need to do is contact Microsoft & ask them
for the source code. Seriously, there is no user option other than the
setting provided in Preferences. If you want to see a longer list use the
'Recent' page of Project Gallery from the file menu. On its Customize page
...Outlook 2007 cannot open .pst file
I just installed Outlook 2007, then moved older outlook pst files
successfully into my new Outlook.
However, I closed it and then restarted it. It claims that it cannot
open the Outlook.pst file anymore.
In trouble, need any and all input as to how to fix it; other than
completely reinstalling it. I will loose some new email that I
Which method did you use to reconnect your older pst-files? "Moved it" is
not a valid action nor does it describe exactly what you did.
The proper way to reconnect...Excel temp files in network dir
I have users that are accessing a network shares to their
excel files. I often see files that are 8 characters long
Ex(D8710B20) and without extensions, left over in their
dir. I have read MS article 814068 and understand that
these are created during the save function; however, i
have ruled out permissions and antivirus as the cause.
These files consume a lot of network space. Any guidance
would greatly be appreciated.
"les" <email@example.com> wrote in message
: I have users that are accessing...XML file extensions
I have a machine with Excel 2003 Pro installed. Whenever I create an XML
file in any directory on the hard drive (created from SQL Server Database via
Visual Studio) the XML file is automatically converted to an Excel 4.0 Macro
file. It is then no longer recognised as an XML file.
It would appear that somehow XML files are associated with Excel
automatically. Can I turn this off?
Ignore me, I coded the file extension as XLM by mistake - which of course is
an Excel 4.0 Macro!!!
> I have a machine with Excel 2003 Pro installed. Whenever I create...Trying to open a Publisher file from School
At school kids have PUB 03 or 07 file they created and at we have Home PUB
00, we cannot open their file? Am I out of luck?
Dad of 5 wrote:
> At school kids have PUB 03 or 07 file they created and at we have Home PUB
> 00, we cannot open their file? Am I out of luck?
Microsoft Home Publishing and Microsoft Publisher are two completely
separate, different, and unfortunately similarly-named applications.
Their filetypes are incompatible.
Ed Bennett - MVP Microsoft Publisher
Dad of 5 wrote:
> At school kids have PUB 03 or 07 file they created and at we have...Problem in saving Date and $ field in Excel to CSV file
We just copy and paste data from MS Access 2003 to Excel 2003.
When we save the Excel as CSV file, we find that the date has been converted
to American format. We have checked the Regional Settings and Australia is
used. Is there any language setting in Excel ?
Moreover, on another machine, we are able to save to non-American date.
However, we find that for monetary field, most of them are quoted - Like
"$2,000.00" but some are not quoted - like $580.00. Your advice is sought.