Looking for vba code for Excel for Mac 2016 to select a file based on a file mask and extension in the downloads directory and refresh the text import.
eg downloads folder contains many other files including
[login to view URL]
I would like a button on excel (marked REFRESH) that when pushed will open the file selection dialog and show only -csv files
-whose filename contains the characters in cell K1 (eg A1 contains abc, so it must only list the 3 files above)
-sorted newest file on top.
When the file is selected, the Edit Text Import on that page must be refreshed with data from that file.
Source code to be supplied in Excel file supplied, as described above to demonstrate that it works.
See attached files.
8 freelancers are bidding on average $27 for this job
I have a lot of experience to conversion of in to other file or format. Experience level in editing. Relevant Skills and Experience Highly conversion skills
Hi , there! I am expert Visual basic and Excel vba. I have read your requirement and understood perfectly. Can make excel 2016 macro or VBA to control CSV files. Looking forward to hear good response. Thanks & regards.