Are they any differences in code between Blue Prism versions 5.0.11.0 and 5.0.18.0. A Process developed on 5.0.11.0 and imported into 5.0.18.0 does not function the same. on the older version it works correctly, but, NOT on the newer version....
Would anyone have the correct code to turn on AutoFilter or Freeze Panes with VB using Microsoft.Office.Interop.Excel. below is a sample ,but, some of the lines are incorrect.
Dim excelApplication As New Application
Dim excelWrkBook As Workbook ...
Can you attach an example where you add a row to level2 and level3 of a 3 level collection
level1 is a single row
level2 is multiple rows
leve3 is multiple rows
thank you
this worked for me:
Imports Microsoft.Office.Interop.Excel
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim excelApplication As New Application
Dim excelWrkBook As Workbook
Try
...
this worked for me:
Imports Microsoft.Office.Interop.Excel
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim excelApplication As New Application
Dim excelWrkBook As Workbook
Try
...
i was lucky to get the code from a developer, here is the code that works.
Dim wexcel As New Application
Dim wBook As Workbook
Dim wSheet As Worksheet
' Dim excelRange As Range
Dim excelApplication As New Application
' Dim excelWrkBook As Workbook
...