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

Private Sub cmdOK_Click()
    Dim DebtParameters As String
    Dim Lodgements As String
    Dim lodging As Boolean: lodging = False
    Dim Defaults As String
    Dim EndOfNotes As String
    
    Dim ITInt As Integer
    Dim CACInt As Integer
..................
....................
.....................
    Application.ScreenUpdating = False
    With ActiveDocument
        If Not Lodgements = "" Then
            .Bookmarks("DebtParameters").Range.Text = DebtParameters & vbCrLf & Lodgements
        Else
            .Bookmarks("DebtParameters").Range.Text = DebtParameters
        End If
        .Bookmarks("Defaults").Range.Text = Defaults
        .Bookmarks("Calls").Range.Text = EndOfNotes
    End With
    Application.ScreenUpdating = True
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    If cbxNewNote Then
    End If
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
    Unload Me

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: Word Play

Star

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?