Re: need help in excel
- From: "Debbie Scales" <debbie@xxxxxxxxxxxxxxxx>
- To: <jfw@xxxxxxxxxxxxx>
- Date: Thu, 8 Jun 2006 13:06:13 -0400
I would just have your boss save the document in the same folder where she
save the excel spreadsheet. That way you don't have to specify a path and
excel will look for the file in the same folder as the spreadsheet.
Debbie
----- Original Message -----
From: "Nicol Oosthuizen" <NOosthuizen@xxxxxxxxxxx>
To: <jfw@xxxxxxxxxxxxx>
Sent: Thursday, June 08, 2006 12:52 AM
Subject: RE: need help in excel
NB: This email and its contents are subject to our email legal notice
which can be viewed at http://www.sars.gov.za/Email_Disclaimer.pdf
----
Actually I want this long peace of text that I copy from word, I want it
to be in a single cell. IN other words, that long peace of text I want
it to be all in only a1 for instance and it must not go over to a2 or
b1.
Auto fit doesn't help keep the text in a single cell, neither does
merging.
Regarding the hyperlink, if I finish my work for the day, I e-mail the
spreadsheet to my manager. If I save the text in a separate word
document which cannot be displayed in one cell, and I attach that extra
document, how do I insert a hyperlink so that when my manager clicks
on the hyperlink in excel it should open the attachment in her mailbox?
Do you think that can work? Otherwise I can just ask her to save the
extra document on the route of her c drive and then create a hyperlink
to the file on c, because I don't know how her computer looks like, what
folders she have got. I'm using a network drive called f: but I'm not
sure if she uses a network drive and if so, if it's also f so I would
say: the best is to create a hyperlink to the document on c.
Thanks for your help
-----Original Message-----
From: jfw-bounce@xxxxxxxxxxxxx [mailto:jfw-bounce@xxxxxxxxxxxxx] On
Behalf Of Debbie Scales
Sent: 07 June 2006 06:42 PM
To: jfw@xxxxxxxxxxxxx
Subject: Re: need help in excel
Nicol, if you are using hard returns (hitting the enter key) in word
then it
won't work to keep it all in one cell on one row in excel.
If you just let word wrap as you type, then if you copy and paste it and
do
autofit, it will create one long column with all the text in one row.
Is that what you want?
To create a hyperlink, in the cell, press control K.
Navigate to the folder list and open a folder and pick you file.
You can tab to the text to display field and enter the text you actually
want displayed for the link.
When you are in the cell in excel, jaws should say has hyperlink and
enter
should open the file.
You may need to alt tab to the open file.
Debbie
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
--
JFW related links:
JFW homepage: http://www.freedomscientific.com/
Scripting mailing list:
http://lists.the-jdh.com/listinfo.cgi/scriptography-the-jdh.com
JFW List instructions:
To post a message to the list, send it to jfw@xxxxxxxxxxxxx
To unsubscribe from this mailing list, send a message to
jfw-request@xxxxxxxxxxxxx with the word unsubscribe in the subject line.
Archives located at: //www.freelists.org/archives/jfw
If you have any concerns about the list, post received from the list, or the
way the list is being run, do not post them to the list. Rather contact the
list owner at jfw-admins@xxxxxxxxxxxxxx
Other related posts:
