Search results

  1. J

    Solved Save Excel file as password protected

    something wrong in code stage, could you show the code/inputs/outputs of the code stage?
  2. J

    Solved Save Excel file as password protected

    Did you backed up original ‘MS Excel’ VBO, and edited the code on the duplicated VBO? 'GetWorkbook' can be found in 'Global Code' on 'Initialise' page of MS Excel VBO. This error will not occur if you edit it on the duplicated VBO.
  3. J

    Windows text

    First, spy an element (such as a file window) by Windows 32 Mode. You will find this attribute checked by default. Then see the difference when you check/uncheck this attibute. As far as my considering, I would like to check on this attribute and set it '*wildcard' and set value like '*save*' to...
  4. J

    Solved Save Excel file as password protected

    Go to 'MS Excel' VBO and Go to 'Save Workbook As' Action. See the Code in 'Code Stage' and Try to edit it. (Backup First) Add an input 'password' to code. You can find more reference from https://docs.microsoft.com/en-us/office/vba/api/excel.workbook.saveas
  5. J

    Extracting folder info

    Try this
  6. J

    Extracting folder info

    As far as I know, ‘Get Folder’ Action will output a 'collection', and it can be saved into an excel file by 'MS Excel' Object. Or try other Object to Convert a collection into a file.
  7. J

    Attach internet explorer

    I also encountered the situation that Frederic encountered. My solution is to add the "TabProcGrowth" key value (HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Main, REG_SZ, 0) to the registry of the following path. (Details can be obtained from Blue Prism Portal Support Center.) This...
  8. J

    blue prism screen comes in front of IE Browser and this fail my Process Run

    1, Try use other mode to spy elements of IE browser except Region Mode. 2, Connect a second monitor to your PC
  9. J

    Importing txt-file into Excel

    Try to Select all and Copy to Excel. You may create a business object to spy notepad, and ‘Send Global Keys’ to Select and Copy.
  10. J

    Process data from different worksheets

    Try using the VBO 'MS-Excel'. Activate the target worksheet before processing the data. By the way, you can import the VBO from 'C:\Program Files\Blue Prism Limited\Blue Prism Automate\VBO' folder.
Top