Hi,
I have a folder with CSV files in. I have a table ("tableA") which links to one of the CSV files, to be more persice oct_05.csv.
Now how can i get vba to when i run the function change the link of tableA to nov_05.
I know how to work out the month and ect.. the only thing holding me back is how to change the actuall link in vba
Any ideas?
Thanks
k0r54
I have a folder with CSV files in. I have a table ("tableA") which links to one of the CSV files, to be more persice oct_05.csv.
Now how can i get vba to when i run the function change the link of tableA to nov_05.
I know how to work out the month and ect.. the only thing holding me back is how to change the actuall link in vba
Any ideas?
Thanks
k0r54