I'd like to create a function to export objects to Excel. I'd like to create a single function with parameters, so i can call it from different sheet, and i just have to set the object i want to export in the concerned sheet.
The function is :
sub exportExcel(param1, param2)
'Open Excel
set XLApp = CreateObject("Excel.Application") ' Define Object
XLApp.Visible = True 'Visible set as true
set XLDoc = XLApp.Workbooks.Add 'Open new workbook
....
end sub
What is the correct syntax to use and declare parameters in a function.
as far as I know, you can use functions with parameters in the Script but NOT in an Action. One workaround is to call the sub without parameters, and indide the Sub you get the values from variables.
