Forum Discussion

Nishchal_Vashisht's avatar
Nishchal_Vashisht
Copper Contributor
Sep 03, 2022

NikolinoDE  Thanks for reply. I use the same reference but this is not working in my Scenario.

    • Nishchal_Vashisht's avatar
      Nishchal_Vashisht
      Copper Contributor
      Sep 03, 2022

      NikolinoDE It didn't work for me. I am downloading my Excel File from Salesforce and I have made changes in column ranges accordingly but didn't work. I am not sure whether it is because of Spreadsheet format I am downloading from salesforce or anything else. I am attaching my File here 
      Could you please help me with it.
      https://mega.nz/file/Eqx1zZDI#hmrJduhQ77zReZi2fFxRM2aaSwaUGVPLbhQc-FBavcg 

       

      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        Sep 03, 2022

        Nishchal_Vashisht 

        The file cannot be opened and if I open it anyway, it is empty.

        If you cannot insert the file, then send the file as a private message.
        I don't know your digital environment, so I can't make any statements as to why it's not working for you.

         

        Here is another VBA code, maybe it works for you.

        At least if not, it will "Debug" and show you the error line.

         

        At the same time, if I may recommend, additional information about Excel version, operating system and storage medium would be beneficial for all participants, most of all for you.

         

        Thank you for your understanding and patience

Resources