R
Ray C
I have VBA code running in MS Access that generates an Excel workbook. This
code takes about 5 minutes to generate the workbook so I keep the Visible
property of Excel to False since I don't want the user to see what's going on.
However, I realized that if I launch Excel during the execution of my
automation code, my Excel file becomes visible and you see the cells being
filled by my code.
How can I truly prevent my running code to have its exclusive instance of
Excel hidden? I tried setting objExcel.UserControl = false but that didn't
work.
Thanks
code takes about 5 minutes to generate the workbook so I keep the Visible
property of Excel to False since I don't want the user to see what's going on.
However, I realized that if I launch Excel during the execution of my
automation code, my Excel file becomes visible and you see the cells being
filled by my code.
How can I truly prevent my running code to have its exclusive instance of
Excel hidden? I tried setting objExcel.UserControl = false but that didn't
work.
Thanks