Search:

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

Search: Search took 0.00 seconds.

  1. Below is how it turned out. In the end; took the...

    Below is how it turned out.
    In the end; took the “Not” out of If Not Dir(strFilename), only because it was easier to handle this way around, couple of extra
    If’s and that was it.


    Sub...
  2. Thank you Richard for your reply. Have placed...

    Thank you Richard for your reply.

    Have placed your snippet at beginning of my code so can now establish if file already exist, with this


    ' Declared variables
    Dim wdApp As Word.Application...
  3. No Filedialog message to say file already exists

    The code below will look familiar to some!

    (Controlling Word from Excel)

    When saving, I do not get filediolog message saying file already exists, my code as it is just over writes/replaces the...
  4. I would hate to let on just how long this has...

    I would hate to let on just how long this has taken to get running; basic typing errors, template.dotx file kept being corrupted, lack of vba knowledge, but it was the removal of ;


    “&...
  5. With a correction to my typo error in the File...

    With a correction to my typo error in the File Path Name and bit of trial and error I have managed to get the template “Timesheets.dotx” open and saved with the new file name.
    However I have quit...
  6. Thank you macropod, your help is very much...

    Thank you macropod, your help is very much appreciated.

    As yet not had chance to fit what you gave me in with what I am working on. (slow process due to my inexperience)

    A cheeky after question...
  7. From Excel open Word template then save using filepath name

    I am very much a newbie with vba and stuck on what must be the most basic if things.

    From Excel I am opening a Word.dotx file, and then copying a range from Excel to a bookmark location in the...
Results 1 to 7 of 7