Dynamic Hyperlinks (URL) problem in Excel
 

OBJECTIVE
Trying to build an excel sheet with Shipments for the day from the
database. I am trying to include UPS tracking number as a HyperLink to the
UPS website.
I build the link and fill the colum using HYPERLINK function of excel

THE PROBLEM
Eg: This is a sample link i am trying to write to the colum from the database

=HYPERLINK("http://wwwapps.ups.com/tracking/tracking.cgi/?tracknum=1Z1516306601513843","Track Shipment")

What happens is when the data is loaded, Excel prefix a single quote (') to
the begining of the expression, hence the function doesnt work and the link
is not active
This how it shows up in excel

'=HYPERLINK("http://wwwapps.ups.com/tracking/tracking.cgi/?tracknum=1Z1516306601513843","Track Shipment")

I notice that excel does add sigle quote to all the character fields coming
from the database..
QUESTION
1) How can I suppress this single quote?
2) If it cannot be suppressed, how can i remove this after the the data is
loaded? Can i use a macro? ( i dont have much experience in this area). If
yes, how?
3) Or is there any alternate approach to get to the objective

Any help would be greatly appreciated.
(Sujith
ChestNut Ridge, NY)

Dynamic Hyperlinks (URL) problem in Excel
 

Hi
how are you inserting this formula?
Also check that this cell is nOT formated as 'Text'

--
Regards
Frank Kabel
Frankfurt, Germany


Sujith Kumar wrote:
OBJECTIVE
Trying to build an excel sheet with Shipments for the day from the
database. I am trying to include UPS tracking number as a HyperLink
to the
UPS website.
I build the link and fill the colum using HYPERLINK function of excel

THE PROBLEM
Eg: This is a sample link i am trying to write to the colum from the
database


=HYPERLINK("http://wwwapps.ups.com/tracking/tracking.cgi/?tracknum=1Z15
16306601513843","Track
Shipment")

What happens is when the data is loaded, Excel prefix a single quote
(') to
the begining of the expression, hence the function doesnt work and
the link
is not active
This how it shows up in excel


'=HYPERLINK("http://wwwapps.ups.com/tracking/tracking.cgi/?tracknum=1Z1
516306601513843","Track
Shipment")

I notice that excel does add sigle quote to all the character fields
coming
from the database..
QUESTION
1) How can I suppress this single quote?
2) If it cannot be suppressed, how can i remove this after the the
data is
loaded? Can i use a macro? ( i dont have much experience in this
area). If
yes, how?
3) Or is there any alternate approach to get to the objective

Any help would be greatly appreciated.
(Sujith
ChestNut Ridge, NY)

Dynamic Hyperlinks (URL) problem in Excel
 

Hello Frank...
Excel sheet is created by a program (SQL DTS routine)
Presently this field is text. What esle i should use?
Thanks

"Frank Kabel" wrote:

Hi
how are you inserting this formula?
Also check that this cell is nOT formated as 'Text'

Dynamic Hyperlinks (URL) problem in Excel
 

Hi
you have to set the format to 'General' before inserting your values

--
Regards
Frank Kabel
Frankfurt, Germany

"Sujith Kumar" schrieb im
Newsbeitrag ...
Hello Frank...
Excel sheet is created by a program (SQL DTS routine)
Presently this field is text. What esle i should use?
Thanks

"Frank Kabel" wrote:

Hi
how are you inserting this formula?
Also check that this cell is nOT formated as 'Text'

Dynamic Hyperlinks (URL) problem in Excel
 

Frank,
I tried General as well still doesn work.
Issue is Excel somehow throws in the single quote in the begining ..
If i can find a way to stop excel from doing that i am good to go...
Any idea is appreciated

"Frank Kabel" wrote:

Hi
you have to set the format to 'General' before inserting your values

--
Regards
Frank Kabel
Frankfurt, Germany

"Sujith Kumar" schrieb im
Newsbeitrag ...
Hello Frank...
Excel sheet is created by a program (SQL DTS routine)
Presently this field is text. What esle i should use?
Thanks

"Frank Kabel" wrote:

Hi
how are you inserting this formula?
Also check that this cell is nOT formated as 'Text'