Import data script

  • Thread starter Thread starter Chiccada
  • Start date Start date
C

Chiccada

Hi gang,

Apologies if this is in the wrong place.

I am looking to create a macro in which i can update certain cells. Can I
get the macro to search for the latest version of the source data?

Eg if file B60A is the latest file and I add a B60B the script will update
all the necessary cells with the data from B60B. If the script is then run
again an error message shows saying that the sheet is currently using the
latest data.

Many thanks in advance for your time.

Chiccada
 
Hi Chiccada,
You could save the last file name used somewhere and when you run the macro check if the current file name is the same as the previous one. If it is, display the error message and exit. If not, do the update and save the new file name.
HTH
Paul
 
Back
Top