We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

VBA macro

Thread ID:

Created:

Updated:

Platform:

Replies:

66917 Aug 5,2007 04:16 PM Aug 18,2007 06:23 AM Windows Forms 4
loading
Tags: XlsIO
rsznajder
Asked On August 5, 2007 04:16 PM

Hi

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

Example in attached file

Thanks for help
Roman

doc_4960.zip

Sarath Kumar G [Syncfusion]
Replied On August 6, 2007 09:07 PM

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

rsznajder
Replied On August 7, 2007 12:45 PM

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

rsznajder
Replied On August 13, 2007 02:34 AM

Hi Sarath

What about my problems?

Melba Winshia [Syncfusion]
Replied On August 18, 2007 06:23 AM

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;