Recent content by Dylan

  1. D

    Update multiple values in Oracle (SQL) in one shot

    Hello everyone, I need to update 10k rows and 100 columns daily in Oracle. It's too slow if I do it using a loop over the collection that contains the new values. Is there any way to do it in one shot? I have the new information in Excel and I read it in a collection. Thanks, BD
  2. D

    Send email with a template and a not-fixed table length

    Hello everyone, I have to use an email template to send some notifications, The table (Item | Description | Price) could have multiple rows. What is the best way to do this? I used to use an Excel macro, but I don't like that idea. I tried to replicate the template using HTML but the result...
  3. D

    Excel - Get paths to linked files

    I have a file that is linked to some other files. I need to open all of the linked files, because sometimes they're not updated. How can I do that? If I could get a collection with the paths to all the linked files, then I can open them and update them with others objects that I already have...
  4. D

    How much free space in a shared drive?

    Hello everyone, I need to see if I have enough space available in a shared drive before I run a process. I tried this, but it always returns "Free Space: 0, Total Space: 0". I would need to do this for a shared drive (i.e, the drive is not represented by a letter, but by something like...
  5. D

    Create connection to new program

    Hello everyone, At work we create BluePrism's bots that log into SAP, make things inside SAP and they also work with Excel. How can I create the connection from BluePrism to a new program (it's a database called Tandem, or something like that)? Is that possible? Is there any tutorials or...
  6. D

    Set cell value in Excel .xlsm file

    Hello everyone, I already completed the official documentation (those 200 pages) and also done 2 processes, but now I have a problem writing a value that is stored in a data item into an Excel file. These are the steps followed: 1) Create instance 2) Open workbook 3) Show workbook 4) Worksheet...
  7. D

    SAP Process chain Status

    What if you export that table in the clipboard and you paste it in an Excel file? What happens to those green and red images?
  8. D

    Paste data item in Excel (set cell value) not always working

    Hello everyone, I have already done some processes (including all the official tutorials that are in that pdf of 200 pages that I don't remember the name), but today I faced a problem that never happened to me and I couldn't fix it: I need to paste the information that is in a data item into a...
Top