Inserting photos in the MS Exel
I almoast complete my application that includes inserting photos in the
document. Som photos happens to be large that makes Excel file too fat and
Excel eventualy copaps.
Below is rutine I use to insert photo. I wonder if there may be any
modifications that insereted photo will be reduced to 200 dpi when inserted.
This is possible when photo is inserted manualy. I do not know how to make
this automatically... I mean in the code.
Another solution may be to check size of phto that is about to be inserted
and to denay users to insrert larger photos than 150 Kb??
Any help is much...Why Money
Can anyone give me a good pitch on why I should use MS
Money for my small business. I was wondering about quicken
or paying out for Quickbooks but Microsoft money seemed
like a good option also. I am not so full of business that
my accounts are so aloof, but I do want a good program. So
if MS Money is a good choice than which one should I get??
Small Business Edition-I'm assuming you're in the US?
"CWatters" <email@example.com> wrote in message
> "misslemike" <misslemike@msn....History/Activity-NTEXT Field
Ok, here's the deal, and lets see if it get broken here when I past it in,
1. Try to view cirtain customer's history and get sql error (soap exception,
you know the one that really doesn't tell you anything).
2. Look at customer's "History" by using advanced find to find all the
3. Notice that one of the activities has it's 5000 character NTEXT Field
filled with what appears to be a "copy/paste" from an outlook e-mail, to
which I can open just fine.
4. out of sheer desperation of trying to figure out what the problem is, I
wen...IS there a way to compare 2 excel files
I like to be able to compare 2 excel files to see how different they are.Is
there such a thing?
Now imagine how totally different two excel files can possibly be. The
report would say ... ?
But if you have two pretty similar sheets, try Myrna Larson and Bill
Manville's "Compare", downloadable from
HTH. Best wishes Harald
"PeterM" <firstname.lastname@example.org> skrev i melding
> I like to be able to compare 2 excel files to see how different they
> there such a ...Corupt excel file ???
I have a excel file that seems to want to open, but then when it is done
opening, There is no data or blank sheet. It goes though the possess
and say's at the bottom ready opening but then there is nothing and the
screen look's like I just opened Excel but no spread sheet. I then can
go to file open another sheet and it works. (Not the one I wont) any
body help. of coarse we don�t have a backup??? Email:
Message posted from http://www.ExcelForum.com/
First, check to see if the file is actually loaded.
Click on Window and see if it appears at the bottom o...File Handle not being released with FileInfo.LastWriteTime
From an ASPX page I am trying to access the System.IO.FileInfo.LastWriteTime
property of a file on the web site.
The problem I have is that image file types; e/g/ gif, bmp etc; are not
being released from the FileInfo object. If I access a page that reads the
LastWriteTime of an image file; I cannot then update the file on the web
server, until the app pool recycles.
The same is not true for the text files; e.g. css, js; the FileInfo object
is releasing these files.
I have tried the garbage collector against the FileInfo object instance; but
this did not work.
Using t...Unable to open .xls file
I have Windows XP Home edition on my computer and I received an email with
some info that is an .xls extensoin. I have Windows Worksheet and wanted to
know how, if I could, look at this file? I also receive info with >pps
(powerpoint) and am unable to open these files also. ANy suggestions?
You may not have MSOffice. It's not part of Windows. It's a separate suite of
But MS does make a viewer for excel:
and one for powerpoint:
http://www.microsoft.com/downloads/details.aspx?Fa...Import Excel Data from another workbook or file
Is there a way to import or export Excel Data between 2 different workbooks?
E.G. Import from "File A" 'Sheet1' Column A, Row2 to "File B" 'Sheet1'
Column A, Row 2.
What I'd like to do ultimately is import data from 5 excel files into one.
|| Is there a way to import or export Excel Data between 2 different
|| E.G. Import from "File A" 'Sheet1' Column A, Row2 to "File B"
|| 'Sheet1' Column A, Row 2.
|| What I'd like to do ultimately is import data from 5 excel files
|| in...empty pivot table fields
How can I force a pivot table to, for example, say that there were no
accidents in week 2. At present it says 3 in week 1 then jumps to 2 in week
3. I want week 2 =0 for charting purposes. -thanks
Right-click on the Weeks field button.
Select Field Settings
Add a check mark to 'Show items with no data'
> How can I force a pivot table to, for example, say that there were no
> accidents in week 2. At present it says 3 in week 1 then jumps to 2 in week
> 3. I want week 2 =0 for charting purposes. -thanks
Excel FAQ, Tips & Book...OL 2000 .pst file moving to new computer
I am trying to export a OL 2000 .pst file running under
Windows XP with SP 1. I want to export or save the file
so I can open it up on my other computer using Outlook
2000 under Windows 98. When opening the outlook.pst file
on the computer with Windows 98 I received the following
message - "File access is denied; You do not have the
permission required to access the file C:\WINDOWS\Local
outlook.pst." I had exported that outlook.pst file to a
CD and then copied it into
WINDOWS\Local Settings\Application Data\Microsoft\Outlook
...formatting of txt file
Can anybody can help me in in formatting the below data for me
The below data is coming in a txt file and i need the data in a excel file
However when i put in excel i am not getting any structured form
I need the Reference mentioned against the numeric value in the separate
column as heading and the data below should come below the heading. I have
tried, but i have to a lot of manual edit after formatting.
12/2 main street
City - bvauisdbc
Pin code- 1100154
oihbvis...File Menu button is now an icon
I succeeded in changing File Menu to the Excel Icon and have no idea how I
did it or how to get it back. The result is that a left click on that icon
will bring up the Restore Menu and a right click will bring up a seriously
abbreviated File menu. Two commands I use quite a bit are Set Print Area and
Clear Print Area and neither are present on this abbreviated menu.
It sounds like you're still using xl2003 or below (not xl2007 with the new
If that's true...
I'd try this first.
Rightclick on an empty spot on any of the toolbars.
Cho...Display lists in an arbitrary number of columns
I have written and posted the following articles which will prove useful =
Display Lists in Columns Horizontally Using One Cell per Column
Display Lists in Columns Horizontally Using Individual Cells
Display Lists in Columns Vertically Using One Cells per Column
Display Lists in Columns Vertically Using Individual Cells
...Script to count duplicate lines in a text file
We have a requirement to count the number of duplicate entries in a text file
and then list the line and the number of duplicates. For example, we have a
file call test.txt that has the following entries:
This would return the following:
Any assistance would be greatly appreciated
> We have a requirement to count the number of duplicate entries in a text file
> and then list the line and the number of duplicates. For example, we have a
> file call test.txt that has the following entries:
...MnyBank : Ofc Ofx file conversion and Money import
Version 1.5.9 : bugs correction on Qif files
Money 2005 do not accept any more Ofc files and the Ofx files delivered by
my bank where invalid. So I write this program, it can be use to :
- convert QIF, OFC files to OFX V1 (Money 2000->Money 2004) or OFX V2 (Money
2005, XML files)
- convert OFX V2 files to OFXV1
- check transactions in files before send them in Money
- archive bank transaction in a database (MS Acces format)
This program is a freeware.
It's a dotnet program, you have to install :
1- Framework .Net 1.1
2- MS Jet 4.0
3- MDAC 2.7 or greater
GUI is in englis...Executing change event with out tabbing off from a filed (DEX or VBA)
A field in a GP form, I have my cursor in that field. When I enter
data in to it, I need to split that string and insert the splitted
string in to two text boxes
(I will not be doing tab off from the field).
String which will be entered : 111112
I need to split the string into two strings
string1 : 11111
string2 : 2
As soon as data entry is done the splitting should happen (to string1
and string2). And string2 , ie 2 should be inserted in to a field say
If I enter data and do tab off from the field it is working fine. The
requirement is ,as soon as data is ente...Display Non Inventory description on Create Purchase Orders screen
Display the item Description for non-inventory items on the Create Purchase
Orders screen. Currently, only inventory item descriptions are displayed.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrow...Delete jpg file based on Access field contents
What would be the best way to have access delete a bunch of jpg's?
I have two tables in mdb format, the main table has 36000 records. When I am
done with a record, I move it to a Deleted Record table (using a query and a
macro). There are about 1300 of the deleted records that have an associated
jpg file. The file size is around 100k, so I have around 130 meg of files
cluttering up my laptop. I will never look at the jpg's again. I know it's
not a lot of space, but why not have some code get rid of them?
So, should I use a button on a regularly accessed Fo...Money for Singapore
Is there a version of Microsoft Money that is for Singapore? Or does
Microsoft have such plans? If not, which country's version will be suitable
...Done With M$Money
That's it for me. I will no longer submit to the bi-annual upgrade extortion
racket. There are simply too many other viable personal finance products out
there that don't sunset features/operating system support.
Don't be a lemming!
What alternatives do you have in mind? And what are you doing with your
existing data set?
"belexes" <email@example.com> wrote in message
> There are simply too many other viable personal finance products out
> there that don't sunset feat...File Transfer using vb.net code
I would like to transfer/move a file from one folder to other folder in shareopint site. That needs to be done using vb.net.
Could you please prove the code for that?
Submitted via EggHeadCafe - Software Developer Portal of Choice
Dr. Dotnetsky's Cool .NET Tips and Tricks # 16
So your asking someone on this list to do your work for you? For free?
Sounds like you might want to get some consulting time.
Daniel A. Galant
Imagine what w...Does My Money 2004 have a virus
When backing up money, I get a message stating 'This item has been deleted,
possibly by another application.' This message also displayed in Money 2002
when I backed up my file. Could I have a virus of some sort or does any one
know what's going on here.
I need mo_money
...Money Plus Annual Update?
There was an article over the weekend in the Cleveland, OH newspaper that
reviewed the financial software offerings and said that there would be no
further annual updated from Microsoft Money, thus Money + is that last
Is this correct? Has Microsoft abandoned us?
We noticed that our version of Money+ was purchased in August, 2007 but
apparently nothing since.
There will not be a "formal" annual version but around the time of update
timeouts I expect to see what I will call from want of a better description,
Service Packs. So if there is any added functionality then...Money 04 Trended Items
Anyone know if / how it is possible to either disable, or reset the
"trended items" in Microsoft Money 2004?? It is very frustrating, I know the
program would work if I could clear out all the old numbers from previous
and such. Please help.
You must be talking about trended items in the cash flow forecast?
IIRC from M04, there is a "Customize Cash Flow" link--left side of
page--that allows you to exclude trended items.
"GoodTrouble" <GoodTrouble@discussions.microsoft.com> wrote in message
news:50A34ECA-63D9-4E18-9AB3-8D4C59F49F79@microsoft...Money Small Business 2006
Does the 2006 version of Money Small business support using business
categories in the budget? Also, does the new version support a tax line item
for self-employed health insurance payments?