RSview32- Save Data through VBA in Excel To generate Reports - RSview32- Guardar Dato

[garcgc]

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 generate some reports. ------

Buenas compañeros, soy nuevo en el foro, estoy trabajando con RSview32, alguien me puede ayudar como realizar una macro en VBA, para guardar unos datos en Excel. para generar unos reportes.

 

[James Mcquade]

Welcome to the forum.

What are you trying to do?
Save some data - ok. How much data?
what type of data?
how often?
when do you want the reports generated?

regards,
james

 

[Fred_Loveless]

Is this data you are collecting over time or is it a report of current values at Time X.

 

[James Mcquade]

Since you haven't replied, I will tell you this.

you MUST do the following.
What version of RSView are you using? VERY important.
is this a runtime package or developer package?
Get with RSView tech support and find out if the version of RSView that you have supports visual basic or visual basic.net. tell them what you are doing.
answer my questions posted earlier and add 25% to the data quantity.
Get all the variable names and addresses from the plc.
get all the data names from RSView32.
if production is critical, you will need another copy of rsview for development and testing.
get a copy of the VB program required and install it.
Write the VB program.

this is NOT a 20 minute fix.
for the experienced vb programmer and rsview user, this is a 3 week minimum job!

the first report that we did took 5 weeks and a week debug onsite.
if the data required is for 7 am to midnight for example, add an additional 2 weeks.

depending on the amount of data, the report will take 30 minutes to 4 hours.
we took data for 60,000 produced items, 20 hours of production data. the average report took 2 hours.

We contracted the OEM who built our equipment to write the program.
I did have to modify a good bit of code for him.

regards,
james

 

[widelto]

Hi Garcgc:

My approach is to use a report generator. It´s an Excel add in.
For several years I´ve been using XLReporter from www.sytech.com, additionally you have to buy an OPC server , we use FTalk OPC Gateway as our OPC server.
You can learn the whole thing the same day.

 

[garcgc]

I sent you the answers to the questions

Hi James,
I sent you the answers to the questions

What are you trying to do?

I am trying to make a report in excel, that I keep weight data.

Save some data - ok. How much data?
approximately 30 weighing, seals, operator name, weighing dates and times.

what kind of data?
decimals, data and time, integers, text.

How often?
every time the weight batch is made.

When do you want the reports to be generated?

Welcome to the forum.

What are you trying to do?

I am trying to make a report in excel, that I keep weight data.

Save some data - ok. How much data?
approximately 30 weighing, seals, operator name, weighing dates and times.

what kind of data?
decimals, data and time, integers, text.

How often?
every time the weight batch is made.

When do you want the reports to be generated?
every time the weight batch is made.

 

[James Mcquade]

As I said in my earlier post.

What version of rsview?
what os is the program running on?
is this a runtime package or a development package?

if it is a runtime package, do you have the same version of development package?

I had to hire someone to do the programming for the company.
you have to get these answers to start.

if you have the development software and your customer has the runtime, the version of software does matter.

i'm sorry, I have given you all the information I have, i'm not a vb programmer.
YOU MUST make backup copies of the application first!
this will save you a lot of grief if things don't work out.
james