Skip to content
The Chat Archive
gpt-3.5-turbo-0613· OpenAI WildChat-4.8M (AI2)

When I enter the URL Address below, VBA reports an error that the line is too long. How…

  1. User
  2. Assistant

    You can break the line in VBA by using the line continuation character "_" as shown below:

    url = "https://totalwatercompliance.sharefile.eu/oauth/authorize?client_id=S91b5wNXMkpKqFTWBl4sCpAKs14Kc5vy" & _ "&scope=&response_type=code&redirect_uri=https%3A%2F%2Fauth.sharefile.io%2Fsignin-sharefile" & _ "&state=CfDJ8OveO3GoJO9Ktox9IkhwMEaYsHzaA9OxgEU_4hDh0qdSwI453Sd0KHhl1cFwCLcb7cEnnwvGesEJ5hQahXSlr9Wxotyx2UEYmBwh8Izh1o4Sn4R1ZkCisJDJnWdBOlnOc2LElCRC0OAe0HiUhbrG8auzRbtjwu9hjCs7xNZeoNWx3XMGsTseCgtZaIDtYe_Jxx0mw2J89TfWTvfi6Azt2IFgt9RxdsVNT1JKte2CPSh-o7SM0JY4-b9MrEmz2oBPZkUnn2VHHo43jxXwUriwgxje1CnvdtLqK0tDDRMn5BcPDI6ScBZr1hxfse7TmlnhfuqHqpoMyI-ATxQckeLP17_W4swYB8P9EZA98X2BB3SJE9o5Mblou7EDkd_YjZ35zZFO6o_VACKpoWvxlPnNV-3BDM1Ix41IxVtURJrlE4bQWQt3VwIrn2qMWBny-kc-rOoRhBdqcN77X8aVG2WEdQTpXQQFmgEvmbZJNNToP8YlU3Fh7d9701MwxDjFb8qqAtk1r4xp4ypCToNzdEm_R3Qhrzlhi63GtJ4oyE03OGzB6PP7ABbtD6UlTx4iDFN75ZqnFBOBVl49MWwWZt9_Uj0sZzluG5AEBZBTQJ6Rg7XELSM48XdCVLJwLlp_aueTR-BLfctJHqF17X70BGuo312e1EE4hXxLG4RVZ6uCn3ld2-Zjz7gk04EXV9N39n4WOTi6_5W5BV5AA_zIBuZglB-PmUUIDa30NBX4SHrqmp4vvdk0rtuxAgfB_BpF33Ecit2KHU1RiQVXjcIHwaH_ByU" & _ "&subdomain=totalwatercompliance#/Credentials"