How does one view a document created in Publisher.
I have gotten a document (calendar) in .pub format. Word does not recognize
it. Is there a viewer? What's the link? I have Office 2000 with the
>I have gotten a document (calendar) in .pub format. Word
> does not recognize it. Is there a viewer? What's the
> link? I have Office 2000 with the converters installed.
There is no viewer for Publisher files. Maybe you
could ask the sender to convert it to a .pdf file. Or
you could order the Trial version of Pub2003...
which will still function as a viewer a...Unable to create a dialog box in MFC Extension DLL.
I am trying to create MFC Extension DLL using VS 2005.
1. First I have created a project of type MFC Extension DLL.
2. Then I added a dialog box with a text box, static text control and
3. Then added a class for that dialog.
4. In dialog's header file I inserted AFX_EXT_CLASS, manually.
class AFX_EXT_CLASS CLogonParamDlg : public
5. Then built and got .lib and .dll files.
1. In my client application, just commented ENUM line of dialog's
header file of MFC Extension DLL , as below. (In client its not
necessary and to avoid compiler errro...Creating conditional clause in a module
I am in the process of writing module using vba in ACCESS 2003 which imports
forecasted financial data from a particular excel file based on three inputs.
I am trying to include an "error check" that will end the process if the
three inputs do not match specific data in the excel file. I'm not sure how
to go about doing this. Do you have any ideas what the best way to do this
would be? Below is the code I have for the import part so far if that is
Dim ImportDir As String
Dim Forecast As String
Dim Version As String
Dim Country As Stri...How to create web-based reports from RMS database.
The reports available in RMS is not specific enough for my apparel retail
store. I need sell the through rate, average sale, sales/sf, return rate,
discount analysis, all broken down by date, week, month, year, category,
supplier, and then compare against last year's numbers. I want to create my
own web-based reports accessing RMS's SQL database. Does anyone have a
template of data access web page so all I have to do is change the SQL
statement in getting to the right database table?
> The reports available in RMS is not specific enough for my apparel retail
> ...MRP not creating planned orders in version 10.0
I'm testing version 10.0 on a test system and using a copy of my live
database. Version 8.0 creates a planned PO when QTY Available falls below
Order Point Qty. It's not working in 10.0. I've checked all my settings
from 8.0 to 10.0 and they all look the same.
Is there a setting I'm missing?
Have you rebuilt your low level codes after the upgrade?
> I'm testing version 10.0 on a test system and using a copy of my live
> database. Version 8.0 creates a planned PO when QTY Available falls below
> Ord...Where free 2 sigma statistical process control chart, free?
where can I download a free statistical process control chart template?
...How to use excel file created in version earlier than 4.0a in 4.0
Thanks to whomever answered my query but when I opened the email the screen
was blank. My laptop is sick. My question was and still is, how can I use my
Excel files created in a recent version on my laptop in my PC which is loaded
only with Excel 4.0a . Please and thanks.
You can't, the file format changes twice since version 4. You need a newer
Excel version, a compatible spreadsheet program, or simply a viewer if all
you want to do is view / print the file.
HTH. Best wishes Harald
"ajimmo" <email@example.com> skrev i m...Create Pivot Table Reports
I just finished installing Analysis Cube on the server, everything seemed
working fine until when I try to create the Pivot Table Report
(Tools->Analysis Cubes->Create Pivot Table Reprots). After I called up the
pre-defined 'Definition ID' and click on the Excel icon, a message popped up
saying " The WHTemplate.XLT file was not found."
Anybody have any idea what that is, and how to resolve it??
1.) There are two pieces of software. Did you install both the server
piece, and the client piece?
2.) Is Excel installed on the machine, on which you'r...Controlling Gap Width for BAR Chart
I have the following data for example.
A = 2
C = 4
I can create a 2 D Bar chart from this quite easily.
Now If I make the data to
A = 2 , 3
B= 3 , 4
C = 4 , 5
I do want to plot the data on the basis of first two values as
mentioned in the first example, but I want to control the width of the
Bar from the value given after comma. Please help.
On Sat, 24 Feb 2007, in microsoft.public.excel.charting,
Fazi <firstname.lastname@example.org> said:
>I have the following data for example.
>A = 2 , 3
>B= 3 , 4
>C = 4 , 5
>I want to plot the data on the basis of firs...Bar Chart (2D) won't let me 'gap' one bar behind the other?
Operating System: Mac OS X 10.6 (Snow Leopard)
I have a nice, functioning bar chart that has 2 data fields: ACTUAL and BUDGET. <br><br>Actual is on one axis and Budget is on the 2nd axis. <br><br>These charts look nice side by side but I want one bar to be partly behind the other. <br><br>So, I select a data set. <br>
Choose Format Data Series <br>
Overlap... (and no matter what value I choose, I can't overlap)???? <br><br>But, if I can adjust the Gap Width. <br><...Greying out a menu-bar item
Hi. I wish to greyout a menu bar item, eg "File" or "Edit".
Normally not at problem to grey out things under the menu, eg "Undo" or
"Save". So I go:
void CInterfaceSDIDoc::OnUpdateOptions(CCmdUI* pCmdUI)
But it doesn't work! The menu doesn't work, but it's not greyed out.
You could try getting the m_pMenu out of pCmdUI and explicitly call
m_pMenu->EnableMenuItem(id, MF_GRAYED | MF_DISABLED).
Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only.
This...How do I add y-axis labeling on the right side of chart?
I'd like to add an axis with same values on the right side of the chart.
You'll need to have at least two series in order to enter a secondary axis.
On one of the series, change the Axis to Secondary axis.
"DavidNHFCU" <DavidNHFCU@discussions.microsoft.com> wrote in message
> I'd like to add an axis with same values on the right side of the chart.
How can I force the y-axis at the bottom of my chart to appear for all 12
months when I only have Jan, Feb and March figures to put in the first thre...Constant List
Is there an easy way to return the values of the ChartType
constants? Excel 97 does not seem to list them in help and
I have not been able to find them in google.group
Select xlChartTypes in the Classes pane of the object browser. The
constants are named in the members panel. If you select one, it provides
the numeric equivalent at the bottom of the object browser, e.g.,
Const xlArea = 1
Member of Excel.XlChartType
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
> Is there...Quick Launch bar
We are using Redirected User Folders via Group Policy on our network. I
have a Quick Launch bar visible with various icons on it. If I change these
they are fine until I log off and back on to my system at which point the
quick launch icons revert back to the original ones from the Redirected
User Folder. Why are they not updating? All help appreciated.
They say they've got control of you
But that's not true you know
They say they're a part of you
And that's a lie you know
They say you will never be
Free free free
SLF - Alternative Uls...What is the best chart for this....
When I want to compare how each salesperson's sales contributes to Total
Sales, I can use a pie chart. But what do I use when I want to compare how
each salesperson performed against the *average* of total sales?
I am envisioning a vertical bar chart with a horizontal line at the average,
but I need a solution that can be generated by a macro.
Any advice? Thanks in advance.
That's how you would do it, a column chart with a horizontal line. On this web page, I give a
couple techniques to achieve the horizontal line:
http://peltiertech.com/Excel/Charts/AddLine...Excel --- Physical dimensions of a chart object
Is there a way to know the physical dimensions of a chart object on a
worksheet? I have data in several worksheets and I would like all my
charts to be of the same size (obviously this means that data with a
smaller range of values will be more spread out than data with a larger
range of values).
This is just an example:
n = ActiveSheet.Shapes("Chart 1").Width
m = ActiveSheet.Shapes("Chart 1").Height
MsgBox (n & " BY " & m..."Print to Scale" Excel 2007 Charts
In Excel 2003, one could double-click a chart, print, and the chart would
auto-size to fill a page.
I am unable to print my newly-created Excel 2007 charts so they auto-size to
print one-to-a-page (now requires several time-consuming steps for
reformatting titles, axes, etc.).
I do not have a "print to scale" option in my page setup.
Printing to a Ricoh Aficio AP610N. Thanks so much.
I will assume we are talking of an embedded chart (one sitting on a
worksheet) and not a chart sheet.
In Excel 2003 (all earlier) you did not double click, you just single
clicked to...Text Boxes
I am currently using Excel in Office XP.
I have created a small 'Text Box', but have a lot of text
in it and I do not want to make the 'Text Box' any bigger.
Is there any way that I can place 'Scroll Bars' on
the 'Text Box' ?
A textbox from the Controls Toolbox has a Scrollbars property. A textbox
from the Drawing toolbar doesn't.
HTH. best wishes Harald
"Tappie" <email@example.com> skrev i melding
> I am currently using ...Stacked and single column in same chart?
How can I do a chart with a stacked column beside a single column? When I build a stacked column chart, any new source data I add
wants to put it in the same stacked column.
Use one of the links on this page. You need to set up the data so the
single column is in a stacking position with no other columns of data.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> How can I do a chart with a stacked column beside a sing...excel chart showing movable graph at what point we make a profit
in a business would like to make a chart based on accumulated Earnings &
Profit/Loss for year to date, perhaps movable showing our break even point
and by moving chart to a another earnings figure what profit we should make.
For example put in earnings for YTD Profit/Loss YTD then I can move the
earnings part of the chart to show what our profit would be for a given
If For example if we earn $200 for year so far and profit is $0 but any
amount over that is 18% profit so I can move chart line to say $240 and it
will say what profit I will make.
Hope ...Creating only a mailbox
I'm doing some DR testing and I was wondering if there is
any way to create just a mailbox that isn't associated
with an AD account. I could create an account with a
mailbox and then disconnect it, but I'd like a way to
build hundreds of mailboxes that aren't associated with
any AD account.
Any help would be great. Thanks.
In AD just add it as a Contact instead of a user, this
will allow you to give it exchange attributes without an
>I'm doing some DR testing and I was wondering if there is
>any way to cre...Help with creating a formula
I am trying to create a formula that will sum up certain criteria from one
column as it relates to criteria in the same row in another column. For
example, I want to sum up all the entries that begin with the letter "H" in
column A as it relates to an entry of "2" from column B that is in the same
row as the "H" entry from column A.
COLUMN A COLUMN B
If there is such a formula...Auto-create activity from Mobile
We have CRM 4.0 Roll Up 7. We are looking for a solution that offers
advanced mobile integration to CRM. We would like the mobile client to
auto-generate an Activity in CRM whenever a phone call is made to a CRM
Has anyone done this?
There are a few vendors that offer good mobile solutions. I know for
certain that MobileAccess from Ten Digits (http://www.tendigits.com/) has
that specific feature.
"Jobro" <Jobro@discussions.microsoft.com> wrote in message
>...Can anyone help with this chart?
I would like to have the following values/labels on the y and x axis of any
style of chart:
X-axis: July, August, September etc for a full financial year;
Y-axis: FB, AP, DR, LA, PC.
OR the other way around.
Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc.
Thank you. Any help would be much appreciated.
Check out Jon Peltier's article on creating a vertical category axis:
*Remember to click "yes" if this post helped you!*
"A little stuck" wro...center data labels on my column chart
How do i get my data labels to appear in the center of
each column on my chart? Thanks.
Click on one of the labels
(that will select all the labels in the series)
Choose Format>Selected Data Labels
Select the Alignment tab
From the Label Position dropdown, choose Center
Immediately after formatting the first series,
if there are other series in the chart --
Select a label in another series
Press the F4 button on the keyboard, to repeat the
formatting from the previous series
Repeat for all series
> How do i get my data labels to appear in the center of