Hi everyone,
I m quite a beginner in VBA and I was wondering if any of you can help me.
I v created a macro in excel to acess other excel files. when I launch my macro it then access the files to retreive the data needed.
Those files are linked to other files and then I have the excel prompt asking if I want to update or not these links.
Do you by any chance know a way to automatically answer yes (or no) to this and then avoiding the prompt.
Its a quite important matter cuz I cant do any modification on the second level files (the ones open with my macro).
Hope its clear enought (sorry if not )
Thanks
I m quite a beginner in VBA and I was wondering if any of you can help me.
I v created a macro in excel to acess other excel files. when I launch my macro it then access the files to retreive the data needed.
Those files are linked to other files and then I have the excel prompt asking if I want to update or not these links.
Do you by any chance know a way to automatically answer yes (or no) to this and then avoiding the prompt.
Its a quite important matter cuz I cant do any modification on the second level files (the ones open with my macro).
Hope its clear enought (sorry if not )
Thanks