Hello,    I have some excel workbooks that I'd like to use as a datasource in a DataFlux 2.5 data job. I found a way to do it by creating an ODBC connection to the workbooks but I have to go into each one and make a named range for DataFlux to read. The problem is, each time the workbook is updated the data gets entered into a new sheet named "Current" and the old sheet is renamed with the date. This means I'd have to go in each time the workbook is updated and create a new named range. Is there a way to have the whole workbook as a datasource without creating a named range?   I appreciate any help! ... View more

Hello,    I am trying to open an excel spreadsheet in one of my nodes because it has a macro that will run on open to change a bunch of spreadsheets to csv files that will be used in the job.   I've tried using the open() and execute() function in an expression node but they don't open the file. The node will complete successfully but no open file.   Any help would be great! Thanks ... View more

Hello,   Does anyone know of a way to fill in fields of nodes by using a variable? There are multiple nodes in which I use the same description and would like to edit it in only one place. I'd like to have the variable be declared in a node if possible so I can used it as part of a template for other jobs. I know I can use macros but I don't want to have to make a new one for each job.   An example would be the description field in the attached picture.   Any help with this would be greatly appreciated.   Thanks       ... View more