It means that this sheet is some kind of database. xlsm file in some sheet there are storage bins added to be considered by app. Normally to process data, content of exported file should be copied to. What is important, user has to processing data exported from SAP. Application has been created in order to check some warehouse storage bins – details are’t needed. Next code is my project which shows how to use. One is opened worksheet and the second is. Excel sees that two files are using such as ThisWorkbook and ActiveWorkbook. After adding add-ins to Excel, your VBA code might be run in every. xlam file might be use as “database” to storage needed data. In order to know how to create XLAM add-in please read this post: “Excel XLAM add-ins creation”.įollowing code confirms that. My project has been saved on network folder with authorization to all users. Some time ago I’ve made test with XLAM add-ins as VBA code collection and database too. From some time I’ve tried to find solution for fast and simply database use in Excel.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |