import of txt files into excel via vba;
1.) redesign existing vba-code because now its a copy-and-paste code (its up to you redesign or new code)
2.) import of all existing data files saved in a folder - number of files may be different (now there is a path to every single file)
3.) import data since a given date (messagebox to type in given date)
4.) redesign data format (2 decimal places)
5.) fill free cells with data of last day
No locked vba-code accepted!
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file.
This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls if necessary.
Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
Regards