![]() So I'm hoping that printing into Excel would possible. I can print the order (3 to 6 pages) to a PDF, but from experimenting with this it seems to take more time to print to PDF and export into excel then doing the process manually. ![]() By convention, there are several accepted extension types for flat files, including. Our thinclient won't let you select or copy text or anything on screen, and I don't have access to the database. In Access, you can launch the Export Wizard via File > Export from the menu when you have a table or query object selected: Select Text Files to generate a flat file. I would like to be able to capture the order information from the thinclient and populate the rest of the userform so the other steps of the process can be automated using VB. My ideal is for this userform to type the order number into to our thinclient via sendkeys, this part works fine so far. I've setup a userform that will allow someone to input the order number. I'll try to give a short description of what I'm doing maybe if printing direct to Excel isn't possible someone may have a suggestion that might work better. Note: Name of file cannot be localized or changed. The data in the files must have the same column and data types. (Optional) Toggle the Union Selected switch to append several Excel files together when the data is imported into the ElastiCube. Create a printers.csv configuration file with list of the printers that need to be added to the target user devices. This file display all the tables in the CSV file on the next screen where you select what tables to add to the ElastiCube. There are about 5 step now and if I can get this to work I should be able to get it to 1 step. This will install the Universal Print printer provisioning tool on all target Windows 10 client devices. Enter a Data Source Name and select the directory where the CSV file. I'm trying to reduce some steps when logging an order in. Under the User DSN tab, click Add and then select Microsoft Text Driver (.txt.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |