General information
Category:
Forms & Form designer
>I know it will sound nuts, but it is just the way of it. The program I am adding to has jobs and techs that go out and do them. All the job info is added/edited/stored in vfp. The daily schedule sheets for the techs is then drawn up in a spreadsheet and printed. As things change in the day, they are changed in vfp, and the spreadsheet.
>
>I know how to export table data to a spreadsheet. What I want to know is, is there a way to include a spreadsheet in a form, and if the data in the spreadsheet is changed, to get it to be changed in the vfp table at the same time. The only term I can think of would be 'mapping' the data from the table to the spreadsheet, and back again... In this instance, the spreadsheet is a logical way, and a practical way to 'create' the schedule, and using a vfp grid would not replace that practicality, and this is the reason for my question. Yes - I can make a report that will mimic the spreadsheet layout for printing the schedules, but a report is 'output', and not 'input'.
>
>Thanks.
Use the Excel Workbook activex?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only