Loading...
 
Multi-Language Add-In for Visual Studio

Multi-Language Add-In for Visual Studio

Forum List Topic List

Forums > Multi-Language Add-In for Visual Studio > Problem with Excel Resource Transfer and Multi-Language Add-In
 
Thread actions
Print this page
  • Print all pages

    • Problem with Excel Resource Transfer and Multi-Language Add-In

    Posted by BIG on Wed 17 of Sep, 2008 10:38 GMT

    Hi,
    I have also downloaded your Execel Resource Transfer...........
    ....but there is a problem!!!

    The Multi-Language Add In allow you to create .RESX files, but the Execel Resource Transfer allow you to Import and Export .RES files.

    I want open my .RESX files created by the Multi-Language Add-In with the Excel Resource Transfer, make changes and save.......

    Can I Help Me????


    Thank You


    LUCA

    Reads: 56205
    Link
    Posted by Phil on Wed 17 of Sep, 2008 19:48 GMT Germany

    You are right, Excel Resource Transfer does not support .resx files.

    I would like to add support for .resx files, but there is a minor technical problem. Excel Resource Transfer is a COM Add-In for Excel, originally for Excel 2000, and it is written in VB6. ResX files are more of a .NET thing, so the question is, what would be the best technical solution.

    Now I guess that I could read and write the ResX files as XML files in VB6. It is easy enough to use the Microsoft XML classes (msxml6.dll) in VB6, but I don't think this would be a great solution.

    I would really prefer to use the ResXResourceReader and ResXResourceWriter classes in the .NET framework.

    There may be some simple way to do this from VB6, probably via a wrapper, but again, I don't think that this would be a great solution.

    In fact, I think that the only good solution is to write a new Add-In in .NET. This is probably quite easy. Short term, I would have two Excel Add-Ins, one for .res and .rc files (in VB6) and one for .resx files (in VB.NET or C#). Sooner or later, I would port the VB6 code to .NET.

    I have a bunch of other things to do, but I think that this would be a sensible project.

    Phil

    Link

    Posted by BIG on Thu 18 of Sep, 2008 09:21 GMT

    Thank you Phil.

    Please when you port the VB6 code to .NET write me a little e-mail to luca.bruccoleri at bigsrl.it.

    It's important for me!!!


    Thank You!!!!


    LUCA

    Link

    Posted by BIG on Thu 16 of Jul, 2009 08:50 GMT

    Hello Phil,
    have you got some news about this topic?
    Do you have developed something??

    Thank You

    LUCA

    Link
    Posted by Phil on Thu 16 of Jul, 2009 22:52 GMT Germany

    I have been working on version 4.65 of the Multi-Language Add-In, which I am still testing, and I havn't seriously started on a new version of Excel Resource Transfer.

    Until about 2 hours ago.

    All I have done so far is to make an Add-In for Excel 2007, which can read a single resx file. It adds a group-box to the Add-Ins ribbon. As it stands, this add-in is fairly useless, but it at least shows how easy it is to read a resx file into Excel.

    I have copied the Visual Studio project to my homepage in the file http://jollans.com/ExcelResxAddin_Source.zip. Although I might develop this into a product, I'm not giving too much away by making this public.

    If this is any use to you, you are welcome to develop it further into something that you can use. I will try to do some more work on it in the next few days, but I don't really have much time.

    This demo project just reads a single resx file into a worksheet. For the purpose of localization it would be necessary to read the resx files for all languages into a single worksheet, generating one column for each language. Of course, there would have to be a function to write back to the resx files. In my opinion it should be possible to add new languages to worksheet, which could then be exported to additional resx files.

    I would probably want to make the worksheet format similar to the format generated by the Multi-Language Add-In.

    In addition, I would want a feature to select a visual studio project and to read all resx files in the project, into multiple worksheets.

    Finally, I would want to add support for the global database used by the Multi-Language Add-In.

    By the way, is an Add-In for Excel 2007 OK for you, or do you use Excel 2003. Older versions don't support Add-Ins in .NET (at least not easily) so I am not considering them.

    Phil

    Link
    Posted by Phil on Sun 26 of Jul, 2009 18:50 GMT Germany

    I have done a bit more work on this project.

    By far the most difficult part of making an Excel Add-In is to create the installation. In comparison, actually programming the functionality seems easy.

    You can download the setup file with the link:
    http://www.jollans.com/SetupExcelResx.exe

    This version adds a frame to the Add-Ins ribbon with a button to read a resx file. If there are multiple resx files for different cultures, it will read all of them into a single worksheet.

    Although this functionality is not really useful (without being able to save changes back to the resx files) I would be really grateful for feedback about whether the setup program works.

    (I will now remove the test project mentioned in the previous post from the server.)

    Phil

    Link