You are right I should have posted it to VB Office (Classic).
I thought of the same process you suggested. However, how can I access VBA to create the 'small Excel VBA app' (the driver app)to perform what you suggested.
I have no problem accessing or storing workbook/sheets across directories...
I have three Excel apps using VBA and running into memory problems. The topmost app PPMS_SYSTEM is basically a Project control app which keeps track of project id's and project related attributes. The user selects a project and PPMS_SYSTEM creates a sheet which is to be passed onto one of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.