How can I insert a cell reference in a footer (eg for variable foo #2
Any ideas on how to do this?
I'm trying to create a template with the doc reference number in the footer
However, I'm trying to avoid users having to edit the footer (because this
just wont get done).
Private Sub Workbook_BeforePrint(Cancel As Boolean)
.PageSetup.LeftFooter = .Range("A1").Text
This code should go in the ThisWorkbook code module.
(remove nothere from the email address if mailing direct)
"wngg001" <email@example.com> wrote in message
news:8A0F9D9E-269F-45CF-A6E3...I can send but not receive emails in outlook
I have just installed Outlook 2003. I can send emails but cannot receive
them. I have confirmed my internet settings with my ISP. If I return to
Outlook Express which was installed with Microsoft Works I can still access
my incoming mail from there
Do you receive any errors when trying to receive?
"TeeJay" <TeeJay@discussions.microsoft.com> wrote in message
>I have just installed Outlook 2003. I can send emails but cannot receive
> them. I have confirmed my internet settings with my ISP. If I return to
>...How do I install when "file ZF561407.CAB can not be found"
...charting independent XYScatter graphs
I'm trying to create a XYScatter graph of 3 independent datasets from
within VB6 using OLE/Excel2000.
I'm using the KB147803 article as a basis, but am stuck and hope someone
The example in KB147803 seems to indicate that there can only be one set
of X-Values for the 3 XY Scatter Graph data sets.
The X-Value series is the first row of data in the sheet, and is called
out as a set of Category labels ('cwCategoryLabels=1'), and applies to
all three subsequent rows of Y-Value data.
In my case, I want to plot 3 independent sets of XY data, so I'd like to
if I have data like this
A B C D...
1 Type\Date 01/10/04 02/10/04 03/10/04...
2 T-X 100 50 100
3 T-Y 50 70 0
4 T-Z 400 0 400
...Add Text Field Columns
I have two fields both of which are text. When I try to add them as above, I get a
concatenated result, not the sum. How does one add them?
On Fri, 18 May 2007 17:38:49 -0600, bw wrote:
> PFDB: IIf(Nz([PFDirect])+Nz([PFBulk])=0,"",Nz([PFBulk])+Nz([PFDirect]))
> I have two fields both of which are text. When I try to add them as above, I get a
> concatenated result, not the sum. How does one add them?
How does one add "This is text." + "this is also text&qu...Help with graph / chart
I have a graph for weeks 1-52, I have split this into 4 seperate graphs each
showing a quarter (13 weeks) I cant remember exactly how I created them but
possibly using some sort of copy paste as each chart show weeks 1 - 13 along
the bottom. This should read.........
for chart 1 1-13
for chart 2 14 - 26
chart 3 27 - 40
chart 4 41 - 52
How do I change this on each chart to read the week numbers indicated.?
You need to define the Category labels for the chart.
Chart 1 is fine as it defaults to the values 1 to 13.
For the other 3 charts you will need to create...How do make a line correspond to date
I have a chart with horizontal bars and I want to put a vertical (trend) date
line that corresponds to today's date.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"soconfused" <firstname.lastname@example.org> wrote in message
>I have a chart with horizontal bars and I want to put a vertical (trend)
> line that corresponds to today's...Owner draw buttons : 2D look...Can it be 3D?
i created owner draw buttons in my application. but the feel and look
of these buttons is not the same as the CButtons. i mean when i click
on the CButton, it gives a 3D feel as the text shows some offset and
the button gives a pressed look. but in the owner draw buttons, there
is no such 3D effect i can see. can we make it possible?
> Priyanka here...
> i created owner draw buttons in my application. but the feel and look
> of these buttons is not the same as the CButtons. i mean when i click
> on the CButton, it gives...Copy chart with reference table
I have a pie chart neatly tied to a data table alongside. Now I want to copy
both the chart and table to a different area of the sheet so I can modify the
new data table and have 2 different charts.
My issue is that the chart will only allow absolute references, so when I
copy both the chart and table together the new chart still is tied to the old
table - so I have to go and change the source data ranges one by one.
Any way that I can do this easily?
Copy the whole sheet. The copied chart links to the data on the copied
sheet. Now cut the range that includes the copied char...Re: Two-Column Problem
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Charley Kyd <email@example.com>...
> But now, when I add a pair of pages, Publisher gives me guides for two
> columns per page but gives me only one page-wide textbox per page,
> not two.
Can't you create your text boxes yourself? Or change the text box that
appears to a two-column one?
Ed Bennett - MVP Microsoft Publisher
Before reading this message, view the disclaimer:
...Label lines disappear when I copy to Powerpoint
Just created a pie chart in Excel 2007 with Labels which have a line joining
the label to the pie segment, however when I copy and paste into Powerpoint
the lines joining the labels to the segments disappear. Anyone know how to
fix this? Need presentation for tomorrow!
__________ Information from ESET Smart Security, version of virus signature database 4031 (20090423) __________
The message was checked by ESET Smart Security.
...Fine lines print after I expand the article beyond orig template
Don't want the fine horizontal lines that print out after I expand an article
beyond the original template size in Publisher.
If the template doesn't have the lines on the screen, then I suspect you are
experiencing printer driver problems. Do you have similar results from other
Mary Sauer MSFT MVP
"Riley" <Riley@discussions.microsoft.com> wrote in message
Is there any way I can control the spacing between the
columns in the layout guides (chosen from the Arrange
menu)? I want to set 0.7 cm column spacing for a text
frame split into 3 columns and see the guides for this
setting so that I can then use individual text frames on a
I know I can set the column spacing in the text frame
formatting option but this is not reflected in the layout
guides. Please can anyone help?
I am using Publisher 2000. I have this work around - I
make my own ruler. Make pull a rectangle, looking at
the "size" indication in the lower r...Data in columns not rows
I have file that is names, addresses and phone numbers.
When I copy it into excel it comes out like this.
I need it to be like this
COLUMNA COLUMNB COLUMNC COLUMND
NAME ADDRESS ADDRESS2 PHONE
Is there a way to change this without copying and pasting?
Is the data consistently 4 rows? Or do you have varying sets?
How far down Column A do the sets extend?
If 4 rows per set try this.....
In B1 enter =INDEX($A$1:$A$3000,(ROW()-1)*4+COLUMN()-1,1)
Drag/copy across to E1 then select B1:E1 and drag/copy down u...how do i create a quiz using excel?
hey guys...i badly need to make a quiz using excel,,,i got no clue how to do
the quiz will be a simple one, no drop downs and should display the scores
after the quiz is taken....
What type of quiz are you looking to create?
What format are the answers? Numbers? Text?
1. Add questions
*What is 2 x 2?*
2. Assign cells for the user to insert their answers. (format cells as
3. Either in hidden cells, or on a seperate sheet, put the correct
4. Assign a point value for each correct answer (can be different for
...Creating a new document from a multiple paged Excel document
Can I save only one page of an existing Excel multiple page document? If so,
how? Thanks to anyone that can take the time to answer/instruct.
Right-click the sheet tab that you want, and hit Move or Copy. Choose
"Create a copy" and then, from the dropdown, choose "new book".
**** Hope it helps! ****
Excel VBA Certification Coming Soon!
"Lisa" <Lisa@discussions.microsoft.com> wrote in message
> Can I save only one page of...Can not create Matrix Item please Help RMS 2.0
Can not create Matrix Item please Help
When trying to create any new items I receive error message
This is the message
(-2147217864) Row Cannot be located for updating. Some values may have been
change since it was last read.
Manger still creates standard items but still receives message with out this
number in message -2147217864
...Creating a Word document from an ASP.NET application
I just want to know if there is an existing DLL or Web Compasant that can be
used from an ASP.NET application (located on a IIS server without Office on
it) to create a Word document based on a template (.dot) that is used only
for the bookmarks properties (replaced momentarily with a personnal values).
On Jun 21, 1:34=A0pm, "Bruno MAIGNAN" <bruno.maig...@ca-atlantica.fr>
> I just want to know if there is an existing DLL or Web Compasant that can=
> used from an ASP.NET application (located on a IIS server witho...Is there a work-a-round i can use for making a datagrid....
Hey all, I am trying to make a datagrid on a form that the user would input
info, and once completed, it would be put in correct area's of the workbook.
I cant use a datagrid as job doesn't alw downloads for net so i cant get the
update needed to alw me to use datagrids( see post sugj: "Missing Control In
Addin") is there a way i can use a text box or some other box or tool to do
When you say "form", do you mean UserForm or worksheet set up to look like a
data input form? If a UserForm, then yes, you can use TextBoxes, but you
didn't supp...XY Chart
I have created a short VBA macro that reads x and y data from a spreadsheet,
where every row represents a new series. Besides the x and y data colums, I
also have columns that specify the size of the marker, the markerstyle, and
the foreground and background colors. I have adapted some of John
Walkenbach's code to label each of the datapoints using .name.
The x axis is basically an integer 1 to 5 and the y axis is a value like
price or variable margin. There usually are multiple datapoints on any given
integer on the x axis. For example, I may be plotting the price that a
custom...Nesting? How do I create a table to reference?
Tried to nest more than 8 componets but it did not work. Any help on
creating a table to reference it would be appreciated. Never done it
before. Tried the Excel help, and it was worthless.
Here is my original post that explains more:
mcr1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15496
View this thread: http://www.excelforum.com/showthread.php?threadid=498905
ok you have a two column table.starting in the lh column you...Can anybody tell me what is wrong ...
I am trying to practice multidimensional array in a managed class using
If I tried to compile the following codes, I would get the under mentioned
c2440 error message. It is only practice. You may notice that I am not using
or constructor here. Can anybody tell me what is wrong and how I can rewrite
that line right?
Thanks a lot.
using namespace System;
using namespace std;
__gc class Month
public:...scanner can't read barcodes on paper
My barcode scanner can't seem to read barcodes that I printed out.
I will not barcodes on receipt either.
any suggestions will be great.
I had the same problem. I only had this problem with certain barcodes. When I
looked at the ones that the scanner wasn't reading, I noticed that they all
used lower case letters. As soon as I changed the letters to upper case I was
able to scan the labels.
> My barcode scanner can't seem to read barcodes that I printed out.
> I will not barcodes on receipt either.
> any suggestions will be g...Creating a menu for an MFC Application
Continuing my efforts to understand how to use Visual C++ (in Visual Studio
2008) to create a Windows application, I've come as far as creating a menu.
I haven't been able to find a book that covers the current version of Visual
C++, so am using an older book about Version 4 for general guidance.
I've created a menu. At that stage, the book says to associate the menu with
a class (using the Class Wizard). The method described doesn't apply to the
new version of C++. So far, I haven't been able to find how to associate a
menu with a class. Can anyone provide some help...