Hi All,

I am extremely new to VB. I am creating an app that manages individual excel lists and compiles them into a larger global list. When one individual list is closed it opens the global list and updates it via VBA, then closes both. I had it all working fine in VBA. Then my boss asked me to integrate it all into a standalone app. I read somewhere that you can use an active X browser to open the excel files inside VB forms. It worked beautifully with all of the macros until I try to close the file and update the global list. I get an error at the open command in the VBA macro. I am assuming it has something to do with the browser because I can still open the inidivual list from excel and have it update the global list.

hope this was coherent....

thoughts?

thanks in advance