Käynnissä

URGENT within 12 hours - Excel VBA to monitor CSV file and import when file date/time changes

Hello,

I am looking for someone who can produce Excel VBA code to monitor a CSV file and automatically import the data when the file is updated.

I need this within 8 - 12 hours so preference will be given to anyone who has the availability to start and finish this small project as soon as possible.

BACKGROUND

I am importing 3 different CSV files to a spreadsheet that get updated with new data every few minutes.

I have tried using the standard Excel CSV data import and also PowerQuery.

PROBLEM

The problem occurs when Excel tries to import the data from a CSV file at the same time as the file is being updated. I receive a pop-up window stating "Excel cannot find the text file to refresh this external data range".

If you press OK and try again it works fine once the CSV file has finished. The problem is that this required human intervention. I want the files to continue updating seamlessly without any pop up windows or need for intervention.

SOLUTION

Therefore I urgently need a solution that can monitor the CSV files and only attempt to update the data when the file has finished updating to avoid any pop up interruptions in Excel:

1. VBA code that can be added to multiple sheets so that I can import data from a different CSV file into each sheet.

2. VBA code imports the latest date/time from the CSV file and places it in a cell in the sheet.

3. VBA code monitors the CSV file for a more recent date/time and when it recognises that the file has been updated it automatically performs a new data import.

4. Checking of the data file needs top be at least every minute, real-time if possible.

5. Need to be able to specify the starting Column and Row for data import.

Many thanks for considering this project.

- END -

Taidot: Excel, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: project end time, get external data, excel for windows 8, excel vba code examples update values, excel vba paste file, copy excel vba web file, time management urgent important template excel, excel vba creare file xml, excel vba write file, excel vba ftp file download, excel vba read file, excel vba xml file, import date time mysql fields

Tietoa työnantajasta:
( 31 arvostelua ) Brisbane, Australia

Projektin tunnus: #8650151

Myönnetty käyttäjälle:

serdaryalcin

1. I will write an Excel macro that will run and check CSV files timestamp in each minute. 2. In case timestamp has changed, it will import the content of the CSV files to an Excel workbook, each CSV file in different Lisää

80 $ AUD 1 päivässä
(4 arvostelua)
2.4

5 freelancers are bidding on average $87 for this job

wsh2

Rush job. At your earliest convenience, could you please attach a copy of your workbook(s) to this private message thread so that we may better analyze and discuss your requirement. Thank you in advance! Which ve Lisää

166 $ AUD 1 päivässä
(29 arvostelua)
6.1
ithuang2014

A proposal has not yet been provided

100 $ AUD 1 päivässä
(39 arvostelua)
4.3
TonmoyRoy111

A proposal has not yet been provided

60 $ AUD 1 päivässä
(27 arvostelua)
3.9
keystrickers

Hi .. Yes i read and understood your task very well. Surely you will enjoy my service as successfully served 2000+ clients so far from globe. Please award and release 50% upfront so that i accept and start this and s Lisää

25 $ AUD 1 päivässä
(2 arvostelua)
2.7
suryayogi

A proposal has not yet been provided

66 $ AUD 1 päivässä
(9 arvostelua)
2.7
gsanggara

Hello, I am interesting to your project & placed bid for your consideration. with 3year+ experienced in excel coder & formulas I am very confident that i will deliver good result as per your requirement on time. Lisää

30 $ AUD 1 päivässä
(3 arvostelua)
2.1
bharat022

Hello client, Hope You would be fine out there, I have gone through your requirement and understand you requirements please share all the details across to me so that I can go through it and start working on it. I ha Lisää

100 $ AUD 1 päivässä
(0 arvostelua)
0.0