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 derfloh 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. tlogan

    Help adding pictures in Word using VBA

    fumei - Thanks for the point in the right direction. I guess I just needed a little push. The following seems to be working. Now I just need to play around until I come with correct values for the exact placement I want. But this semes to be what I'm after. Thanks! Tom...
  2. tlogan

    Help adding pictures in Word using VBA

    The code above (in my last post) IS as far as I can go. While recording I cannot double click to continue the format process as described earlier in the thread. I want to Insert a picture, place it, size it over a range of cells, watermark it. so far I've got this, which inserts the picture...
  3. tlogan

    Help adding pictures in Word using VBA

    By the way ... The macro I recorded to insert the picture sets it as an InlineShape. Selection.InlineShapes.AddPicture FileName:= _ "C:\Documents and Settings\tlogan4\My Documents\racingstripes_releaseposter.jpg" _ , LinkToFile:=False, SaveWithDocument:=True Tom
  4. tlogan

    Help adding pictures in Word using VBA

    OK... I just tried recording.... I am able to insert the picture, but while recordding I cannot double click it to continue the rest of the process and editing. I'll try some of the other suggetions. Tom
  5. tlogan

    Help adding pictures in Word using VBA

    Thanks TTKP - No, not yet. My past experience is that that generates a LOT of extraneous code. I thought that perhaps there is more elegant and simple way to code it. That is really my last resort. Any one else? Tom
  6. tlogan

    Help adding pictures in Word using VBA

    Hello All - I've searched around and haven't found what I'm looking for. I'm working on a project to create an input form for a rather complicated Word template containing many table cells. One of things I'd like to be able to do is to add a picture as a watermark over a group of cells. I can...
  7. tlogan

    COBOL "real estate"

    3gm - GREAT! I think you illustrate my point, though. As long as you stick to the "standards" and don't ask the language to do things it wasn't meant to do (ie, extensions and enhancments), you save yourself a LOT of headaches. Regards, TLogan The Man Without an Interesting Moniker
  8. tlogan

    COBOL "real estate"

    WMK - point A - is true enough. However, I'd be interested to hear from ANYONE who has been able to write code of any language and port it across systems like this without ANY changes WHATSOEVER. That's what "they" said about SQL, too. Except for the most basic of retrievals, I've yet to write...
  9. tlogan

    COBOL "real estate"

    So What? I don't get it. What's the big deal? Maybe I'm getting old, but I just don't get the problem here. You learn the language the way it you need to learn it. When you're in an IBM shop, using IBM software, you learn to do it the IBM way. When you're in an HP shop using HP software you...
  10. tlogan

    help with fixing output, low-values maybe?

    If you're using OS/390 are you using ISPF as your editor? If ISPF, ANY file opened in "EDIT" (menu item 2) can be viewed in HEX by typing "HEX" on the command line. "HEX OFF" resets it. Hope this simplifies things. Make friends with your edtor! TLogan The Man with a Snappy Moniker
  11. tlogan

    Neverending exec process

    ...sfName & " 99.99.99.99") Do while X.Status = 0 WScript.sleep 250 Loop scriptfile.Delete True set scriptfile = nothing set oFSo = nothing *** Look for FTP Errrors While Not X.StdOut.AtEndOfStream sLine = Trim(X.StdOut.ReadLine) IF LEft(sLine,10) = "Cmd Failed" or Left(sLine,12)...
  12. tlogan

    SaveAs in Excel Macro not working from VBS script

    PHV - Sorry, it didn't seem to make a difference. What DOES seem to fix it, though, is that I specified the entire path in the "SaveAs". It just seems wierd that I would need to do that because the FIRST line of the macro is ChDir to the proper path and it works if you click on it. Thanks for...
  13. tlogan

    SaveAs in Excel Macro not working from VBS script

    Hello All - Has anyone ever seen anything like this before? I haven't seen anything like it in previous posts. I have an Excel spreadsheet with a macro that runs automatically (and invisibly) that at the end saves itself and then saves itself under a new name. Here is the problem.... If the...
  14. tlogan

    Need help setting file attribute to HIDDEN

    PHV - Thanks for the help. That works, too. I guess it's a matter of preference. I think I'll use your way, because it reads easier in the code. Once the file is created as "scriptfile" all other references to that object are as "scripfile.something" so it is quite clear what is being deleted...
  15. tlogan

    Need help setting file attribute to HIDDEN

    Thanks again tsuji! This works GREAT! I think because of the earlier problem (that you helped me fix) it was the only way I could get it work. This is MUCH cleaner way to do it. Thanks again! You get my vote! TLogan
  16. tlogan

    Need help setting file attribute to HIDDEN

    Thanks tsuji! That did the trick. The file is created hidden. BUT, now the delete doesn't work. Any ideas why that would change? Tlogan
  17. tlogan

    Need help setting file attribute to HIDDEN

    Thanks PHV - Still no go. I thought I had tried that in the first place, but when it didn't work went to the "set" syntax. But, I tried it again and still nothing. I notice also that when I try to set the scriptFile.Attribute in ANY way and run the script, the script does not appear to...
  18. tlogan

    Need help setting file attribute to HIDDEN

    ...in my code. For obvious reasons I have to mask them here. Also, the USER ID and Password are entered into an HTML form earlier in the script. '****************************************************** ' create a hidden text file to use in the FTP procedure Dim oFSo, scriptFile Set oFSo =...
  19. tlogan

    Start Excel minimized?

    ...because I AM AN IDIOT. That WORKS. Not only that, but by using the /WAIT switch I don't have to loop through PULIST to determine if an Excel process is running. This simplies the BAT file greatly. Thanks a gazillion, PH! You get my vote! Actually, everything I know about BAT files I...
  20. tlogan

    Start Excel minimized?

    Thanks PH, but /e doesn't work either. And BTW, DrBowes suggestion doesn't solve the flashing open problem either. Thanks to you, too! It still flashes open and then minimizes. Right now, the spreadsheets are opened manually, one at a time...double-click on XLS file, then run macro. I've...

Part and Inventory Search

Back
Top