Try to add the Excel Object Library to the your Object Browser and then Browse it for the necessary functions. That is the only way I know to find them.
I am creating and formatting a new Excel Workbook and in an Access module. Does anyone know how i could add a sheet from an already existing workbook to the one that I am creating. I cannot run any Excel macro. All must be written in VB Code. Any Suggestions??? The sheet is the only thing that...
I am creating an Excel spreadsheet through a module in Access. I am formatting using code as well. I was wondering if anyone knew how to develop a freezpane for my first row which is all Column headers. Does anyone know the code for this?
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.