in reply to How to control (in a generic way) population of Excel file from another Excel file

Have a look here, I had to do something similar in the past and generic-ized it with a program with many options.

https://github.com/vinsworldcom/pests

  • Comment on Re: How to control (in a generic way) population of Excel file from another Excel file

Replies are listed 'Best First'.
Re^2: How to control (in a generic way) population of Excel file from another Excel file
by woland99 (Beadle) on Nov 10, 2015 at 23:35 UTC
    Thanks a lot! Very helpful to have a working example and compare notes! I wrote a small library for myself - to do various basic tasks on Excel files and it grew over time to 18K lines but badly needs refactoring. Somewhere there I am doing similar things to your script but it will be VERY helpful to look at same problem from different perspective. And some things in OLE I struggled with. Thank you!

      Mine could use some cleaning up too. But it works for what I needed, so never went back to clean it up.