VBA and Macros

Using Text Files to Connect Excel with Systems Data

Excel-based planning and scheduling systems need data.   Best practices in developing Excel systems say:  “Separate data storage, calculation and reporting.” A database the best place to store data.  Our Excel tool needs to bring it in, perform calculations and then send it back out.  The output tables can then feed reporting and, perhaps, update the

Using Text Files to Connect Excel with Systems Data Read More »

Scroll to Top