Problems using Visual Cron 8.04 to Create or Write to Excel - VisualCron - Forum

Community forum

Bob Flanagan III
2016-04-22T13:15:02Z
Hello

I am experiencing issues when creating an Excel File (VISCONV8.xls). It will create a file but when I attempt to open it it comes up with the following message.

"The file you are trying to open 'VISCRONV8.xls', is in a differnet format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"

When I click YES the file opens in Excel but if I click "Save As" it is defaulting to the "Save As Type" Text (Tab delimited)(*.txt).

Also

All the Visual Cron tasks under Office (Excel - Get Cell, Excel - Set Cell etc) do not recognise the Excel file that Visual Cron has just created.

Also

Is it possible to use Visual Cron to enter a formula? I am trying to use Visual Cron to add up a column of data using the formula =sum(A1:A{MATH(Add|Integer|{TASK(f5b6cbb8-8a5f-412c-b81a-698ece313c85,StdOut)}|1|#0)}) where the result is the result of a Excel - Get Last Row task.

It is calculating the formula but when using the Excel - Set Cell to input the formula it is entering the formula as TEXT.

Any help would be much appreciated.

Stuart



Scroll to Top