Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
COPY TO from VFP Doesn't Produce Hyperlinks in Excel
Message
De
01/04/2005 15:50:57
 
 
À
01/04/2005 15:44:46
Information générale
Forum:
Microsoft Office
Catégorie:
Excel
Divers
Thread ID:
01000836
Message ID:
01000840
Vues:
14
There is a KB article acknowledging the problem:

http://support.microsoft.com/default.aspx?scid=kb;en-us;271856

I you are controlling the import from VFP via automation, you could call a Macro after import to look for http:// and force it, as hinted in the article. You also could walk the document from the VFP side via automation, but calling a macro would be faster.

>I just tried dumping a SQL SELECT cursor to Excel where I added a column with a URL like so:
>
>SELECT Vis_PK, Vis_Status, Vis_Start_Date, Vis_Intrastate, Opr_Short_Name, ;
>    PADR("http://myDomain.com/xdb/Vis" + TRANSFORM(Vis_PK) + ".xdb", 60) AS URL ;
> FROM visit JOIN operator ON vis_opr_fk = opr_pk ;
> WHERE vis_comprehensive = .T. and ;
>  Vis_Type = "Inspection" and ;
>  Vis_Status IN ("Completed", "Finalized") AND ;
>  vis_inactive = .f. and opr_inactive = .f. ;
>ORDER BY vis_Intrastate, vis_start_date
>
>COPY TO "completed_inspection_list.xls" TYPE xls
>
>I found it interesting that the URL column did not display in blue or become clickable in Excel. If I edit one of the values, or manually type something that "looks like a URI" it does. Is there a secret to convincing Excel to treat that column as hyperlinks?
>
>Thanks!
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform