Posts by JRCross

    Hi there


    I'm working on an excel form at the moment, and one of the things I want to be able to do with it is save it to a specific location


    However, the location varies depending on which person the form relates to



    I have a group of folders that has everyone's name allocated to one folder, and i need to save the document to somewhere in those folders




    Is there some sort of way to search a group of folders for part of a folder name and use that as an identifier?


    If you need more clarification please let me know. I'm sure there's a way to do this but i dont know how

    Re: Open new instance of Macro


    Hi again


    So my program is mostly finished, so show snippets of it because there is a lot of code


    Basically at the top, I have the initialise function:

    Code
    Public Sub UserForm_Initialize()
        ITCustom = False
        CACCustom = False
                
        Dim ChkBoxes As cls_ChkBox
        Dim ctrl As Control
    
    
        Set colTickBoxes = New Collection
    .......


    And at the end of the code, with my "OK button", I have this



    I have a checkbox at the end of my form that I want to code so that if it is ticked when I click OK, it opens a new instance of my template, with a separate word document as well


    How can I do this


    Again, if further clarification is needed, I an happy to assist

    Hi there


    I currently have a VBA function that I've been working on for some time, and it's almost done


    However I realised that for practicality, it would be beneficial to run a new instance of the same macro as soon as the current one is finished


    Does anyone know how to do this?


    Here's what I have



    My VBA file runs from a .dotm file (macro enabled word template)
    Once the macro has run and users have input all their data and the macro has processed it all, it spits out a word document using bookmarks


    What i want it to do then is start a new instance of the template so the macro starts again



    If any clarification is necessary please let me know


    Thanks!

    Re: Excel to Word Conversion


    I'll try to elaborate a little more


    What I could have said instead of "stand-alone" is a visible macro. I work with code a lot more and generally it runs in the background without much visible about it. Instead I want something that fills in with a form


    Basically what the macro is meant to do is generate notes after calls. Doesn't really need to be formatted, just generated.


    The purpose of the radio buttons will be to a) select different scenarios that have occurred that generate a different set of notes, and b) to access different parts of the form, i.e. if a call is inbound or outbound, a different set of selections are available


    In terms of free text, the macro won't be able to encompass all different scenarios, and some things just can't be generated, so free text or a text-box within the macro is something I want to have available as well


    I've begun some work on building a macro in Word, but I wanted to know if there's a better way to do it

    Hi there


    I am trying to generate a word document using either excel code or some other form of macro


    What I'm aiming for is a stand-alone macro that had radio buttons to select based on scenarios, and also has areas for filling in text as well


    At the emd of the macro it should generate a word document based on conditions selected on the sheet and code that i've filled in


    Once I get started properly on the project I should be able to work out most of the things i need, but getting off the ground with some kind of starting point is difficult


    Any suggestions?