Linked cells in Multiple Workbooks
I am tracking dates and have linked cells from another workbook so as t
not have to duplicate the data entry of dates. The dates are linked t
projects that are listed in rows and there is information in m
workbook that is additional information within the row. So if someon
changes the order of the other workbook, the information that is in m
workbook does not get sorted with the order. Is there a way to link m
cells to the linked cells?
Project ID Start Date Milestone
EndDate Person Assigned
1234 (linked) 11/15/04 11/20/04(lin...How can I bind the results of Web service to a ListView?
I'm new to ASP.NET so I apologize if this is a basic question.
I have a Web application. This web application has a ListView on it.
For this web app I make calls to a web service which returns data from a
database. I return the data using the following format:
public List<Record> Search()
List<Record> list = new List<Record>();
/* Populate list with data from a db */
public class Record
public String name;
public String address;
public int ageInYears;
Now I would like from the Web Appl...How can I search for a ? in Publisher?
I did a Search & Replace and somehow ? marks were placed throughout my
32-page document. I want to be sure I found them all, but when I search for
?, it stops at every letter.
Appreciate some advice. Thanks.
It doesn't work for me either. It doesn't work in 2010 as well. You can
checkmark *Match whole words only* Publisher will look between each word rather
than each letter. Not much help when you are dealing with 32 pages.
"guymaine" <email@example.com> wrote in message
news:B89D6FF6-B7...Importing a .cdr file in Publisher 2007
Hi there, someone has sent me a .cdr file, is there a way to import it into
You can import a .cdr file in 2007. Not sure about the version however. I cannot
import CorelDraw 12 images into Publisher. Your sender can convert the .cdr in
Corel to a .wmf or .emf or any other format.
Try importing, Insert, picture, from file.
If your sender cannot convert the file, send it to me and I will convert it for
mary-sauer at columbus.rr.com
Mary Sauer MSFT MVP
"Ulli" <Ul...Formatting four pages onto one 12x18 sheet
I'm trying to figure out how to format a 12 x 18 sheet with four individual
5.5 x 8.5 pages on it. Any ideas? The closest I can get is under page
setup...selecting "postcards" and that will give me three pages per sheet,
but I need four.
Any ideas or thoughts are greatly appreciated.
If your printer can be custom setup to 12 x 18 then you can divide it into four
parts. Are you sure you aren't trying to setup a 11 x 17 landscaped sheet? In
any event, setup your printer first.
File, Page Setup, Advanced on the right, type 18 width, 12 height or 17 width,
11 ...Problem using Microsoft Web Browser control
I am trying to access the Custom properties of a Web Browser ActiveX control
on a form and I keep getting a message telling me that "The Operation on the
Microsoft Web Browser object failed. The OLE server may not be registered.
To register the OLE server, reinstall it."
I searched TechNet and MSDN and could not resolve this. I reinstalled Access
2003 (I have 2003 and 2007 installed on my workstation, XP Pro) and still no
Has anyone else seen this and if so, can you tell me how to resolve this?
Does anyone know the name of the file the message...How to open workbook without hardcoding path
Could anyone tell me how to open a workbook from another workbook, where
both files are in the same folder, without hardcoding the path. I have tried
code like this without success.
Workbooks.open (path & "\somefile.xls")
Thanks in advance
Excel automatically looks in the current folder, so :-
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
...Converting Publisher 2002 catalog to PDF
I created a catalog using Publisher 2002. Now I need to
convert it to PDF. The problem is that when I convert if,
the pages do not appear in consecutive order (i.e., the
first page of the catalog appears with the last page).
Does anyone have a solution for this problem?
Are you producing the catalog as a saddle-stitched book? What you are
getting is printer's/press spreads, which, unless it is going on a large
format press, is probably fine for your printer. If you are printing
separate sheets to be bound by a different method, or if it is going on a
large format press, and the printe...click on page form tab to filter subform
I have page tab with following names: Flat Rate, Global Rate, MSRP Rate. I
would like to have subform only show the rates for each page tab. How do I
go about doing this. I am new to VBA and from reading all the threads, I
can't seem to find the one that fits my exact need. Please explain
step-by-step since I am new. Let me know if I need to provide more details.
Presumably you have a field in the RecordSource of your subform that
contains one of the three values (Flat Rate, Global Rate, MSRP Rate) or some
other text or code that corresponds to these values....One link breaks every time I open a workbook...
I have 3 workbooks tied together with links. One is a source only, the other
two push and pull data.
One of the sources, Payroll Master, on opening updates all links fine to the
source only workbook but not
to the third workbook (which is in the parent directory). Every time I open
it it prompts me to show it where the Payroll Entry is. Doesn't matter if I
hit cancel and
do Edit Links, I can change it there, but will still lose it upon closing
(the link appears in the box and looks ok, just won't update...)
Try going Edit->Links. Break the link and re-establish it? That m...How do I look at two worksheets in one Excel workbook at same time
I know how to arrange windows to look at multiple workbooks. But I want to
have two worksheets displayed at the same time from the same workbook. Is
there a way to do that?
Window - New Window
this will create a second view of active workbook. Then you can do Window -
Arrange, active workbook only.
"PeoriaJean" <PeoriaJean@discussions.microsoft.com> wrote in message
>I know how to arrange windows to look at multiple workbooks. But I want to
> have two worksheets di...Signature page not printed for Credit card transaction
I have set up new POS system and the POS system does not print
signature page for credit card use.
I check 'require signarue' for the receipt from tender type window and
print Z-out to apply it but it still does not printing out the
Please be advised.
thank you for your help!
This is a multi-part message in MIME format.
Make sure the receipt is set to print it. Manager | Database | Register =
Lis...Biggest worldwide free Entertainment multi language Video web , Travel, Sports, Health , Racing cars , Massages techniques, Games , Fashions, Jokes , Top models , Free online IT learning , 5000 l
I'd like to introduce you 2 biggest free Video multi language
entertainment websites :
...Publisher font issue
I have an issue with Publisher 2000 and the calendar font
size. The defaulted font size is 18. In each calendar
date box, when I enter information is a smaller font (8
font), and save; close the program and then reopen; the 8
font text defaults to 18 font. I need the smaller font
for information that needs to go into the calendar. I
have tried a few tings through the help feature but
nothing I do seems to work. Can someone help me with this
or tell me how to fix this problem?
Try this, put the calendar on the background (master page) Ctrl + m , use text boxes
for your i...how to use a saved master page
I have created a new master page and saved it as a .pub file. The question
is when opening a new document, how do I apply the saved master file?
Open the master file, copy, paste to your new publication.
Mary Sauer MSFT MVP
"Colin" <Colin @discussions.microsoft.com> wrote in message
>I have created a new master page and saved it as a .pub file. The question
> is when opening a new document, how do I apply the saved mas...Do I need Publisher installed to read/edit articles in an e-mail?
I will be receiving e-mails with attachments containing Publisher2002 created
articles. Do I need to have Publisher 2002 or later editions in order to
read and edit these e-mail articles?
On Mon, 7 Nov 2005 22:20:03 +0000, quilter512 wrote
(in article <E5DAA762-0ABA-49C2-8DDB-9A0D05162496@microsoft.com>):
> I will be receiving e-mails with attachments containing Publisher2002 created
> articles. Do I need to have Publisher 2002 or later editions in order to
> read and edit these e-mail articles?
You can answer your own question by STFW. You not heard of Google Grou...Workbook there but not visible! Help!
I was working on some VBA code for an excel application I
am writing. I switched between the VBE and the
spreadsheet and all of a sudden my workbook is no longer
visible! In the VBE project explorer window it shows my
project and my code but in the excel window...no
Ran a test procedure calling IsAddin to see if somehow I
accidentally clicked a button/box telling Excel to make
this file an addin but it returned false.
I did close the file and re-open it.
Maybe it's just off the visible screen:
Window|Arrange|tiled (and resize manually)
or maybe y...Conditional Formatting for Image box on Continuous Forms
This problem is driving me crazy. I am a car enthusiast and love
taking photos of classic cars. I have a table which describes the
make and model in a series of fields. There are several fields that
contain a reference to photos of those cars. Ie: the fields are
called "Front" "Side" "Rear" "Angle". My form has four image boxes to
display the images stored in these fields. But when I open the form
all the records show the images of the first car only.
I asked about this a few days ago and was advised to check out
http://www.lebans.co...Loading Publisher 2003 on to Vista Home Premium
I have recently bought a new computer with Vista Home Premium, but my
Publisher 2003 will not load as it states there is no Windows XP or 2000
running. Quite right, but do I really have to buy the 2007 version? As a UK
charity we have bought the Student 2007 office version - is there a student
version of Publisher 2007?
Mark Ward Senior User
Try installing in safe mode.
Do you get an error other than there is no XP or 2000.
Publisher 2003 should install on Vista.
List of system requirements for Microsoft Office 2003
Mary Sauer MSFT ...page numbers in Word 2007
I have a Microsoft Word 2007 document which has a title and
table of contents on the first page and the various chapters on
the following pages. I have used an automatic TOC and then
clicked on the Insert tab and then Page Number -> Bottom of
Page to insert page numbers.
My problem is that I don't want the first page to be numbered
so that the second page starts with the number 1.
I have tried clicking Page Number -> Format Page Numbers...
to set the first page number at zero but then when I delete the
zero all page numbers are deleted by Word 2007 just as th...Help! New to Publisher
What is the A...at the bottom of a page inside a small
box? I am typing a newsletter. Shouldn't one page flow
to the next like in Microsoft Office? If it is text
overflow, I cannot retrieve. What am I doing wrong?
That indicates that there is more text inside that area that cannot be seen.
If you stretch that text box down, you'll see the rest of your text. To make
it flow from one box to another, you need to set it up for that. (I will
admit that I break mine manually because I've never taken the time to learn
how to do it correctly.)
The problem with ...How do I publish to the web a 3 page web pubblication from Publis.
I created a 3 page web publication in Publisher 2003, but when I 'publish it
to the web', only the first page is converted. What do I need to do?
Review the FAQ - http://www.publishermvps.com/Default.aspx?tabid=30
David Bartosik - MS MVP
"Bazbo" <Bazbo@discussions.microsoft.com> wrote in message
> I created a 3 page web publication in Publisher 2003, but when I 'publish
> to the web', only the first page is converted. What do I need to do?
...publisher screen pulsing
my publisher file won't stop flashing or pulsing and its driving me crazy!
is it because my files is too large?
Wouldn't think large files would cause pulsating. How current is your video driver?
Do you have high contrast enabled in the accessibility options?
Mary Sauer MSFT MVP
"Bridget" <Bridget@discussions.microsoft.com> wrote in message
> my publisher file won't stop flashing or pulsing and its driving me crazy!...blank page prints after group (sometimes)
I have report of students with the class_id defined as a group. "Force New
Page" is defined "Before Section".
Whether I have a page and a group header defined (they can be the same anyway)
or just a page header defined, I am getting the same problem:
27 students can fit onto a page. However, if there is a class of 25 students,
the next page is blank except for the header. (I have not seen a class of
27 students so I have not tested that yet).
I can't seem to find a way out of it. Where I am I going wrong?
Message posted via AccessMonster.com
http://www.acce...Batch conversion between publisher versions.
My parents downloaded the trial of office 2007, unknown to me, and created
lots of documents that are quite important. The trial has expired, is there a
way to batch convert these to publisher 2000 format, as that is what they
were using before. There is 100+documents.
No, there is no batch conversion. Your only recourse would be to buy Publisher
2002, 2003 or 2007. Or find some kind soul to convert the files for you, one at
a time. This conversion isn't necessary with newer versions of Publisher because
the newer versions will open 2000 files.
Mary Sauer MSFT MVP