Search results for query: *

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

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

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

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

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

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

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

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

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

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

Hi! - I hope skiflyer and tsuji are stil monitoring this thread, but I would appreciate insights from anyone else interested in this problem... I have the same problem, but I am NOT using cmd. I have virtually identical scripts running an FTP session. One has a large amount of output the other...

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

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

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

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

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

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

Hello All! I've gotten some great help here and I hope someone can come through for me (again!). I'm trying to create a text file and set it to HIDDEN (Attributes =2). I've found several references on how to do it, but none of them seem to work. Here is my code. It works perfectly if I DON'T...

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

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