Skip to main content

Hello all!

I use Micro Focus Rumba and am looking to create a macro that allows users to open Windows Explorer to open up so they can select the file they want to open and then have the macro select the data in the spreadsheet and paste it on to Rumba. I've already tested the code from when the macro opens WE to when the user clicks and opens the file, but I seem to be "drawing a blank" from when the macro is supposed to be copying what is in the said Excel file and pasting it to Rumba. The code which I think is causing the problem is as follows:

Set MYBook = xlApp.Activeworkbook
Set XLSheet = MYBook.Worksheets("Sheet1")

Do you know what I'm doing wrong?

Thanks in advance.


#Rumba

Hello all!

I use Micro Focus Rumba and am looking to create a macro that allows users to open Windows Explorer to open up so they can select the file they want to open and then have the macro select the data in the spreadsheet and paste it on to Rumba. I've already tested the code from when the macro opens WE to when the user clicks and opens the file, but I seem to be "drawing a blank" from when the macro is supposed to be copying what is in the said Excel file and pasting it to Rumba. The code which I think is causing the problem is as follows:

Set MYBook = xlApp.Activeworkbook
Set XLSheet = MYBook.Worksheets("Sheet1")

Do you know what I'm doing wrong?

Thanks in advance.


#Rumba

Bring up Excel application and open a new Workbook

Set XLApp = CreateObject("Excel.Application") ' Create an EXCEL application

Set XLBook = XLApp.Workbooks.Add ' Create an EXCEL Workbook

Set XLSheet = XLBook.Worksheets("Sheet1") ' Create an EXCEL Worksheet

XLSheet.Activate ' Activate the Worksheet

Terms & ConditionsAccessibility statement