SS&C Blue Prism Community

MarcMorin · 29-11-19

Hi i need to write a collection to excel but using Excel VBO Write collection i am loosing the collection format, ex (003 in collection end up as 3 or 123.00 ends up as 123 in excel)is there a way to keep collection format when writing collection, co...

MarcMorin · 05-11-19

HI is there a way to disable calculations in excelbasically the equivalent of 'Application.Calculation = xlManual'please help------------------------------Marc MorinConsultantPWCAmerica/New_York------------------------------

MarcMorin · 02-12-19

Thank you all for your inputs what i ended up doing is (and it prob need some ironing out) is inside the Write collection i added Dim Format as String Dim ColType as Type ColType = col.DataType If ColType = GetType(String) Then Format = "@" else Form...

MarcMorin · 30-11-19

but then number column wont get calculated in sheet, sheet will not only contain info in writing in it------------------------------Marc MorinConsultantPWCAmerica/New_York------------------------------

MarcMorin · 30-11-19

i did 'play' with it a bit with no success, but given i have 100's of files to process i didn't spent a lot of time on this as this is not really an option------------------------------Marc MorinConsultantPWCAmerica/New_York--------------------------...

MarcMorin · 07-11-19

That did the trick, do you have any idea why it work with '-4135 and not using 'xlManual'?also it is alot less 'overkill' then my workaround which included adding Microsoft.Office.Interop.Excel dll"Dim wb As ObjectDim excel as Object wb = GetWorkbook...

SS&C Blue Prism Community

User Statistics

User Activity

Excel Write Collection Keep Collection Format

Disable Calculation in excel

RE: Excel Write Collection Keep Collection Format

RE: Excel Write Collection Keep Collection Format

RE: Excel Write Collection Keep Collection Format

RE: Disable Calculation in excel