vlookup issue ( not working and im tearing my hair out)
Okay , well i cant discuss the actual info in my sheet but ill come up
with a good analogy of it all . Ok basically on sheet 2 i have all the
teams in my NHL ( my company) listed under the immediate manager. I
also have the players last name, first name and number set out as such
Shivers Paul 14
Jacobsen John 25
Tucker Tanya 98
Pitt Brad 22
Murray Bill 28
Clinton Hillary 55
You get the point, ok , on sheet 1 ( my main page accessible to my
company ) , i have this format...
Managers last name Players last name
...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...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...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...ATTN: Need to import data from access database, hosted on web.
This should be fun.
I can use the import data feature to get data into excel from a loca
But i need a central access dbase on the web, and when someone open
the excel workbook, it auto updates from the access dbase hosted on th
Im assuming this has something to to with the connection strings et
that i need to write, could anyone point me in the right direction o
post a solution,
many many thanks in advance.
Message posted from http://www.ExcelForum.com
..."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!
...Sending web page attachments
Whn attempting to send a web page via e-mail I receive
the following message. What do I need to do in order to
send these pages error free and why is the message being
received in the first place? Thank you -
Outlook blocked access to the following potentially
Does anybody have the same problem that I do with Money in the sense that
the page continually will load and refresh after a couple minutes? Its very
annoying and I want to knwo if theres a way to turn it off.
Anybody? I don't know. I don't.
What version? Have you tried things like not running other apps? New video
driver? Turning down hardware acceleration?
"l8neway" <firstname.lastname@example.org> wrote in message
> Does anybody have the same problem that I do with Money in the sense ...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...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..."Sync Issue
We occasionally get an instance of a 12800 error appearing in the
application log. The event appears when backup exec (which is running
locally on the server) is trying to backup / process a large message (70 mb)
which is in a users' Outlook "sync Issues - Server failures folder. The
message contains a large binary attachment.
We don't get any other occurances of 12800 errors during other times, so I
don;t think that it could be a server memory fragmentation issue.
Does any one know of any issues with Exchange 2003 SP1 and large binary
Does any one know o...Web Access #7
When using Outlook 2003 Web Access I can log in, but my
inbox is stuck at loading... Am I doing something wrong?
Not sure with so little information - but since OWA is part of Exchange, not
Outlook, you'd be best off posting this in an Exchange newsgroup (try
microsoft.public.exchange.admin) with more details (as in, does this work
from *inside* your network? anyone else having the problem? does it work
from another external computer? what browser version/SP on the client?)
Best of luck...
> When using Outlook 2003 Web Access I can log in, but my
> inbox is stuck at ...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...when I save an email, where does it save to?
I have several emails that I wanted to reply, and I did click "reply" and
then wrote something, but I did not have time to finish...
then I click on "save", and in the evening, I closed the outlook because I
now I reopen the outlook in the morning, and I want to find my saved
unfinished replies that I was writing...
But where to find them?
I have a "draft" folder, but those saved emails do not seem to be in this
folder... wherelse could they go?
This is annoying... is there a way to automat...Daylight Savings Time #2
In regards to DST or better yet XDST, in my windows 2003 domain environment I
have the servers and workstations syncing their clock with one of my DCs.
The statement has been presented here that since this is the case we should
not have to worry about clocks being off by one hour. I do not get the warm
and fuzzy with this statement. I feel that if it were that easy it would
have been documented as a solution by now. Maybe they are right and I am
wrong. Could you give me an explanation why so or why not? Thanks
- Any clock synching is done based on UMT/GMT and the locale/timezone o...Installing CRM on 2003 Web Edition
Has anyone installed CRM 1.2 on Windows Server 2003 Web Edition. The
implementation guide is says it is a supported OS,
I am planning on attaching WS03 Web Edition to an SBS 2003 server. I know
that the supported configuration has everything on the single SBS box, but I
would much rather put some things on other boxes. I am also planning on
putting SQL Server on its own box as well.
Any comments on this configuration?
Beware that SQL Server cannot be installed on a Web Server edition !
Microsoft Business Solutions Support
Ce message est fourni...Extra Pages in Reports
We upgraded from 8.0 to version 9 a few weeks ago. This week one of my
clerks said that when she prints some payroll reports that the last two pages
will print 10-20 times. Another clerk has had the same problem with the
Checkbook posting journal.
I have looked in the knowledgebase and in the forums to no avail.
Anyone have any thoughts?
Do you have Named Printers setup? I have seen named printers go a little
crazy after an upgrade from version 8. if this is the case removing the named
printers from the workstation and then readding it usually fixes it.
"Jaso...Move page button on sidenote
If you want to move a side note to one of your onenote pages, the
easiest way is to customize your toolbar to add the "Move Page to"
button to the sidenote toolbar.
1- select the drop down at the end of the toolbar
2- Select Add remove buttons and Customize
3- Under commands in the popup windows, select Edit - move page to -
button to your toolbar.
...Automatic save of all messages from a known contact
I'd like to store automatically all messages from a known CRM Contact.
If for example my customers email-address is email@example.com, I'd
like to store automatically all his emails via the Exchange<->CRM
Connector regardless to who they are sent to.
Is that possible?
Hi Juergen. My company has a product called Effective Email that does
exactly what you are asking for. There is a sync event that gets
installed on the users inbox. When emails come in, it checks the
senders address against the CRM database, and if a match exists, it
creates a...How to get saved old saved work that was saved over?
I typed up some History notes and saved it. I wanted to use the same format
from those History notes for some new History notes and I saved over on my
old work. How can i retrive my old saved work? My work was in Word not Excel
But I could not find a place to ask a question in the Word help section.
If you saved over the original file, it is gone forever.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Maral" <Maral@discussions.microsoft.com> wrote in message
news:C0ADFEF9-6A46-4589-8923-4BFC07D9C61F@microsoft.com......Fixing position of page
I have some small menus created for a restaurant. They will be loaded on
their computer and when they need to change prices etc. all I want them to be
able to do is change prices and the food entry. I want to be able to lock the
position of the groups on the page so they cannot destory the format etc.
I just don't think there's a way to do it. If they can edit anything, they
can edit everything. Assuming they are paying you for the work you're doing,
it's their product and they can do anything they want to it. Including screw
it up royally. (I know, that's the pits.)...