Running VBA script for Date time removal

DavidO_Sullivan — Fri, 31 Jan 2020 16:09:00 GMT

Hi -
I've generated a script to remove the time from the datetime in order to get a pooled filter.
The Vba code will not copy directly across to Blue Prism.
Therefore, I am looking to call the script directly.
I have saved it in RPA_Functions(In excel Module) and with each instance of opening the desired workbook, I am looking to call this vba into action.
The data is homogenous, so there is no need to change the VBA script for filtering, but I'm curious to see is it possible to nest something like::
'
Private Sub Workbook_Open()
Call RPA_Functions.CreateShortcut
End Sub
'
Within the VBO at the beginning of my process in the VBO open workbook.

I'd rather not change the object at the source.
The script used to filter the datetime is below, this works fine it's the above option that interests me.
Any and all advice is very much appreciated.

'

Sub CreateShortcut()
Application.OnKey "+^{C}", "dropDateTime"

End Sub

Sub dropDateTime()
Dim LR As Long, i As Long
LR = Range("Y" & Rows.Count).End(xlUp).Row
For i = 2 To LR
    With Range("Y" & i)
        .NumberFormat = "dd/mm/yy"
        .Value = CLng(.Value)
    End With
Next i
End Sub

'

------------------------------
David O'Sullivan
------------------------------

RE: Running VBA script for Date time removal

GopalBhaire — Mon, 03 Feb 2020 05:41:00 GMT

You can use Run Macro action after open workbook to run the macro dropDateTime

Or you can check the extending MS Excel VBO guide to move your code to BP MS Excel Object.

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

topic RE: Running VBA script for Date time removal in Product Forum

Running VBA script for Date time removal

RE: Running VBA script for Date time removal