Loading...
 
Skip to main content

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: 59995
    Link to this comment
    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 to this comment


    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 to this comment
    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 to this comment
    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 to this comment