Open in same window

[Dnphm]

Hi,

I am exporting access tables one after another into one excel workbook using VB coding but when I export, it would open the same excel workbook but in a different window.

How can I keep it to just the window that is already open from the first export?

Thanks

 

[DCrake]

What code are you using? Is it doing it on a loop?