Search:

Type: Posts; User: DougieW; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. [SOLVED] Found a way using macro in the template's ThisDocument. May be useful to original poster

    public aDoc as word.document 'in a standard module

    Private Sub Document_Close()

    If aDoc Is Nothing Then Set aDoc = ActiveDocument
    With aDoc
    'in case you forgot to re-protect
    If...
  2. Replies
    4
    Views
    888

    Hi All, Yes, I was looking for the same as...

    Hi All,
    Yes, I was looking for the same as 2003. It's 2007 I'm using which was where I noticed the missing recorded date. It's a minor inconvenience but an inconvenience nonetheless and was one of...
  3. Replies
    4
    Views
    888

    word/excel 2007 macro created date

    Hi all,
    I find recording a VBA macro doesn't save the created date, office 2000 & 2003 did. Is there a hidden (MS again) option somewhere? :confused:

    Thanks in hope

    DougieW
  4. from one retiredgeek to another - sometimes the...

    from one retiredgeek to another - sometimes the most obvious things are the hardest to see. Although I had been using that code since 2009, I realised that it was only this year that particular line...
  5. Format(Year(Now) strange results in Word 2007 VBA

    Hi All,
    Does anyone have an explanation of this. Found it while migrating some word 2000 templates and code to 2007. The attachment is a screen grab of the VBA watch window, The code...
  6. Problem Solved

    Hi All,
    Thanks all, particularly to Maud - you put me on the right track. It was the method of calculation, which is a bit bizarre, but well explained in http://support.microsoft.com/kb/214395 -...
  7. Hi Maudibe, I haven't used Worksheet_Calculate()...

    Hi Maudibe,
    I haven't used Worksheet_Calculate() event in any of the sheets. I'll try your other suggestion though it will take some time as there are quite a number of them.

    Dougiew
  8. Thanks for your message

    Hi RetiredGeek (so am I)

    I was afraid someone would ask for this but I will send something. I'll need to anonymise (is that a word?) the data but I'm sure I can, and I've got baby sitting duties...
  9. Excel macro function firing when it shouldn't

    Hi all,
    This has been bugging me for quite some time and can't make sense of it. I have an excel 2000 spreadsheet with a number of sheets. One sheet holds demographic info on members of an...
  10. Replies
    3
    Views
    476

    Does the userform get closed after the first run,...

    Does the userform get closed after the first run, or is it just hidden?
    Hi HansV,
    I should have got back earlier - the problem was faulty coding, my own fault. I had a line in the wrong place. When...
  11. Replies
    3
    Views
    476

    Hi, help anyone? I'm using a button on a...

    Hi,
    help anyone?
    I'm using a button on a modeless form to create a mailmerge document (modeless so I can see what is happening). Works perfectly 1st time, but calling the form again, the form...
  12. Replies
    3
    Views
    809

    Re: userform control (word/excel 2000)

    Thanks HansV,
    I had all the stuff in the 2nd part - I think my problem was that my code to start the form was in the Forms module. Since your solution didn't say where to put it I thought I'd try...
  13. Replies
    3
    Views
    809

    userform control (word/excel 2000)

    Anyone know how to open/initialize/show an Excel userform from a Word userform?. I can start the Word userform, open, use and manipulate excel data but can't find how to start a userform created in...
  14. Re: Question Regarding forms in Word 2000 (MS Office 2000 SR1)

    Edited by HansV to replace very long URL with a link

    Thanks Steve but while I was searching I cam across this in google groups see here
    There were some answers using textheight and textwidth vb...
  15. Re: Question Regarding forms in Word 2000 (MS Office 2000 SR1)

    Hi Steve,
    I have a very similar problem in that I need to truncate text (if necessary) to fit between two tab positions in a document. The tab positions are set using...
  16. Re: Custom Template (PowerPoint 2000 (9.0.2716))

    Edited by HansV to provide link to MSKB article by using <!t>[MSKB=326530]<!/t>
    I had the same problem - and found <!mskb=326530>Microsoft Knowledge Base Article 326530<!/mskb> it seems to be the...
  17. Replies
    0
    Views
    247

    Replicated database Security

    Hi to all Access Gurus - I'd appreciate comments/opinions/options on the following problem.
    MS Access 2000 security of replicated database problem.

    Working Scenario:-
    Main DB on network server...
  18. Replies
    3
    Views
    333

    Re: find text in a single row (XL2000 sr1)

    With Worksheets("Feb04").Range("B:B")
    Set n = .Find("M", LookAt:=xlWhole, LookIn:=xlValues) ' do you need to look at whole or part???
    If Not n Is Nothing Then ' Found...
  19. Re: Error mesage: Rundll32 has caused an error..

    I recently had a similar problem with a friend's PC and DID find something on knowledge base regarding "..... caused an error in mmsystem.dll" Can't remember the kb number but the fix was a missing...
  20. Replies
    3
    Views
    447

    Re: Printer codes (2000)

    PRINT field looks like it should be the correct way to do this but it doesn't seem to work with all codes and/or printer drivers. I found lots of other stuff on the web that explains why it doesn't...
  21. Replies
    3
    Views
    507

    Re: US vs UK date formats (Office 2000 SR1)

    Steve,
    I have also had lots of problems with Excel mangling dates and found a variety of solutions over the years. One rule I make now is to set up a custom date of dd/mmm/yyyy to ensure I get the...
  22. Replies
    3
    Views
    447

    Printer codes (2000)

    I want to send printer escape codes to a network printer from a Word macro but I'll probably want to port it to Excel and maybe others. Basic problem is to tell printer to switch duplex on/off but...
  23. Replies
    7
    Views
    511

    Re: copying and pasting multiple times (2000)

    Hi Alex,
    Me again. I don't see your ' end if' s, and I'm not sure about your select and paste ranges i.e. you have range("C7:BG11") which you are copying to a different sized range("C7:BG7????). ...
  24. Replies
    7
    Views
    511

    Re: copying and pasting multiple times (2000)

    Alex,
    Not sure I understand your question but I notice in your set pasterange = worksheetsSheets("macro calc").range("c7:bg7") - you have 'sheets' twice! that shouldn't affect copyrange though.
  25. Replies
    4
    Views
    6,041

    Re: Read Excel Data into Word (VBA)

    Richard - I have a suite of Word macros which control an Excel spreadsheet. One takes data from Excel and places it in Word; the other takes from Word and places in Excel. I've added it as a .txt...
Results 1 to 25 of 34
Page 1 of 2 1 2