how do I create qif files from Excel for import into Quicken?
Want to import a bunch of financial data that's in Excel into Quicken.
Can I create a QIF file from Excel?
You'll need a converter utility for this. Here's a google search that might
> Want to import a bunch of financial data that's in Excel into Quicken.
> Can I create a QIF file from Excel?
See if http://xl2qif.chez.tiscali.fr/xl2qif_en.php
suits your purpose. Don't forget to back up the folde...Difficult Excel Question
I am doing a VLOOKUP, but when you select the sheet you wish to look at, I
would like the name to chance depending on a name supplied by a cell. If
anyone can solve this, please e-mail me
(remove nothere from the email address if mailing direct)
wrote in message news:8BDA5D08-0AD1-43D2-A572-58900081D412@microsoft.com...
> I am doing a VLOOKUP, but when you select the sheet ...DISTRIBUTION LIST #15
When I open one of my distribution list it comes up on a properties menu with the names listed but I can't make any changes. All the other list I have work fine. Any help would be appreciated.
...WinDbg: Unable to get verifier list
I've been attempting to get to the bottom of a recurring BSOD crash
happening on my system. I've already had 4 crashes so far over the past
two weeks. So I've identified that NTOSKRNL.EXE is involved in all of
them so far. It always somewhere in the stack. So I enabled Driver
Verifier on NTOSKRNL, as well as HAL.DLL, NTFS.SYS, and FLTMGR.SYS which
were also identified on the stack during various of the events.
Okay so I had my latest crash yesterday, and it occurred on NTOSKRNL as
well. The Verifier was already enabled on the system prior to this
crash, and then wh...Excel Tool Bars
Lately, when I open Excel, the top Excel name bar and the bottom tool bar are
not on the screen. It appears that the worksheet is too large to be contained
on the screen.
Can't tell from your description, so just trying to grasp at straws..
-- are the toolbars floating, if so drag to correct position so the become docked
Applies to toolbars but not the name box and address bar.
-- do you have problems in other applications, i.e. Display settings, screen resolutions
-- is the zoom control at 100%
-- What happens in Full Screen mode and in restore (buttons upper right...using excel from dotnet
I'm working on a new app in vbexpress 2008 using acad com interop
Also need to write extracted data to excel.
At home(laptop) i have excel 10. At the office excel 12.
(both seem to have excel5 listed in refs.)
I need to work at both locations.
can i reference both 10 and 12 in the same vbproj (i think not)
can i just reference 5 and is that just an older version with common (but
not the latest) interface?
i guess i can just have 2 vbproj files (one on laptop one at work) and just
copy the .vb class files that are being edited back and forth, not cop...Remove a document from a workspace in Excel 2007
I have a user who created a workspace and included a file that he now wants
to remove from the workspace. Is there a way to remove one file from a
...Can I use Free Excel Viewer 97/2000 in Windows XP?
Microsoft downloads doesn't list the free excel viewer compatible with
Windows XP. Is there a free download to view and print excel spreadsheets,
that's compatible with Windows XP?
The Viewer for Office 97/2000 works fine under Windows XP.
Gord Dibben Excel MVP
On Fri, 22 Oct 2004 15:11:01 -0700, "Linda" <Linda@discussions.microsoft.com>
>Microsoft downloads doesn't list the free excel viewer compatible with
>Windows XP. Is there a free download to view and print excel spreadsheets,
>that's compatible with Windows XP?
An...how to use outlook w/o exchange server?
Trying to use outlook and cannot send/receive email. error msg 0x8004010F. I
work from home, have no employess, no need to share address book. Just
trying to use it w/ a new PDA I have. The exchange server appears to be a
fee based service - I don't know. I just want to use Outlook to schedule my
appts, keep contacts and use email.
SMScott <SMScott@discussions.microsoft.com> wrote:
> Trying to use outlook and cannot send/receive email. error msg
> 0x8004010F. I work from home, have no employess, no need to share
> address book. Just trying to use it w/ a new PDA ...recurring meetings 03-26-10
How do I transfer ownership of a recurring meeting on my Outllok calendar?
"Janet Hi-Stat" <Janet Hi-Stat@discussions.microsoft.com> wrote in message
> How do I transfer ownership of a recurring meeting on my Outllok calendar?
You can't. You must delete the existing event and the new owner must create
Brian Tillman [MVP-Outlook]
...Excel 2000/2003 conflict
Whenever I try to open excel files created using 2000, 2003 gives me
errors on simple formulas. For example, a SUM formula is marked as an
error and displays a wrong number, when I go up to the formula bar and
hit enter without changing the conents it recalculates to the right
answer. There is many more errors such as "inconsistent formula" or
"lost visual basic project" which doesn't allow a 2000 file open
without repair. Is there anything I can download to fix all of this
together or will I have to fix them all by hand? Does this have to do
anything with the differen...Unable to run excel macro after changing file name
After changing the filename in an excel macro, receiving Error number 5 -
Invalid procedure call or argument when users with excel 2000 run the macro.
Users with excel 2003 are not having this issue
Post the line of code that is causing the error.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"merf" <email@example.com> wrote in message
> After changing the filename in an excel macro, receiving Error
> number 5 -
> Invalid procedure cal...Change the Default Global Address List
I need to change the default global address list to show only users and
contacts from my domain. Is it possible to change the default global address
list? Nowadays, The default global address list shows users from my domain
and many contacts from others domains.
thanks in advance.
i have the same situation. i'm trying to figure out how to make another
global address list with enternal contacts. if you figure it out, i would
love to hear about it:)
> I need to change the default global address list to show only users and
>...compare information from two spreadsheets or excel sheets
Don't know if any one can help, I am trying to find an easy way to compare
data from one spread sheet to another on Excel 2000. Every week I create a
spreadsheet and need to find out if any further items added on it.
example old spreadsheet would be called Andrews 19.04.2010 with 3 sheets 4
columns on each. The new one would be Andrews 26.04.2010 same set up again
but possibley new items on the Andrews 26.04.2010
Add a fifth corresponding column on the NEW sheet and insert the following
formula in the first cell:
=SUMPRODUCT((OldSheet!A:A=A1)*(OldSheet!B:B=B1)*(OldShee...Seam-Excel error when exporting file
When I export an excel file from a website the file exports with the file
name of 'seam-excel' and I can't format the cells or create a pivot table
without saving and re-naming the file. How can I get my file to not export
with that file name? Is it a security setting?
Have never heard of this problem being generated through Excel alone.
I would suggest the source would be at the website from which you are
Can you post a URL?
I'd like to have a look just out of curiosity.
Gord Dibben MS Excel MVP
On Fri, 12 Feb 2010 12:41:01 -0800, fallou...Installing components for Microsoft Excel XP
I Need Help.
I recently demoted my PDC to a standard server and joined
another domain. Now when I attempt to access Excel I
receive the following:
"Installing components for Microsoft Excel"
Installing: "Microsoft Excel Feature"
It runs and then goes away but it does this every time I
open Excel. How do I get rid of this message. I really
don't want to re-install Excel.
Things I have done.
1. Copied the old user's profile to the new one.
2. Move the Application Data...Create/Update Excel Objects in Power Point
I developed an add-in in Power Point 97, 2000, XP and 2003 for creating
Excel charts/tables and being able to update them. The code I used is
Dim PPT_CHRT As OLEFormat
Dim PPT_SLD As Slide
'ADD a chart/table
PPT_SLD.Shapes.AddOLEObject Left:=var_chrt_L, Top:=var_chrt_T,
Width:=var_chrt_W, Height:=var_chrt_H, ClassName:="Excel.Chart.8",
Set PPT_CHRT = PPT_SLD.Shapes(var_SHP_count_no).OLEFormat
Set PPT_SLD = ActivePresentation.Slides(var_SHP_SLD_no)
Set PPT_CHRT...Looking for FAX software FREE TRIAL
This is slightly off the NEWS topic, but I have spent 4 days searching this.
I desperately need to fax something and have no options. I had fax stuff on
my PC, but that PC is gone.
I have an iMAC OS 9.2.2 and a good Epson scanner... but no fax software for
is there any FREE TRIAL software for my system that is FULLY FUNCTIONAL TO
Please help as soon as you can...
Thanks in advance,
You'd be best off searching the web via google or somesuch, though someone
may come along with a suggestion. Try different combinations of varying
phrases, here's ...How do I create a command from a list box
I want to select an item in a scroll list or drop down box and by selecting a
specific item in that list have excell proform a different function. For
example: I have a list of numbers that each represent a discription. I want
to select the number from the list and have excell paste the description for
that number in a different box. I want each different number to have a
You could use Data|Validation and =vlookup().
Put the list in sheet2, column A. Put the description in sheet2, column B.
Then if your cell is A1 (of sheet1), you can put this in B1:
=if(a1=&qu...Comparing two excel files
I work with large data in excel. Most of the time I need
to match two different worksheets. Both worksheets always
have two columns that contains same data (name & ID). What
would be the best way to match names and ID to obtain a
new file with data that couldn't match? if Excel good to
do that or should I use other software like Access? please
Look at Chip Pearson's page on working with Duplicates and Uniques
Alexandra <firstname.lastname@example.org> wrote in message
news:1091601c3f335$a...Change listbox text size in Excel 2007
Using data validation list box function to display a named range,
How can the text size be increased when displayed in the list box,
How can the number of records displayed be increased from the default
This can not be done. See link for further detail and possible workarounds:
*Remember to click "yes" if this post helped you!*
"Maxwell Crompton" wrote:
> Using data validation list box function to display a named range,
> How can the text size be increased when displayed in ...address list of 2 domains and 2 exchange servers
Hi all... I`ve just installed my second domain and the second exchange (all
2003). Everything is working, even trust relationship.
Now I want my users of domain1\exchange1 to see the address list of my
How can I accomplish this? Should I create a offline address list? Use ADC?
I`m using W2k3 Standard, so I cannot use IIFP.
Hope someone can help me..
Are these in separate AD Forests? If so you will need the Identity
Integration Feature Pack. If not then they should already be sharing a GAL.
"Fernando Mantovani" <email@example.com...How do I create a hyperlink to a web page in Excel?
How do I create a hyperlink to a web page in Excel?
I click on Insert/Hyperlink. Click the on the "Browse the Web" button and
slect a web site. After creating the hyperlink, I am unable to open the
hyperlink. I get a error message box saying, "Unable to open. Unable to
locate Internet server or Proxy server".
Try copying the webpage address and pasting it into a cell. With the cell
selected, press F2 and Enter and it will create the hyperlink for you. HTH
Sincerely, Michael Colvin
> How do I create a hyperlink to a web page i...my first excel experience (share portfolio)
although i have had excel on my laptop for years this is the first
time i have ventured to use it. i am trying to do a stock /share
portfolio, so i can tell at a glance my positions, so far the layout
a6 buy/sell, input b6 amount buy,input
c6 amount sell,input
d6 name stock/share,input
e6 epic code,input
f6 buy date,input
g6 sell date,input
h6 purchase price per share,(bid)input
i6 sell price per share,input
j6 sub total [=h6*b6],calc
k6 buy commission �,input
l6 sell commission �,input
m6 stamp duty tax,=((h6/100)*b6)*/0.5 ,calc
n6 total co...copy scanned documents to excel
Hello, please help, I recieve a lot of documents in paper and I need to input
them to excel, i scann them with imaging but it comes out single columned and
that doesnt work for me, what can i do?
Have tried the Text to Column command, under Data? It's function is to
split up data in such situations. If you're not familiar with it, try
following the Text to Column wizard (the screen that appears when you use
Text to Column).
"Malu" <Malu@discussions.microsoft.com> wrote in message
> Hello, please hel...