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:

    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


    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?