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!

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

Search results for query: *

  1. rceddy

    Code to format Word Pictures works 1st run but won't on subsequent run

    I finally figured out the solution to this problem. For anyone with the same problem: InchesToPoints Method was not preceded by WdObjRec object variable. It ran the first time and created a reference that was not released and cause an error on additional runs. Original Code...
  2. rceddy

    Code to format Word Pictures works 1st run but won't on subsequent run

    Thank you for you're help. I ran and reran the code using the watch and msgboxes with the variables. The SendVar worked fine but the wdObjRec seemed to be the problem. I finally took the Word object out of the individual macro and declared it Public. That seemed to solve the problem. Quite...
  3. rceddy

    Code to format Word Pictures works 1st run but won't on subsequent run

    The first time that the macro runs it will format the new Word document size and format the shape size. It will not allow the size formatting in subsequent runs unless Excel is shutdown and restarted. These are the lines that will not run: With...
  4. rceddy

    Code to format Word Pictures works 1st run but won't on subsequent run

    I didn't think it made any difference about the variables so I had not considered that. I did go back and change the variables to either string or integer. The macro still worked the first time and not thereafter. I tried the Watch very interesting. I didn't see any difference in the variables...
  5. rceddy

    Code to format Word Pictures works 1st run but won't on subsequent run

    The SendVar is advanced near the end of the second marco with SendVar = SendVar + 1 so each time a picture is pasted the counter is advanced.
  6. rceddy

    Code to format Word Pictures works 1st run but won't on subsequent run

    I have code in Excel 2003 to paste Excel ranges into Word as pictures. I want to paste the picture into the Word document and resize to a nice printing size then add the next one after a section break and so on. There are several different macros that have the same paste and format into Word so...
  7. rceddy

    Need to turn off automatic spellcheck when sending email from Excel

    I have a macro in Excel that picks up information and sends an email with that information in the body of the message. The creation of the email and send parts are working. I found the following line of code to get around the security message: SendKeys "%{s}", True The problem is that some of...
  8. rceddy

    Override Start Up Macro when Opening a File from Excel Code

    I have an Excel 97 file that extracts information from numerous (70 -100) other Excel files. The problem is that our current files have start up code to set the toolbars and close code to paste special some billing information so that it is a hard coded number. I do not need to do these...

Part and Inventory Search

Back
Top