Category: Accounting
-
Auto Unzipping Files and Loading of Excel Files
We used this function to automatically unzip Excel files , the 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…
-
Agresso Budget Loading from Excel
Actually this could be used for a variety of purposes but I wrote this for Agresso. This is designed for a sheet with the data in column d , e and f which was required by period and transposes for loading. Use the x variable to define the offset relative position, this allows you to…
-
Creating SEPA Files
I used Chilkat XML when working with XML, I have also used MS XML but find Chilkat better. This code will create an SEPA XML file using the passed details in transaction and header recordsets. I am reworking this into a sample Excel file for those who have a small volume of variable SEPA payments…
-
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…
-
Sage Invoice Loading
In our sample application we have loaded a number of samples to work with Sage Line 50. The sample below was used to create invoices. The sources for the header and transaction will vary depending on the source but this sample will get you started. You will need to create a link to the Sage…
