Variables 2010

**bonriki** · 2012-02-27 12:20

Paul hi

As I stated in the last both LngFrnt and LngBk can be variable depending on the outcome of the evaluation.

As a bare minimum a report with 2 or 3 CARS could be as follows;

P1 - Letter
P2 - Report front page
P3 - Organisation details
P4 - 10 Report detail including overview and comment on each clause of the standard being evaluated against
P11 - 14 Inserted CARs
P15 - Recommendations page

The form
MoveCARForm.JPG

The code is what we are working on

**macropod** · 2012-02-27 17:35

Originally Posted by bonriki

As I stated in the last both LngFrnt and LngBk can be variable depending on the outcome of the evaluation.

As a bare minimum a report with 2 or 3 CARS could be as follows;
[LIST][*]P1 - Letter[*]P2 - Report front page[*]P3 - Organisation details[*]P4 - 10 Report detail including overview and comment on each clause of the standard being evaluated against[*]P11 - 14 Inserted CARs[*]P15 - Recommendations page

What you've described is a document with four pages of front matter and one page of back matter, between which is a variable number of pages. That's what I've coded for. If the number of front matter or back matter pages changes, please say so. Also, your 'form' is just an image. What I need for testing a document containing the userform & code, not a post with an image of the form.

**bonriki** · 2012-02-27 18:41

Paul hi

The reports will always have a constant first 3 pages. In my example the CARs would be inserted in a position variable between pages 4 and 11 so not sure how that would fit.

The back matter always begins with the "Recommendations" page and may vary from 1 to n.

I have attached the form to a blank document together with the InsertCAR macro if you wish to test this.

**macropod** · 2012-02-27 19:28

Hi Phil,

See attached. I've modified the code so that it doesn't care how many pages the document has (it now does everything using the SEQ fields as the foundation), plus I've added some extra error-checking to the input fields to ensure only digits are input. I've also added a minor tweak to allow a CAR to be moved to the end, which I think you couldn't do before.

**bonriki** · 2012-02-29 15:36

Paul hi

Thanks for the new code. When I first tested it seemed to work great. However, when I copied the macro to our global template, where it should reside, it didn't seem to want to work.
I created a document using one of our report templates from or database, inserted 4 CARs then tried to move them via the user form input. On clicking OK nothing happened, even clicking the Cancel button nothing happened.

**macropod** · 2012-03-01 00:43

Hi Phil,

The useform is now initialized via the UserForm_Initialize sub, which sets the LngCARs variable and populates the note about how you can relocate a CAR after the last existing CAR.

As the Cancel sub is yours (ie it was already there with your form), that suggests you've maybe copied the code into a module other than that attached to the 'frmShiftCAR' form. Try deleting the 'frmShiftCAR' form from your template, then simply dragging the corresponding one from the document attached to my post into your document.

**bonriki** · 2012-03-01 12:50

Paul hi

I deleted the old frmShiftCAR and dragged your new one to the template. However, the macro still will not work.

I am not sure the UserForm_Initialize sub is functioning correctly. While the form is initialized and the note is populated the numbering of the CARs is not.

NewMoveCAR.JPG

Cancel function works OK.

**macropod** · 2012-03-01 16:26

Hi Phil,

You appear to be working with a .dot or .dotm template with which the form doesn't get copied to the documents based on it. In that case, change 'ThisDocument' to 'ActiveDocument'.

**bonriki** · 2012-03-01 19:27

Paul

Your right we are using .dotm. Changed to ActiveDocument, recognises the CARs as numbers correctly on the UserForm but still doesn't move the CARs. UserForm just blinks with the OK button highlighted.

**macropod** · 2012-03-01 19:56

hi Phil,

Did you change both 'ThisDocument' references? If you've done that and the code still doesn't work, I'll need to see the template.

**bonriki** · 2012-03-04 12:55

Paul hi

How do I send you the template when the lounge doesn't seem to allow attaching that type of file?

PS; Yes I did change both instances of This Document

**macropod** · 2012-03-04 15:22

You could zip the file and attach that.

**bonriki** · 2012-03-04 16:02

Paul hi

I have included a report template, the blank CAR page and the group template that has your FrmShiftCAR macro included.

We push the group template out to users via GP to the Word startup folder, \Users\Public\startup. The report is generated using data from our CRM SQL database, the CAR form is located on all computers in the \Users\Public\Tempaltes folder.

All the computers are partioned to include a D:\ and we use the D:\ for all group templates and data.

**macropod** · 2012-03-05 19:50

Hi Phil,

Once I attached your IANZCAR document to your 'ianznorm0203.dotm' template, then added some more CAR pages to it, I had no trouble with the macro.

**bonriki** · 2012-03-06 12:38

Paul hi

Did you insert the CAR using the Addin from the ribbon?

This inserts each CAR before the Recommendations page hence the ned to identify the position of each one.

Thread: Variables 2010

Thread Tools

Posting Permissions

Internet Services

Web Development

Digital Marketing

Consumer Tech