How do I get excel to accept (c) as text and not change to copyri.How do I enter the text (c) in Excel without having it changed into the
copyright symbol?
Hi Daffyd,
Try:
Tools | Autocorrect | Select (c) | Delete | OK
---
Regards,
Norman
"daffyd" <daffyd@discussions.microsoft.com> wrote in message
news:8CCC3C1A-6F19-4F62-B934-8A71F236A4FD@microsoft.com...
> How do I enter the text (c) in Excel without having it changed into the
> copyright symbol?
Go into the Tools Menu. Look for AutoCorrect. In the bottom half of the
AutoCorrect Tab, look at the list for Replace text as you type. Delete the
entry for (c).
tj
"da...
Inserting charts into many workbooksHi,
I'm using Excel 2007 and am pretty new to VBA. I have a folder with 40
or so workbooks- all with the same worksheet table format. The worksheets
are huge (20 000 + rows, 50 or so columns). I need to open a workbook, make
several fully formatted graphs, then insert the same graphs into every
workbook , updated them with that workbooks' data.
Any ideas on code for this?
This isn't fully automated, but it will save some time. In one workbook,
create the chart and format it to your specs. Then paste the chart into
another workbook, and use the utility linked to i...
Setting series values on Excel ChartHi
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as i...
Convert single colum/multiple rows to multiple colums.Hi,
I have a .dat file when opened with Excel it has 1 column and 7 rows per
entry. I would like to delete some rows and convert the rest to something
like. Any chance this can be done. It's quite large. 51,793 rows.
TIA
Jeff
Col 1 Col 2 Col 3
Name Date Lenny Kravitz - 2000 - Greatest Hits
-- Table: {2}
{
"music"
"Name",
"06/04/2008",
"Lenny Kravitz - 2000 - Greatest Hits",
},
--Table: {3}
etc.
etc.
...
Timestamp value of GINA window presentationI am currently troubleshooting slow logon times for a client with computer
infrastructure spread across the globe. Before I start invesagating I want to
create a baseline for logon times.
I have modified the clients logon script to record when it starts and when
it ends. I am using the computers tick count to record how long the computer
has been on, but realize that there is a space of time between the user
authenicating to the computer (control-alt-delete) and when the logon script
starts, if the customer turns his computer on and then leave for an extended
period of time I ...
data value in Form field if no table entryI have a form with a field which pulls through and concentenates 2 fields
called [ContactFirstname] and [ContactLastName]from my table
There are however some customers for whom I do not have names and therefore
instead I would like Sir/Madam to appear in the field in the form
I think I have seen this done somewhere using ELSE? but can't find it
Any help/ideas gratefully received
Perhaps something like this:
Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam")
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access use...
Publisher 2000 changes default fontHaving loaded Publisher 2000 onto a Win98 m/c I have
discovered fonts used by Groupwise have changed. This
implies that P2000 has changed the default font somewhere -
any ideas please?
How do I change the fonts in GroupWise
http://support.novell.com/cgi-bin/search/searchtid.cgi?/10061270.htm
--
Mary Sauer MS MVP
http://office.microsoft.com/
http://www.mvps.org/msauer/
news://msnews.microsoft.com
"PS" <anonymous@discussions.microsoft.com> wrote in message
news:1be4401c45220$f2b1b4a0$a601280a@phx.gbl...
> Having loaded Publisher 2000 onto a Win98 m/c I have
> discover...
Change outbound server in header to fix 550 Can't verify your host name errorThe headers on the outbound emails show the internal DNS name of our
exchange server; obviously this won't resolve properly at the
destination.
How/where in Exchange 5.5 can I force the IMC to use a real fqdn on
outbound mail?
Thanks!
Frinky
You can do this in TCP/IP properties\Advanced\DNS tab of machine. And
yes, this is not just for Exchange, so you may consider forwarding all
outgoing mail to some relay server (your firewall or ISP's server).
Professor Frink wrote:
> The headers on the outbound emails show the internal DNS name of our
> exchange server; obviously this...
Insert an autofiltered range into another tabI'm am having an issue when trying to insert a range from an autofilter on
one sheet to another. The range has to be inserted above rows that have data
in them. When I use the insert.shift:xldown, it only moves down the first
column.
TIA,
Sub B_CreateTabs()
Dim rngE As Range
Dim lngLastRow As Long
Dim mgrval, lobval, shtval As String
mgrval = "myself"
lobval = "dept"
shtval = mgrval & "-" & lobval
Windows("Mybook.xls").Activate
Sheets(shtval).Select
Sheets(shtval).Copy After:=Workbooks("Mybook.xls&quo...
how to query my web site from VBA and return a value to VBAHello All,
From VBA I would like send a value to my web site, and have it return
a value. I've learned how to use FollowHyperlink to send a value to
an ASP script, but how can the ASP script send a value back to VBA??
Thanks,
Brian
Austin, TX
You can use xmlhttp to make a request to your web page:
'*********************************************************
Sub Tester()
MsgBox WebResponse("http://www.mydomain.com/myactualpage.asp?
info=3Dblah")
End Sub
Private Function WebResponse(sURL As String) As String
Dim XmlHttpRequest As Object
Se...
why do changes only save locally on networked excel file?why do changes only save locally on networked excel file?
...
How can I stop charts from refreshing when changing source data?My problem is, that I am working with a lot of data and when I change some of
the ranges all charts in my view refreshes and it takes much time. My pc is
aP4 3GHz, 2GB RAM so that should not be the bottleneck. Is there any way to
force the charts not to update all the time?
...
Save As using contents of Cell in NameCan someone help with code that changes the "save As" file name to
combination of the original File Name + the contents of a cell, an
saves file in same folder as the original.
E.G. Original File Name= Timesheet
Cells B1= Location
Cell C1 = Date in format 3-5-2004
Cell A1 = concatenate(B1,C1)
Fle Name will therefore be "Timesheet Location 3-5-2004"
The other problem is with the date. When concatenating, how do I forma
the date to avoid it looking like "Location 38051"
Any help much appreciated
Nic
--
Message posted from http://www.ExcelForum.com
Hi
for c...
Count on cell for each time it is changedI would like to count the number of times a cell has been amended/ changed
e.g cell b2 has the word red it it, in cell c2 i would like a counter for
everytime the cell in b2 has changed, at the end of the day you get final
number. Is this at all possible?
Jelinek,
You can do it by putting the following VBA macro in your sheet:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
Cells(2, 3) = Cells(2, 3) + 1
End If
End Sub
Art
"Jelinek" wrote:
> I would like to count the number of times a cell has bee...
Batch converting leads to accountsIs there a way to convert leads to accounts in batches? I need to
convert up to 500 each day and don't have the time to go through them
one at a time.
Dave Lagergren
On Sat, 26 Feb 2005 01:28:44 GMT, "Who Cares!"
<whocares@freetidet.org> wrote:
>Is there a way to convert leads to accounts in batches? I need to
>convert up to 500 each day and don't have the time to go through them
>one at a time.
Only way is through the SDK.
Write some code that loops through your leads and creates accounts,
contacts and opportunities as needed and marks the lead as qu...
Excel formulation to automate values Hi there,
I have a little problem on arranging a small multi-worksheet excel here.
Let me explain in a short way then give some details on it.
I am trying to make an offers recordsheet which has two worksheets in it. One
for products(and their base prices) and an offer sheet. I would like to use
a bit dynamic data here. So when I type the name of the product excel would
give me the price from other worksheet.
in details;
Prices worksheet is something like:
A B
1 Product BasePrice
2 mouse 5
3 keyboard 8
4 ...
And the ...
Assign values for one column to another.Hi
I have in column T certain numbers and texts that that I require to assign a
value to as below, in the adjacent column. Again any pointers would be much
appreciated.
Kind Regards
Celticshadow
T U
1 1
2 2
3 3
4 4
5 5
6 6
7 7
8 8
9 9
0 10
F 10
UR 10
U 10
R 10
S 10
L 10
P 10
PU 10
BD 10
D 10
Well, imagine that two-column table occupies cells Y1:Z20. Put this
formula in U1:
=3DVLOOKUP(T1,Y$1,Z$20,2,0)
and copy down.
Hope this helps.
Pete
On Oct 14, 4:26=A0pm, Celticshadow
<Celticsha...@discussions.microsoft.com> wrote:
> Hi
>
>...
hide/change color of selected row headingsIs it possible to hide the row heading numbers for
selected rows (i.e. rows 51 and greater) for just the
selected sheet? I'd like to have a color with no row
heading number appear that matches the fill color I select
for the adjacent cells.
Secondly, any ideas as to how I can prevent the user from
scolling further down than a certain point (i.e. row 51).
Thanks in advance.
Joe
Row headings are either on or off, you can't hide some. However, you
can achieve a similar effect by hiding *all* headings
(Tools/Options/General) and putting the numbers 1:51 in A1:A51.
to limit scro...
Insert Static Date as part of MacroI've built a nice macro, but I want it to insert the date it is run in an
empty cell within the macro's range. When working within a spreadsheet, Ctrl
+; returns the system date, but I can't figure out how to put that command
into a macro.
The macro recorder editor shows that the system recognizes the entry as the
current date, not a function that returns the current date.
The now() or today() functions are both dynamic ... they change with the
system date. That's not acceptable in this situation. I need to seen when
the macro was run.
Thanks for any help,
Ralph
di...
Outlook98I am using Outlook98 and all of a sudden, all the folders
I have set up and been using over the past several years,
have dissapeared. I believe the PST file is the same size,
but the folders and their contents are nowhere to be found.
How big is the .PST file?
--
Jocelyn Fiorello
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
In news:1029601c3f42b$1ace3ac0$a101280a@phx.gbl,
Kurt Wolfe wrote:
> I am using Outlook98 and all of a sudden, all the folders
> I have set up and been usi...
changing a name in mulit parts of a documentI am setting up a word document.
This will be used as a template
In this document I wish to insert the same "name" throughtout this document.
Is it possible to change the name in one spot and all of the others change
automatically
thanks
See http://gregmaxey.mvps.org/Repeating_Data.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>...
How to insert a URL with spaces into message bodyIs it possible to insert a URL containing a space into a
message body from a mailto hyperlink without using
brackets?
For example:
<a href="mailto:jackblack@microsoft.com?
body=<http://www.micro%
20soft.com>">jackblack@microsoft.com</a>
This link will insert the URL '<http://www.micro
soft.com>' (with a space between the 'o' and the 's') into
the message body. However, the brackets will be visable
too.
If I remove the brackets, only the 'http://www.micro'
portion will be hyperlinked. The 'soft.com' portion wi...
Can't insert rowsI am using Excel 2007 and have just loaded a spreadsheet created in a
previous version which is running in Compatibility mode. When I try to
insert a row I get an message "Cannot shift objects off sheet".
How do I insert rows on this sheet? No problem with another workbook loaded
at the same time which was created in 2007.
See if this helps
http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in
Excel
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my...
change exchange name suffixHi
We need to change our exchange server 'name' suffix.
The situation is that we have a local DNS domain 'bs.si' where all our
company computers and server are (Win2k srv AD)
We have also external domain 'bs-group.si' that is also for delivering mail
(mx record). The Exchange server name is 'posta'
Now when someone connects to Exchange server from outside via port 25 it
responds like '220 posta.bs.si ...', but I want that the response will be
like '220 posta.bs-group.si'. So that mail that is coming from our server
will be seen like that i...
Changing password #2Hi,
If I change a domain user's password, will that user's
Exchange Server 2003 mailbox's pssword be changed too?
I mean, does Active Directory share the same password
with Exchange Server 2003?
Thanks!
Exchange never had passwords separate from domain, not even in Exchange
4-5.5 era. So you would change just one password, which belongs to AD
account.
Michael wrote:
> Hi,
>
> If I change a domain user's password, will that user's
> Exchange Server 2003 mailbox's pssword be changed too?
> I mean, does Active Directory share the same password
> w...