Closed

Excel vba 2016 and Applescript - Refresh Text Import

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]

abc (1).csv

abc (2).csv

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.

Skills: Excel, Visual Basic, Applescript

See more: grantaccesstomultiplefiles, mac vba filesystemobject, excel vba mac file path, vba open folder mac, mac vba loop through files in folder, excel mac vba open file, mkdir vba mac, macscript vba, text import excel net, find text web site excel vba, text import wizard excel, excel vba import text file chart, excel vba open word document text, import text excel vba, import data text excel vba, text import wizard excel 2016, excel vba save as delimited text file, excel vba save worksheet as text file, excel vba find and replace text in column, excel vba import text file tab delimited

About the Employer:
( 0 reviews ) Johannesburg, South Africa

Project ID: #23994871

8 freelancers are bidding on average $27 for this job

rashedkhanrubel

Hi, I will make Visual Basic code to import data from folder as per your requirement with good and professional quality without any error. Need to discuss more before start. I have completed more then 100 project with More

$55 USD in 2 days
(114 Reviews)
5.7
hemsingh1

Applescript, Excel, Visual Basic skilled professional with the required expertise. Can help to deliver the solution as needed on the expected lines. Please private message me to discuss the project further. Hope to bui More

$36 USD in 7 days
(9 Reviews)
3.4
ssuet123

Hey there, Hope you are doing fine. I have been doing work in Microsoft scripting, VBA, formulas, graphs and dashboard creation using pivots, for the past 5 years. I can do this job perfectly for you if you share more More

$30 USD in 1 day
(3 Reviews)
2.5
kashifmemon9115

Hello Sir I am expert in data entry and data processing also in MS Office (Excel , Word Ppt). I have writing speed of 50 wpm , I will do your project with 100% accuracy and perfection. I hope i am perfect for your proj More

$10 USD in 2 days
(0 Reviews)
0.0
mohitpahwa65

hi, I am a new freelancer with 2+ years of experience in DATA ENTRY JOBS. I have good computer knowledge with high typing skill. I am also waiting to get Data Entry Jobs from REPUTED EMPLOYEES like You. Hope I am the o More

$15 USD in 7 days
(0 Reviews)
0.0
hafizammar139

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

$20 USD in 2 days
(0 Reviews)
0.0
renato0216

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.

$20 USD in 1 day
(0 Reviews)
0.0
samirsarwari

I can get this done for you ASAP within 48 hours. I work as an Analyst and use VBA, Excel, SQL daily at work.

$30 USD in 2 days
(0 Reviews)
0.0