Recent content by Nici BP

Thank you for your help! The advice is great, but my data has half a Million entries. Therefore converting to a Collection is not the most efficient way. I now implemented a Macro, that only copies the active cells of the autofilter and then insert them again as values. So i can Copy and paste...

I tried this. My delimiter is " |" and my data has headers. I somehow Need to delete the first two (filled) files and then I could apply Import to CSV. Nevertheless, this is not workin well for me. So I am running Macros right now to solve this issue. What do you think about this solution?

Because my file has more than half a Million entries.

Hello, I would like to Import a txt file into Excel without using Collections. How do I manage to do this? Thank you for any help!!!

Hi, I used autofilter to filter a huge Excel-file. Now I would like to copy some rows with the Action "Copy and Paste Worksheet Range". This is not working for me in the correct way - I would like to copy only the visible, filtered cells. I was trying to modify the Code Stage of "Copy and...

Dear community, recently, I am trying to make a screenshot of my Excel sheet. I open Excel (Create instance -> open workbook -> ...). I would like to take a screenshot of my current sheet, then create a new sheet and insert the screenshot into this new sheet. Do you have any idea how I can...

Hello VJR, thank you for your great help! I try to implement a filter where a text field can be "xxx" OR "yyy" OR "zzz", but I do not know what to enter as Input/Output Parameters and how to set up exception, success and message. Do you have an idea? I really appreciate your help.

I solved the issure concerning the random number, but did not understand what you meant with the Notepad. What is this Notepad?

This solution does not work for me. I try to convert a txt.-file which is separated by commas into a Collection and then in to an Excel file, but for some reason when I use split lines i get way more rows than in the initial work sheet and they all contain strange Symbols like question marks...

Dear RPA-community, I want to extract Information from a .txt-file and then I would like to modify the Information in an Excel sheet. I tried to convert the file to csv, but it destroyed my formatting. Furthermore, I want to implement a new column with random numbers. I tried to use...