|
Your time now: Mon Nov 23, 2009 11:49 am
|
View unanswered posts | View active topics
| Author |
Message |
|
eliyazk
|
Post subject: Pls Help..Excel File is gettin Visible while copyin usin VB6 Posted: Wed Sep 30, 2009 9:57 am |
|
Joined: Wed Sep 30, 2009 8:28 am Posts: 2
|
|
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
|
|
| Top |
|
 |
|
eliyazk
|
Post subject: Re: Pls Help..Excel File is gettin Visible while copyin usin VB6 Posted: Thu Oct 29, 2009 7:58 am |
|
Joined: Wed Sep 30, 2009 8:28 am Posts: 2
|
|
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
|
|
| Top |
|
 |
|
Page 1 of 1
|
[ 2 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 0 guests |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|
|