(Similar to how it's possible to have Excel VBA open Word and create a new Word doc with data from Excel all from the Excel side - the end user doesn't need to touch Word). if I can have a macro in Excel that will open Access as an external object and run it from Excels VBA then that is one less hurdle for the end users. I wanted to avoid bringing Access into the picture as that would mean yet another program that the end uers would have to deal with (particularly as I know some of them have no idea on how to use Access). The end users already have to convert data between Excel and another program and then back again later on as part of the process required by this project ( yes, it would be better to have the entire process run in Excel but managerial decisions create the current situation ). I am approaching this problem with the end users in mind. Convert your Visual FoxPro database files to Excel files online. I realise that and agree with what you say. Access can either link or import Excel data, easily.
