Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TrevJones

  1. TrevJones

    Corrupting attachments sent via CDO VBScript

    Thank you very much, setting the MIMEFormatted property to False seems to have worked. It was hard to see what was wrong with the attachment as word just wouldn't open it and the actual file was ok. Thanks again
  2. TrevJones

    Corrupting attachments sent via CDO VBScript

    Hi I am having a problem with certain word documents I am sending via CDO message. Some attachments are ok but some cause problems when they are being opened in word. The original document is ok, it is just the attachment that is causing a problem. The code i am using is Set MyMail =...
  3. TrevJones

    VbScript Word formatting problem

    Thanks very much, that solved the InchesToPoints problem. There are still other issues but i'm very nearly there. Thanks for putting me in the picture
  4. TrevJones

    VbScript Word formatting problem

    The InchesToPoints as far as I can tell are part of word document pagesetup object. I can't see any difference in this code to examples I have seen on the web.
  5. TrevJones

    VbScript Word formatting problem

    I am trying to use the following code to open and format a word document but it fails with Microsoft VBScript runtime error: Type mismatch: 'InchesToPoints' I have no idea what is wrong with the code which uses word97 Dim appWord Set appWord = CreateObject("Word.Application")...
  6. TrevJones

    #DIV/0!

    I take it that you mean if either of the three values have 0 in them then return 0. If this is so, just multiply the three values together and if one of them is zero the answer will be zero ie IF((x1*Y1*z1)=0,0,....) or i could be completely wrong .....
  7. TrevJones

    Tape name

    Pardon my ignorance, I know very little about backups, never mind Veritas software, but does any one know of a utility like tapetest in arcserve that can be run on the command line and return the name of the tape that is loaded in the drive?
  8. TrevJones

    Word Macro

    Thanks for the replies. The problem i had was that the filenames were being generated in part by parameters being passed in. I had the If exists statement in the code but due to the parameter, the filename had a space in it. This meant that the IF statement didn't work (I assume it was...
  9. TrevJones

    Word Macro

    I am using a batch file to open a document in word and run a macro against it using the /m switch. Normally this works fine. However, if the file name doesn't exist, word just hangs and expects a key press to clear a message box. This code needs to be run in batch mode without user...
  10. TrevJones

    Test Backup through Arcbatch

    Does anyone know how I could run a test backup i.e. backup up a server but not write to tape, in a job run through arcbatch. Any pointers would be appreciated :^)
  11. TrevJones

    Logon to Outlook

    I need to write some vbscript to send mail using the logon method. ie Set myNameSpace = myOut.GetNameSpace("MAPI") myNameSpace.Logon "profile", "password", False, True This works fine if it is set to display the logon dialog box, but if this is set to false, then...
  12. TrevJones

    ORA-12203 TNS:unable to connect to destination

    We run some sql scripts on NT through a scheduler running batch files. This has been working fine. However, we have discovered that if the sqlplus can not connect to the server it will report the above error, but sqlplus itself will not pass the error code back. It exits with a Zero, after...
  13. TrevJones

    Batch Files

    Thanks for that but unfortunately it doesn't mention specifying a particular tape to use. We can do this with Arcserve using the Arcbatch utility but we may need to do this with the veritas software. Thanks
  14. TrevJones

    Batch Files

    We need to be able to kick off a back up using the AT scheduler and batch files and I believe you can use the BEMCMD.EXE utility to do this but I can't find any information as to specifying a specific tape in the library. Does anyone know if this is possible?
  15. TrevJones

    Trying to use soon with the scheduler

    I have been trying to get a batch file using the soon command to put a job in the AT scheduler on a remote server. When it runs, it comes back with the message 'Access is Denied' although I am running it from a server in the same domain. This works with other PCs and servers. Has any one a ideas

Part and Inventory Search

Back
Top