![]() I envisage a csvĮ23455D, again Nigel especially for the informative way you posted your response.FileHorse also offers a hand-picked list of software for you to download. “JUL”? The only way I could see to do this is with buttons but a dialog box with 12 buttons seems a little crazy.Ĭan you point me in the right direction to creating a script that would attach all files containing the id code eg E23455D to the corresponding email address. Is there a way to query the user for the month and store in a variable for use in the folder name ending in the month e.g. The only other way I could see to do it was to search for the string “monthly_2010” and change the name of that file. The temp is just a folder that holds that one file long enough for the script to change its name and then put it where I want it top go. Hence the 3 sec delay while it creates the pdf. VipRiser creates a pdf with an indeterminate numerical prefix of the filename. Set current printer to printer "VipRiser" Set Current_Printer to name of current printer -> set a variable for the name of your current/default printer My early version had this code which would have helped in your understanding the process. Why does the first Excel Tell not require an End Tell? Thanks for the rewrite it’s much clearer. I did in fact put the Tells sequentially inside the Repeat loop but got a compile error and assumed that was the cause. If that’s the entire script and you’re doing exactly as you describe, it should work every time. If I delete the folder and then “New Folder” name it “From1” the script will work once and then when I relocate the file back in the folder it no longer works. Hopefully there are some files left behind to be renamed in the following iterations of the repeat. It takes some file which the Finder happens to think of as the first one in the Folder, renames it with a “.pdf” extension, and then moves all such files out of the folder. The action in the Finder tell block is a little disturbing to read, but I don’t know what situation it’s addressing. You have to use it with some of the path to destinations, but not with the desktop. (Incidentally, where you have in your problem script (path to desktop folder as text), the word ‘folder’ is superfluous. It also has one for the desktop, so if you’re going to be using tthe Finder, you could use the Finder terms instead of the path to command. Note (if it helps) that the Finder has its own home keyword. Move (every file of theFolder whose name ends with ".pdf") to targetFolder Set name of first file of theFolder to NewFileName & ".pdf" Set targetFolder to folder "Monthly Reports:Reports :AUG:" of home Set theFolder to folder "Monthly Reports:Reports :Temp:" of home Set NewFileName to value of cell "T9" of sheet "Report" of document 1 Set value of cell "T2" of sheet "Report" of document 1 to i open "Macintosh HD:Rob:Documents:Monthly_2010.xlsb" Tell application "Microsoft Excel" to open "Macintosh HD:Rob:Documents:Monthly_2010.xlsb" Here’s the code of come up with and it’s working quite well including the part where I rename it and transfer it from the “Temp” folder. I’m storing them in Folder “Jul”, “Aug” etc. I intend to email them and each report has it’s own code + yymm +“.pdf” as the filename. There are 30 franchises that I need to send out reports to from Excel. ![]() I wasn’t able to solve the problem and I think the key is in the error message that was breaking down the path into single characters.Īnyhow this problem was only one step in the process.Īlthough I’d like to know the reason for the error - so I can understand it - I have moved on to the rest of the project. I just got back but due to our time differences I was able to work on this a lot this morning. The first → (under move every item in the results) changes depending on what it is going to copy, in this instance it was a file, in another if it was a folder it would say → document file “Untitled.scptd” of folder “Scripts2” of folder “Desktop” of folder “JBird” of folder “Users” of startup diskĭocument file “Untitled.scptd” of folder “Scripts2” of folder “Desktop” of folder “JBird” of folder “Users” of startup disk of application “Finder” Move every item of folder “Splat Attack:Users:JBird:Desktop:Scripts” to folder “Splat Attack:Users:JBird:Desktop:Scripts2” I’ve tried various thin like trying to copy an running application in a folder, trying to coy over at same time, tying with different file types, i cannot replicate what you are getting ![]() This current applicaition is confusing me though. I’ve compared my results of a “working” result against your screen shot and the code is working perfectly. ![]() In From Just Add a Text File Called Hello.txt Ok, Can you do me a favour, just to check somethingĬan you change scripts to From - Create a Folder on Desktop called FromĬan you change scripts2 to Too - as above Create a Folder called Too ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |