I have created an application which outputs it's information into
Excel so the client can manipulate the information easily. However,
they've moved the goalposts a bit and now want it to 'look cool'.
I usually work with websites so that usually wouldn't be a problem.
However, could anyone point me in the direction of any resources on
making Excel ... erm ... sexy! I appreciate that I can probably change
the fonts and colours, maybe include graphs and images here and there,
but I wondered if there were any galleries anywhere of good examples.
Specifically he wants an interf...how do I get access privileges in a publisher file. I can't save .
I made a publisher file in Office xp. Now I have office 2003 and when I try
to save my own publisher file, it says:
the file%s cannot be opened. Access privileges have not been given.
What is that? And how do I solve that?
You receive a "File is not available" error message when you try to open an Office
You receive an error message when you try to create a new document in Office 2003
Mary Sauer MSFT MVP
http...Publisher 98 won't open a Publisher 95 file?
I have a couple of files created in Pub 95 that I need to open. My current
version is Pub 98...but it says it can't open a different version. Anyone
else had this problem (and hopefully solved it!?)?
> I have a couple of files created in Pub 95 that I need to open. My
> current version is Pub 98...but it says it can't open a different
> version. Anyone else had this problem (and hopefully solved it!?)?
If you're sure they're 95 -ditch NAV. Problem solved.
Facon - the artificial bacon bits you get in Pizza Hut for s...location problem: display bitmap
I create a CForm window (MFC) with a button (some other controls) on it. I
need to display a bitmap (from a bitmap file) at the right side of the
My problem is I cannot get the correct location.
Below is my code. I believe I set the different view, which makes the pixel
calculation not work.
"GetSystemMetrics()" and "GetWindowRect()" may not work in here, but which
function should work?
thanks a lot
CSize si...Does Publisher 2003 import pdf files
I want to import a pdf file as a graphic into Publisher. Does 2003 do this?
I have 2002 and it does not!
Kathy <Kathy@discussions.microsoft.com> was very recently heard to
> I want to import a pdf file as a graphic into Publisher. Does 2003
> do this? I have 2002 and it does not!
It does not. See here: http://ed.mvps.org/Static.aspx?=Publisher/convertpdf
Ed Bennett - MVP Microsoft Publisher
The only way I've been able to do this is to use the 'Snapshot Tool' in
Acrobat (don't think this is available with Reader) and paste ...Print data in form field lists
Using Word 2007 - have a form with multiple drop down lists. Is there a way
to print a copy of the form which displays all the options in the drop down
lists to make updating easier?
I am not sure how printing a document with all the dropdown items displayed
(which is not possible) would help with 'updating'. If you want to modify
the values in a dropdown field more simply - take a look at the add-in at
<>>< ><<> ><<> <>>< ><<> <>>< <...Problem uninstalling CRM for Outlook
I am having a problem when uninstalling the CRM for Outlook Toolbar. When I
log onto the machine as the user who installed the CRM toolbar, I receive an
error "This action is valid for products that are currently installed". We
did have to delete the NT profile of the user which installed CRM toolbar, so
I assume this is related to this problem.
Thanks for your help!
...Excel Dynamic Linking Problem
I have tried to resolve this problem in the past and no
one seams to be able offer a solution. Problem: This only
happens when I paste an Excell page into Corel Draw and I
only paste and not paste special so as not to create a
link, however there seams to be a dynamic link of some
sort created between Corel and Excel. This dynamic link
seams to be a real drain on the system even though the
page I am working on is only about 400kb in size so when I
continue to zoom in closer on any part of the page Corel
will slow down and then just lock up. I have seen other
Corel users on various fo...Publisher 2002 Fatal Exception
I am running publisher 2002 on a Windows 98 OS. Everytime
I open a publisher file or start a new wizard, I get a
fatal exception OE at 0167:BFF9DFFF Any ideas on this one?
What Are Fatal Exception Errors
Could be any number of things, bad memory, corrupt driver...
Mary Sauer MS MVP
"Lauren Olsen" <email@example.com> wrote in message
>I am run...Sending data via email
Each of my sales people will have a database on their laptops. The database
will run via runtime. I want to be able to email them a text file of data
that I'd like them to be able to upload into the database on their laptops.
Can I do this? How would I write the VBA Code? The text file would be a
fixed width text file. I'd appreciate any help you might be willing to give
You can link the text file and use it as a table in your database. If
the text file never changes name, the file can be overwritten and the
link will still work provided the ...Pie of pie chart with 2 data series
I am trying to process the results from a survey. For a particular question,
the surveyed people can answer with (say) yes, no or partially. They also
can justify their answer, with (say) something like cheaper, simpler or
don't know. I would like to have a pie chart with the yes, no and partially
answers to see how many have responded with each choice, but then also a pie
of pie chart with for the yes answers (for example) the distribution of the
Here's what I have done so far (this is just a proof of concept with a very
small data set). The headings yes/n...HOw do you specify a text in data validation for cell
I am using this as data validation for a cell
This returns the contents of the cell which is a named range and the list is
But now I want to return the list behind the named range with a name that
has ....say ...
a "L" in front of it.
so it would be:
but it doesnt work, I get an error.
Include the "L" in the Indirect formula:
> I am using this as data validation for a cell
> This returns the c...Publisher wizards
When I start publisher 2000, the microsoft publisher
catalog opens and informs me that the wizard files were
not installed and to run setup agian to install.
The problem is that when I try to run setup, it does not
work. If I try re-adding the media content, it goes
through the motions and says it's complete. I start
publisher and I get the same issue. If I try to repair
the install, it keeps asking for Disk 2. I have multiple
disk 2's from various purchased of the program and it
continues to look for Disk 2.
Any clues guys?
OFF2000: Error Message: The Feature You Ar...eConnect exception
I am getting this eConnect exception:
Object reference not set to an instance of an object.
ConnectionString, ConnectionStringType ConnectionType, String sXML)
When I use the Dynamics Web Services. This is the corresponding webs
Server stack trace:
Microsoft.GreatPlains.eConnect.eConnectMethods.eConnect_Requester(String...can't connect using "telnet servername 25"
I have an Exchange 2003 server on our LAN. I find some PC's and servers can
connect to the Exchaneg server using command > telnet 10.10.10.1 25 and some
can't. I have no firewall between any of the pc's and servers.
The exchange 2003 server is 10.10.10.1
When I run on a pc or server that can't connect I get this messag:
C:\Documents and Settings\Administrator>telnet 10.10.10.1 25
Connecting To 10.10.10.1...Could not open connection to the host, on port 25:
Why is this happening?
On Sat, 17 Dec 2005 04:35:28 -0800, "SW"
<SW@discussions...Excel data into Word
I need to layout some data from excel into word. The final product needs to
have 5 columns so that it looks like (repeated across).
City, State ZIP City, State ZIP
I remember doing this years ago in Word, but I cannot figure out to do it.
I need to end up with 127 entries. This is for a page in a document. I seem
to recall that at the end of each merged entry, there was a code that told
word to enter the data going across rather than making a new page.
Depending on whether you want the ent...Row limits with Publisher
Is it possible to exceed publisher table limit of 128 rows? I have a
spreadsheet that I want to import with almost 2,500 rows. Thank you in
advance for your assistance!
> Is it possible to exceed publisher table limit of 128 rows? I have a
> spreadsheet that I want to import with almost 2,500 rows. Thank you in
> advance for your assistance!
Given that Publisher can't flow tables across pages, that's going to
have to be a really long page!
(I don't have an answer for your question.)
Ed Bennett - MVP Microsoft Publisher
http:...HTML generated excel spreadsheet does not display on web page
I generated html for an Excel spreadsheet using Excel's publish function. I
then copied this html into a web gem on my web page and published the page.
I am running IE6 and XP (Office 2000) as well as Norton Internet Security.
The web page loads fine for me.
However, a couple of my users have indicated that they see a square with a
dot in it. One user is running IE6/WinME, another AOL's browser/IE6/Win98.
The WinME user also has Zone Alarm but he turned it off. The other user says
she does not have any firewall s/w running. The WinME user tried accessing
this page from...Appending data in cells that utilize a Dropdown list.
I would like to append entries in cells that utilize a dropdown list.
Currently, when I select (in this case names) from my dropdown list I cannot
append them if I want to add more than one to a cell. If I select another
name from the dropdown, it erases the first entry. Is there some way to
append entries within cells that use this form of validation so that I can
enter more than one in a cell from the dd list?
Office XP Professional
Debra Dalgleish has an example workbook showing how to do this
http://www.contextures.com/excelfiles.html...How do I set up an additional print title in Excel?
I need to add additional print titles to my report. Also what is the simplest
way to do a formula? Thanks for any help.
what do you mean by "additional print titles"
and what formula are you thinking of using ....
"Sally" <Sally@discussions.microsoft.com> wrote in message
>I need to add additional print titles to my report. Also what is the
> way to do a formula? Thanks for any help.
...Monograms in Publisher??
I would like to do a monogram of two initials in microsoft publisher for a
wedding invitation but i cant, has anyone got any ideas?
Chris Poleon wrote:
> I would like to do a monogram of two initials in microsoft publisher
> for a wedding invitation but i cant, has anyone got any ideas?
Yes, use the correct tool for the job. Publisher is a desktop publishing
application, not a vector drawing or graphic design application - you need
something like Adobe Illustrator, Corel Draw, or Paint Shop Pro might do at
Publisher is the perfect tool for assembling th...Data Validation #44
Why does <> (not equal to)not work in the formula in
D8<1.5 does work
Is D8 a formula? If it is, the result is just slightly less than 1.5.
> Why does <> (not equal to)not work in the formula in
> EX D8<>1.5
> D8<1.5 does work
Excel FAQ, Tips & Book List
...Outlook 2003 Pop3 problem
I too am having the same issue. I was wondering if it is
one of the outlook express patches that I downloaded
because this didn't start happening until I downloaded the
Who are you replying to and what is your issue?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Michelle R" <firstname.lastname@example.org> wrote in message
>I too am having the same issue. I was wonde...What CRM functionality uses the members of a territory?
I can see that you can assign users to a Territory but when I assign an
account to one of those users that account does not get assigned to the
Territory. What is the purpose of assigning users to territories?
When I Google for "MSCRM territory" I find multiple references to this
statement: “Territory Management: Create territories for salespeople,
enabling them to manage and evaluate territory-based sales processes with
workflow rules and reports.” Are territories only meant to be used to run
workflow rules and reports?
You use territories together with sales quota...how do you copy and paste a publisher page into a new pub doc
how do you copy and paste a publisher page into a new pub doc
Select All, Copy, Paste into a newly setup pub doc.
"kcc" <email@example.com> wrote in message
| how do you copy and paste a publisher page into a new pub doc