Add custom column with timestamp

Hi,

I am updating data from a csv file using attached code.

Request help with below …

1. Need a custom column to be added (say in column V) with timestamp, everytime data is appended

2. This data is an extract of a code in Python. Is it possible to check every say 5 minutes if data in csv file has changed. If changed, append data to excel with timestamp and if not changed, do nothing.

Thanks


Rgds,
Dhruv

Possibly with...

Please Login or Register  to view this content.

Thanks a ton for your help. This code does solve part of my problem.

I would like excel to check every say 5 minutes (if possible between time 9:15am to 3:30pm, everyday) for an updated file (check if file in location (path) is same as last updated file or now, if same then do nothing else update …

can that be done …

Thanks

Regards,
Dhruv

Thank you so much for all your help .. I never knew this forum and its members are this helpful .. really appreciate your help here …

The code is doing what I wanted but I have to select csv file each time (every 5 mins). Would it possible to just select file once (the 1st time I run the macro) and excel appends from same csv every 5 mins till I stop the macro …

Thanks again for your help …

Rgds,
Dhruv

Not sure,but this may work...

Please Login or Register  to view this content.

...and make sure this line is at the top of the code module

Please Login or Register  to view this content.

Hi,

I am getting attached error message.

Also the data is getting appended only on the 1st entry of the data table and not for all entries.


Rgds,
Dhruv

Try changing this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Hi,

I made suggested change but excel still asks for the file location post 15 mins. Can you tell me how I can fix filename and path instead of excel asking for location 1st time and then appending for same file. I change the filename everyday in the macro in the morning.

Rgds,
Dhruv

Change the highlighted line to match your file...

Please Login or Register  to view this content.

I did this .. now the file is updating but in between at times excel is appending data 4 times of the same date and time (same data), immediately after that it would append data of less than 5 mins time and then append actual data which is 5 minutes after the previous correct 5 mins data …