Use of macro in Excel?

sheetal more

Hi,

I am working on an application where I need to populate huge data in grid. User can export this data to excel file and sometime user can download this data into excel file as well

Some time I am getting error while opening excel file.

“We found a problem with some contain in excel file.”

Team suggested to use macro in Excel, after implementing this I can open file without any error message.

But I did not understand how dose macros solved the problem and why my team suggested to use macro in Excel

Appreciate your inputs.

Thanks..

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vilas Shende7y ago
Yes, exactly agreed with @Suraj Kumar.

"Which kind of error were faced & also which problem found in some cells?" is the basic senario.

Once the error and problem be shared, then we can guess that what kind of macro they (team) are been using.
Also, please inform which kind of application is it, I mean its C#, VB or else?
+1
Suraj Kumar7y ago
Which type of error your are getting and the otherthing macro is used to do functionality in either automatic or resuable means. I want to say that macro is also a program written in language VB which is alrady itegrated with excel. For example if you have to send an automatic mail when data in excel changes with interval then you can write a macro to send the file or information automatically to anyone. You should either tell your actual error and requirement and also try to learn writting macro.

Hope this will help you.
0