Excel Reports failing with ActiveFactory

farmera

Member
Join Date
Dec 2005
Location
Hamilton, Oh
Posts
2
Hello,

I've just started supporting an office that uses Wonderware and ActiveFactory. They have reports set up to auto generate each day in excel. The reports stopped working in August. The scheduled task runs but the data returned is "=value!. The data comes from an InSQL db data folder.

They have the option to click a button and generate the report as well and that works. I'm not sure where to start.

We are using Excel 2003. I'm not familiar with Wonderware or ActiveFactory either system and this is my first task!

Any advice would be greatly appreciated
 
Hmmm...
Could be any number of issues. I guess I would start with checking the manual report button (in wonderware, I assume) to see what the command is.

If you open the active factory excel sheet, does it give any errors?
 

Similar Topics

Hello Everyone, I am working on reports in Vijeo Citect V7.40. I want to generate a report whenever I press the button. I am able to generate it...
Replies
0
Views
875
Good friends, I'm new to the forum, I'm working with RSview32, someone can help me how to make a macro in VBA, to save some data in Excel. to...
Replies
6
Views
1,955
Hello group, I've had some request to set up some desktop computers with RSlinx so that multiple managers, supervisors etc. can view production...
Replies
0
Views
1,401
Hi all, RsView Studio can generate Reports of in Excel? If anybody knows then please tell me its procedure. -Manasi
Replies
5
Views
4,791
Hi, I'm trying to export data from a DataGrid to Excel using VBA, but I'm getting an error "Object doesn't support this property or method". The...
Replies
0
Views
76
Back
Top Bottom