A
I am trying to write a VBA code in excel for a what I feel is a rather silly task! and don't ask me why we have to do it. OK here goes:-I have an opened spreadsheet in .xls format which is linked via DDE to In-Touch. I want to rename it and save it into a csv format so that the live DDE data becomes captured (dead). All these have to be done automatically at a specified time with no operator input.
I got through most of the code and everything works fine until Excel pops up with the question of "do you want to save changes to the file C:\ etc..." It gives you an option of Yes, No and Cancel. I have tried ways and means to send a keystroke to acknowledge it. It seems that it does not accept the sendkeys command in VBA. You still have to manually answer excel which somehow defeats the purpose of this whole exercise. Is there any way of disabling these warning functions in excel or does anybody have a better way of doing it. Your worthy advise is much appreciated.......
I got through most of the code and everything works fine until Excel pops up with the question of "do you want to save changes to the file C:\ etc..." It gives you an option of Yes, No and Cancel. I have tried ways and means to send a keystroke to acknowledge it. It seems that it does not accept the sendkeys command in VBA. You still have to manually answer excel which somehow defeats the purpose of this whole exercise. Is there any way of disabling these warning functions in excel or does anybody have a better way of doing it. Your worthy advise is much appreciated.......