hi, Even if you use libraries in your project. You need the EXCEL should be installed on the machine where program is running. Instead of that you can run this in a server where Excel is installed and Pass the text file as arguement. After that the file is stored in the server. Then the excel can be pulled through FTP or Network Path...
Thanks, Manikandan.T On Fri, May 27, 2011 at 11:17 PM, renatoab <[email protected]> wrote: > Hi > > I have a program written in C# that comunicates with a VBA macro in an > Excel xls file. The macro creates a worksheet, imports data from a > text file to that worksheet, organizes the data in the cells, makes > some formatting, and save the new xls file. > The problem is: this program will need to work for users that do not > have MSExcel installed, but have OpenOffice or other similar > softwares. > The xls file generated can be viewed on OpenOffice and similars, but > Excel is still needed to run the macro and generate the file. > It seems to me that translating from the VBA macro to OpenOffice macro > language is very complicated, because they are very different. > I think a possible option is to translate the code to VB, VB.NET or C# > and compile it. I know those languages can create an Excel file and do > some operations on it. The question is: for me to have a program that > works with xls files, written in those languages, do I need to have > Excel installed on the computer? Or do I only need to have the > libraries? In case it is possible, do I need to have any component > installed on the users' computers? They are free? > > Thank you > > -- > You received this message because you are subscribed to the Google > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > Web Services,.NET Remoting" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > or visit the group website at http://megasolutions.net > -- T.Manikandan 09952027660 -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
