Linking a graph to a csv file
Hello, I'm sure this is exceedingly easy, but somehow,
I'm screwing this up. I ultimately need to have a self-
updating PowerPoint file (client mandates a ppt file).
According to ppt's help, that means I have to use linked
Excel graphs, not embedded ppt graphs. However, my
programmer will be supplying me with tons of csv files.
When I try to create an excel file with a data link to a
csv file, it tells me that it can't update it unless I
open the source file. I *can't* take the time to open
each csv - there will be hundreds. What am I missing
wi...Macro must return the name of the button
I want to a macro to display the name of the button (or object) from where I
am calling that macro. Anyone an idea?
What sort of button (userform, worksheet forms, worksheet control toolbox)?
(remove xxx from email address if mailing direct)
"Derek Brussels" <Derek Brussels@discussions.microsoft.com> wrote in message
> Hi there,
> I want to a macro to display the name of the button (or object) from where
> am calling that macro. Anyone an idea?
&...Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...Customising page numbers
In MS Word, we can introduce the page numbers in header/footer and
customize the starting page number from 2 or 3 ... instead of 1. I
want to start the page number from 5 in Excel. Kindly help.
goto 'File - Pagesetup'. In the first tab is a textbox to enter your
starting page (think this was introduced with Excel 2000)
> In MS Word, we can introduce the page numbers in header/footer and
> customize the starting page number from 2 or 3 ... instead of 1. I
> want to start the page number fro...Quirky recent file list #2
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
If/when you upgr...How to do a mass download of names to Outlook address book
I have about 800 names and email addresses in an Excel
spreadsheet that I need to add to my Outlook address book.
Can anyone give me a hint on how to do this?
Save the Excel Spreadsheet as a CSV (Comma Separated Value) file and then in
the Address Box, Click, File, Import, Other Address Box, then click Text CSV
file and browse to it.
"Hal Segal" <firstname.lastname@example.org> wrote in message
> I have about 800 names and email addresses in an Excel
> spreadsheet that I need to add to my Outlook address book.
> C...Scheduled Integration via Integration Manager
I in dire need of help and would need to know if there is any way that I can
schedule integrations using integration manager. For example, my client
would want to update the price list via integration manager. Is there a way
for them to just enter a date to run the integration, and if possible a time
as well, then it will automatically run the integration at that specified
date and time?
Any workarounds, ways and step by step procedure on how to achieve that,
would be very very great.
The IM user guide covers that in detail. If you don't already ...outlook 2000 help file
Seems after I did added SP3 from MS upgrade site my help from outlook has
quit working. message is msohelp caused error in itss.dll. help works in ALL
other programs including outlook address book. I'm running windows 98 SE,
Office 2000 SB and IE 6.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/03
...Import Palm files
Can anyone help me by telling me how to import palm files
(dat files) into outlook. I want to import contact,
Depends what you can export to from Palm Desktop. Personally, I've found
this messy. Why not just get sync software that can sync your Palm with
Outlook directly? Chapura Pocketmirror or Pumatech Intellisync are two
ideas....or your Palm CD may have come with this option.
F. Carvalho wrote:
> Can anyone help me by telling me how to import palm files
> (dat files) into outlook. I want to import contact,
> calendar, etc
...Recognition of crylic test in work sheet names, VB version 9108
I have named some worksheets using russian langauge text, which is not
recognised by VB in computers running less than Excel 2003.
Is there a patch or an upgrade for VB to read this text?
ie VB=Sheets(Array("àðàõèñ", "peanuts")).Select
and refers to the worksheet арахис (russian for peanuts)
(the text is readable in excel, is not legible as worksheet names in VB)
...Countif formula between numbers
I'm have a bad day and can't figure this simple question out. I want Excel to
count a column of numbers and show the the total cells with values between
100 and 125.
The formula I have thus far is '=countif(H5:H125,">=125<=100")
why is this not working???
This has been asked about a dozen times today. Homework assingment?
=sumproduct((rngA>100)*(rngA<200)). modify to suit
"dandigger" <email@example.com> wrote in message
news:1D44A5E6-ECAB-441D-B9D8-409D23D0369E@microsof...Invoice Still Named as Quote
Anytime that we convert a quote to a sale in RMS, the receipt still says
Quote on it. This was not previously happening. Is this a 1.3 bug?
...Debugger comes up when attaching files to Outlook 2002
I have a pro bono non-profit client running win xp sp3 & ms office pro.
Last week she reported that every time she tried to attach a file to an
outlook email, she received a dialog asking her if she wanted to start
the debugger. It never allows her to attach the file and if she goes
through with starting the debugger, she gets a variety of errors...
never a repeating error.
Anyone have any experience with this error?
...List Shows Private Files
DID ANYONE ELSE NOTICE THIS?
Whenever I save an attachment, and go to the drop down
menu for file name, I am shown a list of dozens of files
recently accessed on the computer (not just files
accessed by Outlook Express). This occurs even if recent
cocuments is turned off in Windows XP and even if the
recent documents folder for Windows XP has been cleared.
This shows too much! Others using Outlook Express on the
same computer can potentially view the file names of
every document, image, and device recently accessed.
Where is the folder to clear this data out of?
duncan <anonym...Memory Usage When Playing WMV HD Files
When I watch a WMV HD file using WMP11, the file appears to start up and
play well until I try to fast forward / jump to another part of the file,
then the player just stops and after watching via the task manager, WMP
memory usage goes through the roof ie. gigabytes and ultimately the player
Have reinstalled the player, have tried various codecs etc but all appears
to be unsuccessful. System is XP based, E6600 cpu with 4gb PC6400 memory and
8800GTS 640mb graphics. Any help would be much appreciated.
Thanks in advance.
Dumb question: what video card d...To increase the upload file limit ONLY for one site collection
I have more than 1900 site collections on a web application. I know I can
modify the upload file limit thru the CA or directly on the Web config file.
However, I do not want to change the setting for all the site collections. I
need to be able to change the setting only for a particular site collection.
Is there anyway I can add manualy that entry in the web config file. Has
anyone tried? Is this possible?
Thanks in advance,
I have created a calculation to count the number of people and placed it in
the Name Footer: =count([EyNumber]) and called the unbound box, CountNames.
When there are no results it returns the #Error message. How can I remove
this error message and display a message like, "No Data", or display the true
results of a count? I have tried using the IsError function but can't seem to
get it to work.
=IIf(IsError([EyNumber]), "No Data", Count([EyNumber])
>I have created a calculatio...Contact not importing names of csv lists
Whenever I import a csv file into outlook 2007 it imports only the email
addresses, nothing else. I've titled the csv columns with the exact same
headings as the outlook contact headings. Still, it imports only the email
addresses. What do I need to do to get it to import the full names as well?
Is it correct to assume that because you stated that you "titled the csv
columns the same as the Outlook contact headings" - that you used
"auto-map" to import your data?
There is absolutely no reason, benefit or value whatsoever (under any
circumstances) in ...ESM error
I'm hoping someone can help me with this.
I have Exchange2k3 SP2 running on a Win2k3 server. Our Exchange Admin is
out on medical leave so I am resuming his responsibilities.
My problem is I cannot access some of the storage groups using exchange
system manager. We have 4 mailbox stores and I get an error trying to access
3 of them. The error is "An unknown error has occurred. ID no: 80040d1b
Exchange System Manager". What is really puzzling is if I click on a storage
group a second time, I don't get the error but the storage group shows up as
empty. I have thi...how to divide a numbers in a table of data by 1,000, all at once
I've noticed in some spreadsheets that numbers are displayed as
rounded...i.e. so that one isn't looking at 1,403,333 + 2,333,999 etc. but
rather 1403 + 2334, etc. with a note at the top that says "000's".
In one step, how can I edit all the numbers in a table so that they show to
the nearest 10,000 (i.e. 1403 +2334), without dividing them one by one by
Or, to go at it from another angle, how do I divide each # by 1,000?
The ROUND feature requires that I create a new table. Not exactly what I'm
Enter 1000 in an unused cell.
...i renamed a file i needed and lost the info how do i get it back?
I had 2 files with the same name in excel. After I excited excel, I wanted to
rename my new file, and I thought I was renaming the new file, but I actually
renamed the old file I was working in and when it said this file exists do
you want to change I said yes. I lost all my work. How do I get it back?
You can't unless you had a backup. Not nice to excite excel.
"Tera" <Tera@discussions.microsoft.com> wrote in message
>I had 2 files with the same n...popup box message; "Publisher cannot open the file"
saved as a .pub file but unable to open. popup box message "Publisher cannot
open the file"
What version Publisher do you have? Do you know what version Publisher was used to
create the file?
Mary Sauer MSFT MVP
"stature" <firstname.lastname@example.org> wrote in message
> saved as a .pub file but unable to open. popup box message "Publisher cannot
> open the file"
Downloaded a program some time ago that I found had
spyware in it.When I took out the programs I started
getting error message at start up of Outlook. "file
hotbar\bin\448~1.o\sbolext.dll missing" Downloaded from
Microsoft the newest version of the file. Still getting
the error message on start. The program runs fine, don't
know why it is looking for this file. Running Office 2000
Sr-1. The program removed was hot bars for wall paper and
scam mail. Any help would be appreciated.
Thank you. e-mail address is email@example.com.
...How to obtain the name of ODBC definition used in a spreadsheet? #2
How do I get the name of the ODBC def used in my spreadsheet?
How do I migrate my spreadsheet (with the ODBC connection) to a different
computer and change the name of the ODBC def to a new name, available on the
...svhost.exe: A CRM-related File?
McAfee VirusScan has suddenly notified me that it detected
a "potentially unwanted file" on the machine that I am
using to host an ActionPack version of Microsoft CRM. This
is an SBS installation, with everything running on one
test machine. Here is the warning from McAfee:
Potential Unwanted Program Detected!
The file C:\WINNT\System32\svhost.exe is a Potentially
Unwanted Program (ServU-Daemon)
When I try to move the file to the desktop, I am alerted
that it is in use and cannot be moved (no surprise, huh?).
The interesting thin...