Pls Help..Excel File is gettin Visible while copyin usin VB6

[eliyazk]

Dear All,

Please Help...............
I am developing a tool in VB6.0 for plotting graphs in Excel workbook.

My problem: The output Excel workbook is getting visible to end user(while plotting graphs) when i am trying to copy one sheet to some other location in same excel workbook using VB6 app.

After executing the following code "objectWorkSheet.Copy after:=objectWorkbook.Charts(iChartIndex)", Excel file's Visibility property is getting changed to true. Please help how we can avoid this Excel file from getting visible.

Technologies used:
VB6.0
Excel 2007

Thanks in Advance

Eliyaz. K

[eliyazk]

Sorry for late response

the problem i got was solved

cause of issue:
Excel is getting visible when i am trying to copy/move any sheets that contains the some ActiveX components like Button, text boxes etc.,
This problem is only office 2007 Sp2 only.

i have solved the problem by replacing tha activex components with some other components.

Thanks,
Eliyaz. K