Lengthy URL doesnt copy from excel to a web page - (Moved)

[cpradeep22]

Unable to copy a long URL from Excel to a webpage field though if i directly hard code and send it works perfectly

i used this excel command to read and it didnt work while the rest of the fields work perfectly

Local $Read4 = _Excel_RangeRead($oWorkbook, Default, "B33") ; URL of document from Excel

sleep (13000)

the URL in the excel cell B33 is - https://lms.xxxxxxx.net:443/VX-LMS-PROD/ViewDocExternally/ViewDocumentDetails.aspx?DevId=RGV2LTE4ODEucGRm-rImCg7x6Cks=&&Id=MTg4MQ==-ePsTeDP0ykU=&&UserId=30&&DocNo=UUFNLVBBTS0wMDEtMDAwMS4wNw==-

However if i paste directly using send command hard coded it works send ("https://lms.xxxxxxx.net:443/VX-LMS-PROD/ViewDocExternally/ViewDocumentDetails.aspx?DevId=RGV2LTE4ODEucGRm-rImCg7x6Cks=&&Id=MTg4MQ==-ePsTeDP0ykU=&&UserId=30&&DocNo=UUFNLVBBTS0wMDEtMDAwMS4wNw==-")

I also tried passing someother text instead of the URL and it works well.

 

Thank you and do suggest if there are other alternate means to get this done

[Jos]

Moved to the appropriate forum.

Moderation Team

[GokAy]

Hey,

Maybe you need to read text instead of value of range("B33")?

$iReturn parameter https://www.autoitscript.com/autoit3/docs/libfunctions/_Excel_RangeRead.htm

[optional] What to return from the specified cell:     1 - Value (default)     2 - Formula     3 - The displayed text     4 - Value2. The only difference between Value and Value2 is that the Value2 property doesn’t use the Currency and Date data types

[Nine]

Limit for an URL in Excel is 255 characters.

[cpradeep22]

thank you for the support. 

Unfortunately it is lengthy and greater than 255charecters and couldnt restrict. As a workaround now i have moved this URL alone to notepad and parsing it and it worked. Thank you all once again

[water]

Have you tried to set parameter $bForceFunc? If set to True it should solve your 255 character problem. 

[cpradeep22]

thank you. Will keep this in mind and try and it out since im set to do my next level of automation by next month. Appreciate your support

 

[water]

More details regarding the Excel and Word UDF can be found in the Wiki.