VBA macro

Hi

Is it possible to read excel file with working CommandButtons to GridControl?

Example in attached file

Thanks for help
Roman

doc_4960.zip

4 Replies

SK Sarath Kumar G Syncfusion Team August 7, 2007 01:07 AM UTC

Hi Roman,

Thank you for your interest in Syncfusion products.

It is possible to make use of VBA-Macros using Essential XlsIO. You can find the sample that illustrates this issue from the following URL:


C:\Documents and Settings\{UserName}\My Documents\Syncfusion\EssentialStudio\5.1.1.0\Windows\XlsIO.Windows\Samples\2.0\VBA Macros

Please have a look at the sample file and try to open your sample file in the sample program. Please let me know if you face any issues.

Regarding the sample file you have sent, I am not able to see any command buttons in it. Can you please resend your sample files which will be more helpful for investigation.


Regards,
Sarath


RS rsznajder August 7, 2007 04:45 PM UTC

Hi Sarath

I've checked an attached file I've sent to you and there are 4 CommandButtons on sheet1 (C42,N42,C66,G66)- to see CommandButtons you have to open file in Excel not in GridControl. This is one of 5000 documents I want to move to my EssentialStudio. The problem is how to do this automatically. So the answer isn't so simple.

1. As you can see some of cells has wrong formatting:
a) borders R8C4, R17C4, R18C4, R19C4 etc.
b) fonts on sheet2 R41C2,R42C2,R43C2
c) background R4C9,R5C9,R6C9, R17C4, R18C4, R19C4 etc.
How can I to solve it (I use ExcelLikeUI sample).

2. More complex problem is to move VBA macros with dynamic interface - CommandButtons. Is there any possibility to find out that a cell has CommandButton inside during reading excel file to GridControl?

Understand me Sarath. With such amount of bugs Xlsio is useless for me. So you must spent more time on competent solving problems from point 1.
I don't expect simple solution on point 2, because it is over functionality you deliver. I think about translating vba macros to c# and recompiling them. The main point is where is an information about CommandButton in cell and how to read it using e.g. GridExcelConverterControl?

Most important for me is to solve problems from point1. EssentialStudio (v.5.1) is great but Xlsio needs some corrections or I do something wrong.
About p.2 I send you another sample.

Regards
Roman

test104.zip


RS rsznajder August 13, 2007 06:34 AM UTC

Hi Sarath

What about my problems?


MW Melba Winshia Syncfusion Team August 18, 2007 10:23 AM UTC

Hi Roman,

I apologize for the delayed response.

Issue 1:(wrong formatting)
--------

We have identified this issue to be a defect and we thank you for bringing this to our attention. To facilitate tracking the progress of the fix, and timely resolution, we request you to create in our incident database Direct Trac. Our development team would be able to determine the fix and alert you with the service pack download details as soon as they are made available.

Issue 2: (Is there any possibility to find out that a cell has CommandButton)
--------

We do not provide support for macros and it is not possible to find out that a cell has a CommandButton or not while reading excel file to GridControl. Sorry for the inconvenience caused.

Please let me know if you have any other questions.

Thanks,
Melba


Loader.
Up arrow icon