Category: SAP
-
Auto Unzipping Files and Loading of Excel Files
We used this function for auto unzipping files , the Excel files had been sent by email and an outlook rule saved the attachments into a given folder The Unzipit function uses the Chilkat Component and Excel Automation to open and save the file into a specific folder and load the contents into an SQL…
-
SAP – Changing the format of downloaded files
The SAP system often downloads files as MHT which can be opened in excel but can be enormous. After getting a list of files for conversion I pass the file name (tmpFile) to this function to load the file listing and then save the file as Excel 2003 for easy import into and Access or…
-
SAP BOM Upload
To load a bill of materials into SAP I needed to create a XML file with the hierarchy of the bill. To start this project in Access you will need to set a reference to ChilkatXML (free from chilkatsoft.com), or you use MS DOM Object but I prefer the coding structure provided by chilkat, and a…
