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...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" <firstname.lastname@example.org> 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...Mouse dissappears in Outlook 2007 B2
Notice an annoying "feature", my mouse will dissappear in Outlook for some
reason and have to drag it off the Outlook window to like the tastbar or
desktop and back again to see it.
Dang, was hoping 2007 would have a universal selection in turning off that
$@%$# GROUP view and READING PANE. I want neither, but have to go through
all my folders (26) to change them to "normal" viewing.
Also, guess Beta testers know this, but the scanpst.exe doesn't work in B2.
Keep getting "procedure entry point DDLUnintInstace@" errors in fixing on
..pst file Outlook ...money file extraction: virus or worm
hi, i opened MS Money 2002 last night, and instead of
starting the program, a screen opened in MS-DOS, and it
started extracting a bunch of files.
then that screen closed.
now the program will not work.
is there a worm or virus targeting people's MOney files?
In microsoft.public.money, travis johnson wrote:
>hi, i opened MS Money 2002 last night, and instead of
>starting the program, a screen opened in MS-DOS, and it
>started extracting a bunch of files.
>then that screen closed.
>now the program will not work.
>i...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...Saving Images
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...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...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
...Money 2007 Home and Biz Budget Question
I've gone through and budgeted each of my individual expense and income
categories in the Savings and Spending Budget. However, under the Committed
and Fun Budget Groups, there is a very large Unallocated balance. I can't
figure out how to get rid of it, or how to backtrack to somehow correct the
problem. The amount is very large and is really throwing my overall budget
and Lifetime Planner completely out of whack.
Any help is appreciated!
The budgeting within 2007 is NOT an improvement from earlier versions. Where
is the option to used the advanced budget? Some of ..."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!
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...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...How to delete task request from inbox on Outlook 2007
For 13.5 months a "task request" from a coworker has been parked in my inbox.
The task is complete and was marked as such but I cannot delete it, move it,
reply to it, forward it, or take ANY action on it without the message "the
operation failed" popping up. Any suggestions on how to clear this would be
The coworker has cleared this on his outlook as well and our IT guy has not
been able to do anything with it either. In fact, nobody in the office has
any idea why my system is unique this way. I've never had issues with any
other tas...why I can't declaring a CArray object in a separate header file?
Hello I have no problem declaring a CArray variable inside a class definition
but as I have a separate file that I place all my typedefs inside it, I have
tried to define a struct that has a CArray member but compiler says:
Error 1 error C2248: 'CObject::CObject' : cannot access private member
declared in class 'CObject' c:\program files\microsoft visual studio
this was my code inside TypeDefs.H
typedef struct tag_compliance_info
} STRUCT_COM...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, ...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...Exchange 2007 And Daylight Savings Time Update
Is there a patch I need for Day light savings time and Exchange 2007?
No CDO patch required (no equivalent of KB 926666). However, the Windows
Server 2003 OS will required KB 931836 time zone update and Calendar-items
in 2007-hosted mailboxes created using old DST 2006 rules will need to be
MVP - Exchange
NEW blog location:
"D303M" <D303M@discussions.microsoft.com> wrote in message
> I...Save csv format to dbf format
I have a .csv file with 13 columns of data opened in excel. I make a
few changes to a field and then want to save to .dbf format.
After saving as .dbf when I open the file only column 1 data is
Any insights into where the rest of the data goes? Why does the data
mdelasaux's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28889
View this thread: http://www.excelforum.com/showthread.php?threadid=486365
Try using Notepad and open your .dbf...Linking Word and Excel #2
I have a Word document with a large number of tables
linked to cells in an Excel spreadsheet. The tables in the
worksheet are in the same order as those in the Word
document. I would like to insert a new table between other
tables linked to the Excel spreadsheet but when I insert
the new table between the others in the Excel spreadsheet,
it invalidates all the other linked information. I take
this to mean that the links are not absolute references.
Is there any way to do this without having to reconstruct