Category: Accounting
-
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…
-
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
In this Excel Model you can create an SEPA XML file using the details you enter on the SEPA Debit tab. I used Chilkat XML when working with XML, I have also used MS XML but find Chilkat better. Chilkat XML is free and you can download the program from their website. Sepa Setup To…
-
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 a Sage Invoice. 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…
