Code Bloat/Growing Excel files?
...Test file needed quickly
Does anyone know where I can get a very large testt excel file that has a
What I need to do is to run several apps that will "drain" most of my
resources. I need to test another app in how it will handle low resources. I
was thinking someone might have a test file just for this reason. A large
spreadsheet that has a macro doing some calculations, at the same time while
other apps are running.
Thanks ahead for any help or suggestions.
You realize if you fill a cell and then copy it to the rest of the
sheet, it get really big, really fast?
> Doe...FileNotFound returned by Bitmap::Save() when saving to stream
I have a little chunk of code which is supposed to take a bitmap image and
save its PNG encoding into a block of memory. The problem is, I keep getting
a FileNotFound error back from Save(). If anyone has any ideas, I'd love to
Here's the code (more or less) in question; there really shouldn't be much
to it, I would have thought:
Allocate an IStream object to write the data into a global
memory block. We indicate that the handle to the underlying data
will be freed when the stream object is released.
VERIFY(S_OK == ::CreateStreamOnHGlobal(nil, True,
static_c...I cannot send a fax from excel, I always get a line busy message.
I am using win xp and I am trying to send a fax with excel. I go to file
chose print, pick fax driver and then fax wizard comes up, I enter phone
number in wizard and click finish but I always get a line busy message in the
fax monitior, can anybody help me. Thanks , Dan
...ayuda con formula excel
quiero saber se me puede ayudar en eso
praticamente yo quiero una formula da enserir an la celda CANCELLARE
(mira foto para entender)
que quando uno presiona la tecla CANCELLARE se borre todo el contenido
de la linea detras de CANCELLARE o vero ( C9-D9-E9-F9-G9-H9 ) y
trambien se tendrian que borrar en la hoja (tabla de datos ) donde
estan lo mismo valore de ( C9-D9-E9-F9-G9-H9 ) o vero ( A7-B7-C7-D7-E7-
F7-G7 )( mira la foto abajo )
http://img20.imageshack.us/img20/9799/32649272.jp...Excel window keeps changing
I have a weird problem on my home computer while using
Excel. If I don't use the screen for a few minutes, the
Excel window shrinks to about a fourth of its size. So I
have to click it again to either Maximize or resize to
about 90% full size, which I prefer using. It is by no
means a fatal fault, but verry annoying!
...Handling of savings accounts and 401k accounts in the budget
I noticed that Money treats money that I contribute to a 401k account or
transfer to a savings account as an expense. Basically, the more I
contribute, the worse my budget looks. Is there a way to prevent this from
Right now, I exclude transfers to my savings account from the budget and it
solves the problem, however, I shouldn't have to manually do this each time.
For 401k contributions, I cannot find a way to do this.
Why does it show up as "an expense" (what Category???) instead of something
like Transfer Out of Budget Accounts? The 401k cash account sh...what encoding does system.xml.xmldocument.save(string path) use to save the xml document if there is no <?xml... in the front of the xml document?
what encoding does system.xml.xmldocument.save(string path) use to save the
xml document if there is no <?xml... in the front of the xml document?
> what encoding does system.xml.xmldocument.save(string path) use to save the
> xml document if there is no <?xml... in the front of the xml document?
UTF-8 is the default encoding.
Oleg Tkachenko [XML MVP, MCPD]
http://blog.tkachenko.com | http://www.XmlLab.Net | http://www.XLinq.Net
utf8 i suppose would be default
"Daniel" <email@example.com> wrote in message
news:e8#...Unable to save password in Outlook 2003
I cannot seem to save my "network password" for Outlook 2003. I tried
everything I can think of. I tried editing the registry. I use XP. I try
going into Control Panel, go to mail and go thru the process there
and....nothing worked there. I uninstalled Office the reinstalled
it.....nothing! I even went as far as unistalling my internet software,
still...nothing! Someone told me that XP will not save passwords. My
Outlook express works fine. Someone HELP!
I also had this issue in Outlook 2003, but also in indows Live Messenger and
Internet Explorer 7.
I spend hour...Save and save as
I am looking for some help with a macro, I need to disable anyone from
saving a file or save as and also disable the prompt if the close button is
pressed you get an option to save the file then, I need to disable all of
these, also have a pop up box to warn that save as been disables when a user
tries to save the file fro save and save as.
Can anyone help me with this. I am using word 2003
Once you give someone access to a document, you have ceded all control over
it. You can however stop them from overwriting the original file by making
the doc...Background Banking Setup on 2003 Canadian
I have set up MS Money so that I use my .Net passport to
logon. However when I go into File, Password Manager,
Financial Institution Settings there aren't any accounts.
The accounts are setup, online banking is enabled for
them and I have even downloaded transactions manually.
...Excel 2008 hanges when deleting cells or rows
Anyone know of a problem with Excel 2008 hanging when deleting?
I have a large spreadsheet with all my banking history in it
Today after doing a statement download to a .csv and then cutting and
pasting into the spreadsheet I tried to delete a few repeated lines
and got an hourglass. Eventually I had to kill off Excel.
I repeated the cut and paste then did the same delete and had exactly
the same problem. deleting just a single cell does the same.
Next time I saved after the paste, shut down Excel and restarted
again, same problem.
I can navigate around the sheet OK, edit cells OK, but as soon...How can I mark rows in Excel so I can use this information to set.
It used to be so simple when I had used a database in Microsoft Works. Now I
have an XP, had to get my address databases changed to Excel (by an online
company) and I'm not up to snuff on how to work with this now.
I'd like to mark certain addresses so I can pull them out for a partial
mailing. Can this be done in Excel?
I'm a 63-yr-old grandma, no formal training on the computer, have learned
and am learning everything the hard way.
assuming that you have headings (like name / address etc) across row 1
and your data starts in row 2
then in in a column at the end of yo...Dos command for Excel
Is there Dos command to support Excel files?
Molly Kay wrote:
> Is there Dos command to support Excel files?
Well, you can use COPY to copy an Excel file, or ERASE to erase it, but
this isn't what you have in mind, I'm sure.
What are you trying to accomplish?
When I right click to save an image in an email, it will only save as a .bmp.
I need to use it as a .jpeg or a .gif. How can I fix this?
Angi <Angi@discussions.microsoft.com> typed:
> When I right click to save an image in an email, it will only save as
> a .bmp. I need to use it as a .jpeg or a .gif. How can I fix this?
Clear your internet explorer temp file cache.....go to control panel,
internet options, and choose 'delete files'
"Angi" <Angi@discussions.microsoft.com> wrote in message...Accessing Excel files over network
First time here, so go easy on me.
Scenario: Basic Windows 2000 Server based network with
about 20 work stations connections. Server is a DC and
workstations are all running Windows XP Pro. Workstations
are also running Office XP.
Users have deposited common files in a folder on the
server. Because of control measures, these excel folders
and files need to have permissions defined for either full
control of read only access for certain members of the
Eg would be
Folder Full Control Read-only
Folder A Employee 1 Employee 10
...C++ Automation of excel
Where are the constants being used in the xl constants (such as xlPasteAll)
listed that I can use them in VC++ automation code? or is there an include
library that I can pull in to the code?
Thanks in advance.
create your own enum that looks like this:
Look under xlPasteTypes
"Ven" <Ven@discussions.microsoft.com> wrote in message
> Where are the constants being used in the xl constants (such as
xlPa...Excel loses linked workbook
I have an error (or don’t understand the workings of the new version of
excel). I have a workbook G:\2009\Monthly Reporting Working Files\P05\Trial
Balance\YTD Financials.xlsx. This workbook is linked to the period 04 version
workbook (G:\2009\Monthly Reporting Working Files\P04\Trial Balance\YTD
Financials.xlsx). Note it is has the same file name but is held in a
It links to cell D47 of period 4 and then adds current month. The formula
works ok but when I save the document the links get broken and the cells
become a circular reference. I can’t understand why.
I ha..."Unattainable" savings goals
I've learned to mostly ignore it, but it drives me
batty. I have a particular loan with a goal to pay it
off by 7/4/04. The loan balance is 14,000. I have
marked a savings account to be "used for budgeted savings
goals." I deposit $1300 per month into the account which
has a balance currently of $13000. Money 2K4 says that I
cannot reach my savings goal. What can I do to help fix
this? Any feedback would be appreciated!
...Recalculate in Excel mobile?
In Excel on my PC, I can press F9 to recalculate - to re-roll a virtual
dice, in this case. My PDA doesn't have an F9 key, and I can't spot
anything obvious on the menus. Suggestions?
I've now tried creating an ActiveX control - a button that calculates.
Works fine on the PC, doesn't even appear in Excel Mobile. Not really
any surprise, I suppose.
Tools>Option>Calculation tab, Calculate Now?
I don't know Excel Mobile.
Can you record a macro to do that?
<firstname.lastname@example.org> wrote in message
news:1135260390.867070.12353...Text-to-speech in Excel X
I've been reading about Excel X having the ability to "read" text in=20
selected cells. Mac has the capability in Text Edit and the PC world =
a "voice" option under the view+toolbars, but Mac doesn't. Any ideas?
...Saving default tabs
I can't seem to get a change in the default tab setting to
When I reopen publisher the tab setting reverts to .5
which was original default.
I'm I the only person who is having this problem? I'm
using the 2003 verson but had the same problem with 2000.
Why not take the default page, set the tabs you want and save it as a
template with a file name of,
"My Very Special Tabs Settings for Future Files.pub"
(jerking your chain a bit<G>)
Then when you want to create what you want, use your created template file
and when your pub file is what you want, do a Sa...EXCEL #153
EXCELL - CAN ONLY ENTER 15 DIGITS, ENTERING MORE SHOW ZERO'S??
Please do not post with CAPS Lock on it is hard to read and considered rude.
You should check your HELP and look up "specification limit"
these are limitations built in or limitations that Excel must work with.
You should not be using a numeric field for a credit card number for instance
because it is not treated arithmetically, you should be using identification
information at text.
When you enter a 16 digit credit card 'number' the first 15 digits are the most
significant digits and will be retai...Save to unProtect a Document?
Our company has word documents that we use as templates on a fileserver. How
could I protect the documents so that when they open them, they dont make
changes to the server version, but save their OWN version and do what they
First of all, make use of true *template* files (with the *.dot or *.dotx
extension). Also, assign the template files the read-ony attribute.
Microsoft Word MVP
"Chris" <Chris@discussions.microsoft.com> wrote in message
> Our company has word docum...PST file import to windows mail
I have chage my PC and I cannot import the PST outlook file in to my new
windows Mail so far
A error message appaer when I try to import a outlook message.
Is someone have an idea regarding this issue
You need outlook installed and configured on the Vista PC before you can
There is a workaround, assuming the old pc with outlook on is still
You export your mail to outlook express, then copy the outlook express msg
store to the Vista PC, then Mail can import it.
Or you download the Office trial, with outlook, connect your pst as default
to outlook, ...