Posts by Phillip2

    Thanks for looking at it Roy.

    I have attached pictures of my form and a sample image.

    Below is the beginning of my command button Sub.

    my plans was to just add a macro inside it that would use the value of TBrecord to populate the second page with the sample image.


    This is in a Excel 365 Userform...

    I have a command button (ADD) that looks at my customer's record number (TBrecord.value). If there isn't a number it assigns one, otherwise it edits the existing record.

    The second page of my userform contains a picture insert. I'm wanting to change this picture to a jpg image of a call tree diagram. These images are stored in a folder titled Images and are named with the customer's record number 001, 002, 003 etc. (TBrecord.value).

    I am trying to come up with a macro that I can add inside of my sub that will use the customer's record number (TBrecord.value) and insert it inside of the image's address when this sub is used.

    CallTree.Picture = Load Picture ("Y:\CCX Applications\") & ("TBrecord.jpg")

    Thanks in advance. I appreciate any help.

    Thanks Jack for your comment. Our organization is around 5000 employees. Of course all of them would have a need for a product such as this. It is my understanding that there will still be some who will be allowed to keep Office 365. I'm hoping that we will be able to successfully make our case as one of them. If not, it won't be the end of the world. :)

    RoyUK, thank you. While I most definitely understand the economics behind such decisions, I’m hoping that the benefits in our case will be seen. If not, then I be learning something new.

    Rory, thanks for your input. I had not thought much about Javascript. However, It may be helpful to convert to it instead. That kind of brings up another thought. Can macros also be written in Python, and Javascript for Excel?

    I would still be interested in hearing from anyone who may have had an experience with a converter. Do they work or they just do a hit or miss job?

    I do appreciate your sentiments Carim. However, I just trying to learn what my options are so that I can either make a convincing case for our department to be allowed to keep using Excel or devise the best plan for making the conversion. Again, any advice would be greatly appreciated.

    Our organization is planning to switch a large percentage of users from Microsoft Office to LibreOffice. Our department uses several Excel workbooks that include macros written in VBA. It is my understanding that these macros will not work in Calc and will need to be written using some other language.

    First of all, I’m not a programmer. I do have a limited knowledge of Excel and VBA and have been successful in several of our departmental projects. However, if our department is affected by this change, I’ll be starting over with a new language. I’m a little confused about the available languages. I’ve have seen references to Basic, Star Basic, and Python as well as others. I don’t believe that any of my scripts are going to be very complicated in the grand scheme of things. What would be the preferred yet simplest language to use?

    I have also seen several converters online. Just how good are these, and would anyone have a recommendation of one to use?

    Thank you in advance for any advice that you can give me.

    I have this macro working in a version with individual email buttons. However, I’d like to group everything together, so that I'm sending all of the customers emails with one macro. Currently, when I run this macro, it is sending out the first email but fail on the second. I also feel that this could be made simpler using a loop. Why is it failing?

    In addition, I’d like for the macro to test each “customer mail” folder and skip it if there aren’t any files to be sent.

    When the macro has finished sending, it cleans up by deleting all of the files in both the “Customer” and Customer mail” folders.


    That is looking good. I can see places where I could use something like that. However, it seems to be formatting a new sheet.

    Just so we understand each other. This is a report that has been generated by some other software and saved as a .xlsb file. Now, I am trying to add a little formatting to it to make it easier to read.