Named Cell Ranges
If a range of cells (A1:B5) in worksheet #2 is given a name, and a cell A1
in worksheet #1 equals cell A3 in worksheet #2, does that mean that the
single cell in worksheet #1 is automatically linked (or tied to) the named
range in worksheet #2?
Not automatically no, the name is just a 'handle' to the rage that it refers
"Confused" <Confused@discussions.microsoft.com> wrote in message
> If a range of cells (A1:B5) in worksheet #2 is given a name, and a cell
> in worksheet #1 equa...Workbook name
If I have a list of Excel files in a specific folder, can anyone help me
write a macro to obtain their names and enter it in a range as a list? If
posible without opening the files.
Try using this code:
FillFileNames "C:\\", 1
Public Sub FillFileNames(path As String, column As Integer)
Dim MyFile As String
Dim Counter As Integer
Counter = 1
MyFile = Dir$(path & "*.xls")
Do While MyFile <> ""
Sheet1.Cells(Counter, column).Value = MyFile
MyFile = Dir$
Counter = Counter + 1
H...File Name Length
Does anyone know if filenames can be longer than 31 characters in Office
In article <firstname.lastname@example.org>,
"JM" <email@example.com> wrote:
> Does anyone know if filenames can be longer than 31 characters in Office
> 2004? Thanks.
FIrst, you *can* have filenames longer than 31 characters in Office v.X
already - you just can't generate them. While v.X apps display a hash at
the end of a long filename, it keeps the filename intact when you save.
MS hasn't announced anything regarding long file names in 2004 ye...Extracting First Name from cell with first name and last name
I have searched several posts and am still stumped. I have a first
name and last name in Cell B10 on Sheet1. I want to extract the first
name with no spaces. It is part of a bigger code where I am opening
outlook and making an email. The end result is to use the person's
first name in the saluation. I have all the code to do everything
except that I can't figure out how to grab the first name. Any help
would be greatly appreciated. Thanks in advance.
You probably want this...
=LEFT(A1,FIND(" ",A1&" ")-1)
but be advised that it (and m...Set workbook name not working
I am trying to set the workbookname in a sub procedure but it is not working.
Her are the part from my code that is not working:
Private Sub Start_Click()
Dim MalWb as workbook
Dim MalTxt as String
Set MalWb = Workbooks(ActiveWorkbook.Name)
MalTxt = ActiveWorkbook.Name
' Here I have som code to put data into MalWb
Call ReskontroArk("Kunder", MalTxt)
Private Sub ReskontroArk(ReskontroType, MalTxt As Variant)
Dim MalWb As Workbook
Set MalWb = Workbooks(MalTxt) ' run time error 1004. Canot find file
Can someone ...#Name?
Does anyone know what causes this error and what it means??
Thanks in advance. I'm pretty new at this!
On Fri, 25 Jan 2008 12:32:46 -0500, Access Rookie wrote:
> Does anyone know what causes this error and what it means??
> Thanks in advance. I'm pretty new at this!
Access will display a #Name error whenever it cannot find a field with
a field name entered into an expression.
It may mean the field does not exist or you have simply miss-spelled
the field name, i.e. a control source of:
=[Amonnt] * [Cost]
will display #Name because the field named [Amount] was mis...Publishing charts
We are using Excel to manipulate some real time data then publish the updated
results every 15 minutes to the Internet. I am publishing charts using
Excel's Save as Web Page feature, but then only want to use the images of the
charts as an included image in the actual web pages.
The images end up with names like "xyz_89654_image001.gif". The
"image001.gif" part I don't have a problem with - as long as there is only
one image in each subdirectory, that will be it, and the xyz comes from the
workbook name. It's the number in the middle that I have real prob...Naming a Chart
Excel 2000 Power Programming with VBA states that naming
an object requires selecting the object (such as a chart),
typing the new name in the Name Box, and pressing Enter.
This does work for a shape but not a chart. When I select
a chart and attempt to enter anything in the Name Box, any
entry is not enabled and therefore nothing happens. How
can I assign a name to a chart???
Hold the Shift key (or the Ctrl key), and click on the chart to select it.
Then, type a name in the Name Box, and press the Enter key.
William Bartusek wrote:
> Excel 2000 Power Programming with VBA states tha...Series with named range on several identical sheets
I have named ranges on sheet1 to create my chart.
ChartDates for the X axis
Data1 for the values
I then entered
But Excel rewrote it that way
This is not what I am after, because I am copying the sheet several times
and I would like each graph to get the data from its own sheet (each sheet
has a range named ChartDates and Data1.
Can you help? Thanks
If each sheet has its own ranges ...Changing Domain name on AD and Exchange 2003
My company has been bought out and we have to change the domain name eg
mydomain.com to newdomain.com. How will I go about this without users losing
email or having major down time?
Just to add, we have 2 DC's both are Windows 2003. We have a FE and BE
Exchange 2003 servers with Windows 2003 Enterprise edition.
We also have a DMZ with 2 DC's with Windows 2000. These synchronise with a
Windows 2000 DC in another country.
Would I need to reinstall AD and Exchange or is there an easier method?
This is the steps i was planning on taking:
1. Install spare Server as DC with new ...Lost name when importing contacts from WM to WLM
When I import the contacts (from Windows Mail) into Windows Live Mail, the
contact name is lost, only the e-mail address is imported. The name is lost
and the emal address is shown in the name field in Windown Live Mail. How
can this be corrected?
In Windows Mail, export to a CSV file. Then open that file in in a word
processor or spreadsheet. Verify that that the name field is there.
Verify the first record for the field names and that they match the
fields in the data records below.
If that looks fine, when you import the data in Windows Live Mail, make
sure that the ...Store name on Z report #2
I have a customer that has 2 store with HQ and they would like to have the Z
report to have the store name on it, so they can tell the difference between
Just edit the xReport.xml template file to include the header
information. You can cut and paste the header code from receipt.xml -
just search for "PrintHeader" or something similar to that...
Tiber Creek Consulting
Please DO NOT respond to me directly but post all responses here in the
newsgroup ...repetitive mail
i'd like to send the same e-mail to the same recipients weekly. is it possible to do this in outlook 2003
...Auto reply at domain name
I have exchange 2003 server with different domain names @com @nl @de etc.
We want on one domain name that there is an auto reply.
How can I do this?
just an idea, check this out:
you could use this mailbasket lite to forward all mails for this one domain
to one mailbox, and create an auto reply for that mailbox...
"Patrick" <Patrick@discussions.microsoft.com> wrote in message
> I have exchange 2003 server with different do...how to remove deleted fine names?
When a file is deleted it can often be easily recovered with UNDELETE
software. I'm wanting to completely remove any trace of certain deleted
files, including the file name from FAT's.
I've googled and found the following; there are shredder or WIPE tools which
will overwrite the space a deleted file resided in, but I've found none
which can remove the deleted files name. In fact one comment stated, "in NT
it's not possible to remove (delete) a deleted files name"! Thought that
sounded strange, could do it in W98 with Nut's and Bolts software.
...view by name
Hello, I have a customer that manages someone else's mailbox. We have it
mapped in her outlook as another mailbox in her profile and she has full
rights to it. She needed to find a particular email that was sent to someone
so she went to the sent items and viewed by "To" and typed in the person's
name. There should have been 2 messages that came up as there were 2 that
were sent to that person that day but only one shows up. If I view by date,
then the other one shows up. Now this happens occassionanly, not just this
time. Most of the time if she view's by "to" ...Merging Columns
I need to assign usernames to thousands of users in a spreadsheet. I
have first name and last name in seperate columns. I'd like the
username to be an initial for the first name and the full last name and
have the username be completely in lowercase (see below).
Column A (first name) = John
Column B (last name) = Doe
Column C (username) = jdoe
Is there a formula that could be written that would allow me to do the
above? I haven't been able to find anything in the Excel help files or
on the Web.
Appreciate any assistance...
-----------------------------------------...Showing Worksheet Tab Name in Cell
This is a multi-part message in MIME format.
Does anyone know if it is possible to show the worksheet tab name in =
cell on the worksheet?
Any help would be appreciated.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DCo...How do I hide the names of Addressees in a sent note? ?
I wish to hide the names of the addressees from others when a send a note out
to a broad audience
Put them in the bcc field.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Mark Clemens" <Mark Clemens@discussions.microsoft.com> wrote in message
>I wish to hide the names of the addressees from others when a send a note
> to a broad audience
And if you don't see the bcc field in your email header area, you'll nee...repetitive names.
I am trying to write the script of a movie in a word document.
How could I avoid retyping the name of the person that is talking in the
movie? I want to make sure though, that in every phrase said the name of the
person speaking appears.
Is there any kind of short code that I could give to every personage so I do
not have to write the personage name every time?
what can we find after the universe?
Use AutoText. If you need more details, please tell us which version of Word
you are using.
Terry Farrell - MSWord MVP
"diego" <diego@discussio...Select Names Dialog box in OWA
Ok, so I know you can 'normally' just enter ' ', then find, then all names
appear from the 'GAL' using OWA and IE. But I just saw an OWA with an
alphabet listing along the top of the dialog box and the GAL being
automatically generated in the 'Select Names -- Web Page Dialog' box.
Where's that setting in Exchange 2003?
Windows 2k3, w/Exchange 2k3. Not running SSL, either instance.
Thanks in advance.
...create a rewrite rule for the domain name?
I've a scenario where I receive an email to a distribution list on my
exchange 2003 server from a paging service - skytel.com - that is
distributed to local support reps as well as needs to go back out to another
page at the same skytel.com paging service.
skytel.com sees the message coming from skytel.com and doesnt accept it.
Is there a way for me to set up a scenario where I change who the orginal
message is coming from or change the domainname when sending back out to
skytel.com so it will accept it?
I looked at trying to set up a rule on a mailbox but they all forwar...friendly device name
Any one know how to grab the friendly device name? ( ie: \\tape1 )
> Any one know how to grab the friendly device name? ( ie: \\tape1 )
> Jeremiah Thoman
You are probably looking for QueryDosDevice
Scott McPhillips [VC++ MVP]
I guess I need to refine what I am looking for. I am trying to find a
way to relate the friendly name with the device name ( ie: tape1 with
SCSI device name, etc... )
I hope this helps and thank you for your help
Scott McPhillips [MVP] wrote:
> thomanjl wrote:
> &g...Naming a chart created with VBA
This might be a simple question, but I don't seem to find the answer.
So, is there any way to name a chart that is created with VBA? I need
the chart to be named so that I can do "things" to it. :-)
Thank you in advance
Message posted from http://www.ExcelForum.com/
You didn't post your code but try
ActiveChart.Name = "whatever"
"excelnoob >" <<firstname.lastname@example.org> wrote in message
> This might b...Printing mailing labels with multiple recipient name records associated with a single address
I have been browsing this, and other Access groups, as well as some of
the Microsoft KB articles, and while I find posts decribing similar
objectives to mine, can't seem to find anything that specifically
shows me how to solve my problem.
I have a property management database which contains many related
tables, including a table "Units" and a table "Tenants". Tenant
records have a corresponding foreign key for the UnitID relating them
to the Units table. A tenant can only be associated with one Unit
record, but a Unit may be associated with many Tenant records. I need