How can you define Page name as a function of other variables.
I'm using visio 2002.
I am able to include the value of the "Page name" to define anothe
variable, simply by referencing "pagename()" in the formula.
However, is it possible to define the "Page name" as a function o
other values on the sheet?
For example: Could I define the page name in this fashion :
where "bluebox.39" is a shape on the sheet.
If so where do I do this..? I can't find the pagename cell on the pag
shapeshee...Tab in text box
I have a form with 11 text boxes. If I tab, tab, tab.... through the boxes
after the last box my data in all the boxes goes blank. Can someone tell me
why and how to fix this problem?
"Phillip" <Phillip@discussions.microsoft.com> wrote in message
> I have a form with 11 text boxes. If I tab, tab, tab.... through the
> after the last box my data in all the boxes goes blank. Can someone tell
> why and how to fix this problem?
It sounds to me ...Getting the values in a named range
I want to list, in the inmediate windows, the values of the named
ranges in my workbook. I prefer, if possible, not having to specify
the worksheet names.
I've tried the following code:
For Each n In Names
Debug.Print n, n.Name
a = n.Value
however I would like something like
is this possible?
Na...How can I add a recurring footer (name/address) to new messages?
We recently received an email from a customer with their company name and
address centered at the bottom of the page as you would have on company
stationery. How can we implement this in Outlook for our emails?
Click the "Center" button in the Signature dialog box after selecting
Cyn @ Spectrum wrote:
> We recently received an email from a customer with their company name and
> address centered at the bottom of the page as you would have on company
> stationery. How can we implement this in Outlook for our emails?
...Writing XML file from dataset without DS name
I have an XML file from a client that I generated a schema from.
I Open a DataSet and read the schema to get the tables and relationships. I
write my tables and fields and assign parent rows etc. When I write the
data, the output file has a new wrapper element with the name of dataset. Is
there a way to write the XML from the dataset without this wrapper? I also
need to provide the encoding attribute like the input file.
Example input XML
<?xml version="1.0" encoding="ISO-8859-1"?>
<Customer Name="XXX" Trigram="XXX">
<InputFil...how to combine several tabs on a spreadsheet into a summary tab w.
I have a spreadsheet with several tabs containing contact information by city
( each tab represent a city) I now would like to combine them into a summary
Tab containing all the information.
Copy and paste, perhaps?
On Sat, 4 Dec 2004 19:15:03 -0800, "adeeb" <firstname.lastname@example.org>
>I have a spreadsheet with several tabs containing contact information by city
>( each tab represent a city) I now would like to combine them into a summary
>Tab containing all the information.
Here is a macro solution
-...'struct' type redefinition error while including <winioctl.h>
i am facing a problem while getting hard disk information. when i use
in New MFC exe project it works well. But i when i use this code in my
original project which is also MFC Dialog bbased application with
these liberaries included
Ws2_32.lib Winmm.lib Vfw32.lib
the compiler gives 'struct' type redefinition error.
When i comment <winioctl.h> it give different errors but errors but
not the earlier one.
Could anybody please help me out.
Thanks in advance...
Why you think the sequence of lib files to the linker should have any impact on the
compiler escapes me...Clearing Automatic Name Checking/Suggestion
Does anyone know how to clear the memory setting for automatic name
checking? When it suggests an email address, it gives me an old one
or incorrect one from my outlook that is no longer in my Contacts and
Please advise, I've already tried turning the settings on and off with
...Include Dropdowns and Checkboxes in Worksheet Change event
I am tracking the changes made to cells in the spreadsheet and that is
working. However, there are three active X dropdown lists objects and
numerous check boxes that are not trapped. Each is linked to a cell on the
same sheet in a hidden area that is updated when their values change. I have
code to trap the cells that are changed and execute additional code.
The code in the worksheet change event is;
Private Sub Worksheet_Change(ByVal Target As Range)
Dim tCell As Range
Call ChangeOrder(tCell, tSheet)
In the worksheet module is this code;
Sub ChangeOrder(tCell As Rang...Named Ranges in Formulas
I have a worksheet with four columns -
Percent to total Hours
Value of Hours
Percent to total Value of Hours
The row with the total varies, so in my macro I have named the row with the
total TOT_HOURS (=a and whatever the last row is)
In column B, on each row, I perform the calc b1/tot_hours, etc., to get the
percent to total.
How could I make tot_hours relational, that is, when I copy the formula to
column d, have tot_hours refer to column c instead of column a?
Just copying the formulas doesn't work.
more detail and sample formulas
Please help me.
I need to select a range based on a start location that's diferent sheet by
I tried but i couldn't make it.
The start position it's variable depends on that i have select cell, and the
final position is U3000. I want select this range and them delete all the
rows of the range.
If you really want to delete the rows, one way:
Range(ActiveCell.Row & ":3000").Delete
If you just want to delete the cells in the range from ActiveCell to
U3000, one way:
Range(ActiveCell, Cells(3000,21)).Dele...Email Display Name As
Using 2003 with BCM V2...
Sometimes I have the hardest time changing an email so that it displays
correctly. Usually, it will add the persons name automatically, but
sometimes it won't.
I change an email/contact person by
1) change the contact name in the contact record
2) double click on the email
3) change the email
4) click OK
Sometimes the Display as has the person name from the contact field, other
times it is the email only, with NO way to correct it.
Your post probably makes sense to you because you know what you mean. No one
else could, however.
To ..."You cannot open two documents with the same name" message problem
I am wondering if anyone has a solution on this.
There is a Word 2007 file (docx) that has links to an Excel file.
They are both resided in the same folder. When the files are moved to
another folder, the link path does not get updated =96 which I
understand. But when the Word file is first opened, the following
message came up:
A document with the name "xxx.xlsm" is already open. You cannot open
two documents with the same name, even if the documents are in
different folders. To open the second documents, either close the
document that's currently open...Force outlook to go to AD to get Exchange server name
I've this quesitons about Microsoft Outlook 2000/2003
clients (MAPI) for Exchange 2000 and 2003 servers.
How can I force the Outlook clients to go to AD to find
out which exchange server is holding the mailbox of the
user? I want to do that every time clients starts or
refresh it if it is already running. This way I don't
have to reconfigure (or "Check Name") them whenever I
move mailbox of the user from one exchange server to
another in the organization.
You shouldn't have to do that. When Outlook connects, it should get the Home
Server attribute f...How do I export names from a distribution lists
I would like to copy the names from my distribution lists in outlook to
another program so I don't have to retype them all.
What version of Outlook?
>I would like to copy the names from my distribution lists
in outlook to
>another program so I don't have to retype them all.
I am using Outlook 2000
"Chuck Davis" wrote:
> What version of Outlook?
> >-----Original Message-----
> >I would like to copy the names from my distribution lists
> in outlook to
> >another program so I don't have to retype ...How do I refer to a cell from header
How can I customize the header to refer to a specific cell in th
istor's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1576
View this thread: http://www.excelforum.com/showthread.php?threadid=27273
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim sText As String
.PageSetup.LeftHeader = .Range("A1").Value
"istor" <email@example.com> wrote in message
news:ist...Worksheet name variables
I have a project that requires me to copy mutiple worksheets to one hub
worksheet. Is there a way to make the worksheet name a variable?
This is what i have so far:
The Period8224a name will change like 50 to 100 times. If there was a way
to reference the name of the sheet from a cell on the hub sheet like this:
with the "X1" cell containing the worksheet name.
You can use the “Indirect” function to get the name of the worksheet into a
formula. Assume the name of ...OWA Find Names
When using OWA, you look up recipients for an e-mail using the "Find Names"
window. It appears that the maximum number of results that will be returned
is set at 100, with no customization obviously apparent from the OWA
interface. I completely understand why you wouldn't want this number to get
too high, especially in a large organization, but I have a need to increase
it to at least 200, if not 250.
Is there registry key where this can be controlled? Perhaps a way to set
something in the IIS metabase? Any help is greatly appreciated.
On Mon, 6 Feb 2006 13:34:17 -080...Matching names
Please help! I work with large Excel spreadsheets with tons of columns of
data involving hospital inpatient census. I have been trying to find a way
to write in VBA a way to match the names of hospitals in eg. column C with
their nurses in eg column G. I can autofilter the names, etc, but can't
figure out how to match up all the hospitals with name MEDCENTRAL with nurse
JANE. Is this an IF/THEN function? If so, I can't get the syntax right.
My main problem seems to be isolating only the visible part of column G
when I autofilter and select the nurse name. Is there a funct...Making Name Tags
I am tasked in making Name Tags(Labels) from the Names from my database. I
have created a query of the just the [First Name] and [Last Name] of all
needed employee names. I am not quite sure where to go from here, so an
guidance will be appreciated.
In Access2003 you have a reportwizard which includes a wizard to create
address labels (make sure the reports 'tab' is visible and click 'New'.
Maybe you can start there and use your query.
"Eric Starn" <EricStarn@discussions.microsoft.com> schreef in bericht
news:55845B3C-249A-47B...sorting customer name and IP with value
any script to sort following list?
i have the following IP address, customer name and value
A B C
IP address customer name value
10.10.10.1 Lee 10
10.10.10.2 wong 30
10.10.10.3 chan 40
10.10.10.4 chan 15
10.10.10.9 wong 16
10.10.10.11 Lee ...OWA check names search limits
Does anyone know if the 100 search item limit can be increased for OWA
check names. I know that you can customise standard searches up to 1000
items but the check names appears to be different.
Yesterday night we started receiving lots of errors on our Exchange 2003 SP1
server (Exchange is in native mode). Server reports that there are constant
attempts to create named properties, so that the quota (36K) had been
exceeded. Here's the typical error message:
1) Event ID 9667, source: MSExchangeIS, Category: General
Failed to create a new named property for database "First Storage
Group\Mailbox Store (MVEXCH1)" because the number of named properties
reached the quota limit (16384).
User attempting to create the named property: "BESAdmin"
Named prope...distribution list - hide names
What is the BEST way to send the same email message to a large group of
customers, but control what the recipient sees in the "To:" field of the
email they receive?
Sample distribution list "My Customers"
Miles Smith (firstname.lastname@example.org)
Michael Dell (email@example.com)
Steve Balmer (firstname.lastname@example.org)
I know by default that when I choose a distribution list such as "My
Customers" in the "To" field when I create the message, it looks like To: +
My Customers on my screen, but when the email is received by each person,
their email looks like
"T...Can't change a cell name back
I had a cell named "MP2OZ". It was supposed to be "ML2OZ" for
milliliters to ounces. When I noticed the typo, I selected the cell,
then clicked in the Name Box, and typed the correct name.
As soon as I did it, I realized that this would not change the
formulas that use that name. So, I changed it back (to MP2OZ) and then
opened up the Name Manager (Ctrl+F3) and tried to change MP2OZ to
ML2OZ. The Name Manager says that both the old and new names are
already in use and to choose a different name.
But the Name Manager only shows the one name (MP2OZ). It does not show