Naming Ranges #4
When I name a Range on Sheet1, then make a Copy of Sheet1 to say Sheet2,
then access the Define Names dialogbox, I can see the named Range listed
twice. One is noted as belonging specifically to Sheet2 and the other appears
without a sheet reference.
When assiging a name to a Range, can I specify that it belongs to a certain
Also, how would I change this code to assign the sheet name aswell?
ActiveWorkbook.Names.Add Name:="myRange", RefersToR1C1:="=Sheet1!R1C1:R10C1"
I am trying to assign a the name 'Column_Header_Range' to each sheet in my
work...suggest names (outlook 2002)
in the autocomplete function, is there a way to access the database? I've
got old addresses in there that I used once a year ago causing a drop-down
list when I've only got one matching entry in my address book... so what I'd
like to do is either clear it out completely or at least delete the obsolete
entries, I've looked in the registry and it isn't there... any suggestions
would be appreciated, thanks!
Remove individual addresses from the autocompletion cache by highlighting
the entry when presented in the suggested names list (use your arrow key to
migrate to...One domain on exchange server not accepting connections
I setup a second domain on an Exchange 2003 server, and thought
everything was working. Now, though, mail going to the second domain
gets rejected, but mail going to the original domain is still working.
I can telnet to the original domain, but not to the second domain.
I've checked everything I know to check (I've setup plenty of domains
on Exchange servers, so I believe I've gotten the setting correct), but
I just can't get it to work.
The MX records are correct, and mail.theseconddomain.com resolves to
the right IP address (the same IP as mail.originaldomain.com), so it
sh...need to reload 2007 home/student have prod key
where do i go to reload 2007 home/student i have product key
On 2/04/2010 7:21 PM, howie2006 wrote:
> where do i go to reload 2007 home/student i have product key
Where is the CD?
On 2/04/2010 7:21 PM, howie2006 wrote:
> where do i go to reload 2007 home/student i have product key
Sorry that was not very helpful. If you had the CD you would not be
posting here. The only thing I could find was a 60 day Office
Can i upgrade OWA 5.5 to OWA 2003.
On Thu, 16 Jun 2005 10:32:07 -0700, Manish
>Can i upgrade OWA 5.5 to OWA 2003.
Following the proper stesp, yes.
Can you tell me the steps.
"Andy David - MVP" wrote:
> On Thu, 16 Jun 2005 10:32:07 -0700, Manish
> <Manish@discussions.microsoft.com> wrote:
> >Can i upgrade OWA 5.5 to OWA 2003.
> Following the proper stesp, yes.
> ...HTML Attachment in OWA on Exchange 2000
OWA on our Exchange server is changing html attachments. If the attachment is
opened through Outlook 2000 or 2003, there is no problem. If it is opened
through OWA, the file is changed. Here is an example of Outlook vs OWA:
(copied from someone else's post who asked the same question that wasn't
<FORM action="http://18.104.22.168:8080/QmsPOSTCmd/" method=post>
--OWA Modified file--
<ME...Contacts in OWA
I have a public folder with all of our corporate
contacts. When I open this contacts folder in OWA each
contact is dsiplayed as a message. The creator is in the
from field,the subject is the contact name, and the
description is the actual message. It is obvious
something is not setup correctly. They work in Outlook
but how do I get my contacts to diplay correct in OWA?
http://support.microsoft.c...OWA Display Settings
Is there a method to clear the Web Access Display Settings (i.e. Color
Schemes, Preview Pane setup) from the server side of the application for
either a single user or all OWA users? Also, I've had several users report
that if they've attempted to access their OWA mailbox in FireFox, they lose
the way messages are normally displayed in the OWA client where each message
basically has two lines, one line for who it came from and when and the next
line for the subject. After logging to OWA with Firefox, all of the
information is displayed on a single line.
This is on a Windows...OWA
I have one computer that when trying to access exchange 2003 via OWA the messages are not listed. The message count is correct and all folders are there and visible but no message list or anything in the reading pane. Anybody have a fix?
Are there no replies to this? I've found several others
asking the same question here and getting no answers at
EX2K3 on Win2K3 enterprise server, problem seems to be a
client one as the same mailbox can successfully be
accessed from other computers and this computer has same
behaviour for all mailboxes.
>I ...NEED HELP-wrong formatting saved ??
After using word 2007 and saving a word file, it changed the formatting from
the previous file (i think it was .wps microsoft works word processor) and
now its all messed up.....I think I saved it in some other wrong encoding
standard......now, whenever I open this file now half of it is in some weird
looking unreadable characters....like this
is what seems to happen once the system breaks its laws from the inside.
......couldnt find online solutions...does anyone have any suggestions or
s...OWA not work properly
When users go to http://sitename/exchange they get the yellow OWA screen
without the graphics.
If I enter username, I get "HTTP Error 404 - Not Found". I have NT 4.0 SP6a,
Exchange 5.5 SP4, and IIS 4.0 with all the latest updates.
In Internet Service Manager, in the Default Web Site properties, I have the
redirect to the above URL in the Home Directory tab. Under the Directory
Security tab I have both Anonymous and Challenge/Response.
In the Exchange folder properties (in Internet Service Manager) under the
Virtual Directory tab I have the Local Path "c:\exchsrvr\webdata&quo...I have over 100 excel sheets i need put in alphabetic order,how?
Background: I have an index page with hyperlinks to each sheet, each sheet
has a COUNT function to add the entries and a SUM function on the index page
which adds the result of each COUNT function, to do that I used
"SUM(Birmingham:Worcester'!B2)" as each sheet has a geographical name a newly
added sheet may not fall within the specified range and therefore may not be
added. Is there a way to alphabetise these sheets?
Rob, have a look here,
Always backup your data before trying something new
Please post any response to t...Clearing Log Files
What is the method for clearing exchange log files. These
file take up more space than the database.
I suspect the files you are talking about are the Transaction Log files.
These are important files and need to be managed correctly. Performing an
online backup will truncate these logs. Or if you don't require backups
then turn on circular logging.
Here's some more info..
"Bill" <email@example.com> wr...NDR Help
I hope someone can help on this.
A few people have complained they cannot e-mail to us always. They get an
NDR. This is very intermittent it seems and not everyone is affected.
They have forwarded the NDR they have received. I've attached it below. I
can't work out if our mail server has sent that to them or if it is
generated by their company e-mail server. This happens mainly with one
company but i think it has happened to some others as well - i can't be sure
but the one company mainly (or even only).
It is odd in that they can e-mail and get through then do it aga...Annoying event log message #1
On my Exchange 2003 server (on Windows Server 2003) I see a System event
logged approx every 20 minutes that says "The WMI Performance Adapter service
was successfully sent a start control" followed by "The WMI Performance
Adapter service entered the running state" then "The WMI Performance Adapter
service entered the stopped state". I understand that this messages are
purely informational and that the Windows Management Instrumentation service
is required in order to run the Microsoft Exchange Management service.
How can I get the system to stop re...Corporate Name Change
How does one change the name of a stock (and symbol) when
a company (such as AOL) decides to do so
Select AOL from your portfolio, right click and choose "see details"
You can rename it and change the symbol there.
"Wade" <firstname.lastname@example.org> wrote in message
> How does one change the name of a stock (and symbol) when
> a company (such as AOL) decides to do so
Thanks ... I get an error stating the ticker is already
in use. How can I get around this (is there a global
ticker li...get network login name
I have the following code to get the network login name:
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _
"GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
Function fOSUserName() As String
' Returns the network login name
Dim lngLen As Long, lngX As Long
Dim strUserName As String
strUserName = String$(254, 0)
lngLen = 255
lngX = apiGetUserName(strUserName, lngLen)
If lngX <> 0 Then
fOSUserName = Left$(strUserName, lngLen - 1)
fOSUserName = vbNullString
E...*CANT log into Windows -please help
Hi, I need step by step instructions on how to use my recovery console CD in
order to fix a problem.
Here is my prob:
A virus/malware scan I did probably messed up my logon file.
The antivrus program either removed or quaranteined the virus/trojan that
was attached to my logon file. Because when AVG prompted me to reboot after
this scan, It stopped at the welcome screen logon part. I click on my user
name (only one there) and it says its logging on...But then it says saving
settings and nothing else happens. My machine does not reboot or anything.
It just stays at this logon sc...named ranges in other workbooks
i have a range of cells whose values are validated from a list determined by
the name is determined by a formula which references a range of cells in a
different workbook (i'm on a office network...)
the problem is:
if the other workbook is open (on my desktop?) the name is o.k. and the
validation is fine...
if the other workbook is not open, the name results in an error
i didn't think that this is the way it's suppose to work...
Do you use a full reference such as ='C:\Documents and Settings\Owner\My
Bernar...how do I find a list of databases with correpsponding company name
I need to know how in GP to pull up a list of our companies with their
corresponding SQL database names. I've done this a long time ago and
remember it being easy but cannot remember where to do this.
SELECT INTERID, CMPNYNAM FROM DYNAMICS..SY01500
"Tim Quiggle" <Tim Quiggle@discussions.microsoft.com> wrote in message
> I need to know how in GP to pull up a list of our companies with their
> corresponding SQL database names. I've done this a long time ago and
> rem...Recordset Help Needed
I have the below code that works some of the times, but not all. Here is my
issue. If there is no records in the table it works the first time. Then when
I go to add another record it says "No Current Record". If I close the form
and then re-open it, it work. I thought by adding the Set rs = Nothing it may
help. It did seem to do anything.
Private Sub TRAN_TYPE_DblClick(Cancel As Integer)
Dim rs As DAO.Recordset
Dim rs1 As DAO.Recordset
'Save any edits
If Me.Dirty Then
Me.Dirty = False
'Check there is an order in the form.
If...Need an advice on hardware specs
i need and advice
I have one server (two AMD Opteron 1.6, 4gb of ram, raid) with
MSCRM (30 users)
Sharepoint (60 users)
MS Project Server (30 users)
I wonder if i benefit if i move web to another machine (single P4 1.6,
1GB ram, 1 hdd) and leave the first server for SQL only.
I would appreciate any comments.
Well, it really depends. Have you been monitoring the server? Is it
resource constrained in any area? The extra server may help, but if the
current server is not CPU or Memory constrained and you aren't hitting I/O
constraints, you won't buy...need basic help setting up a graph
I am trying to set up a chart of days and times. The X- axis shoul
have the days of the week (mon, tues, etc) and the Y - axis should hav
various times of the day. I would like to have a line from on
specific time on one day to another specific time on the next. So,
point would be monday at 10:00 and the next would be tuesday at 1:00
followed by wednesday at 12:00, etc. Any suggestions?? Thanks fo
Message posted from http://www.ExcelForum.com
See my attachment. Is that the situation you explained?
I use formula
in column ...need to allow negative quantitys on purchase orders
because our vendors list returns and exchanges on invoice i need the abillity
to enter negative quantitys when recieving manually.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us...Newbie Needs Help With Formatting E-Mails
Newbie Needs Help With Formatting E-Mails
I'm new to this site and would appreciate some formatting help.
I created a new Word doc and copied and pasted some graphics and some
simple text boxes in to it. The graphics and text boxes were created
in Powerpoint by someone else. Looks fine on my screen.
Before sending it out via e-mail to an Outlook e-mail group I have, I
first sent myself a test message to see what it would look like on the
receiving end. It looks a mess! The text boxes are all over the
place, as is the text that is not in a box. Also, everything slide
over to ...