+ Reply to Thread
Page 9 of 9 FirstFirst ... 7 8 9
Results 121 to 128 of 128

auto save to a file via macro or program?

  1. #121
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    25,684
    Quote Originally Posted by stevesunfold
    would you be kind enough to put the whole code here please

    amybe i can change the glass part??

    Hi Steve,

    The complete code was in one of my previous messages viz.

    http://www.excelforum.com/showpost.p...&postcount=108

    The last 'glass bit' as you call it is what you want the name of the file to be called. You can change the text in the code, but you'll need at least some descriptive text - the file has to have a name!

    If you don't want the job number included in the file name then delete the '& Range("G23")' bit as well.

    Rgds

  2. #122
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    the thing is it does absolutely everything perfectly when i input stock into cell g23 and saves the workbook as TESCO Purchase Order w0342 into the correct folder

    but when i try the j4567 reference it saves it as glass order ........

  3. #123
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    cant understand either why i cant see the code when i right click the tab and select view code

    why is this

  4. #124
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    HI RICHARD

    THIS IS THE CODE IVE GOT

    Please Login or Register  to view this content.
    IT ONLY SAVES IN THE JOB FOLDER IF THE J NUMBER IS A CAPITAL J AND I WAS HOPING IT WOULD BE UPPER AND LOWER CASE

    AND THE CODE IS TELING IT TO SAVE AS GLASS REJECT ORDER AND ERROR REPORT FORM WHERE AS I WANT IT TO SAVE AS IT DOES IF I WERE TO PUT STOCK

    IE
    IE CELL B16,PURCHASE ORDER,CELL K12

  5. #125
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hi guys

    anyone out there who can help me out of this hole please

    gratefully appreciated

  6. #126
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    25,684
    Quote Originally Posted by stevesunfold
    HI RICHARD

    THIS IS THE CODE IVE GOT

    Please Login or Register  to view this content.
    IT ONLY SAVES IN THE JOB FOLDER IF THE J NUMBER IS A CAPITAL J AND I WAS HOPING IT WOULD BE UPPER AND LOWER CASE

    AND THE CODE IS TELING IT TO SAVE AS GLASS REJECT ORDER AND ERROR REPORT FORM WHERE AS I WANT IT TO SAVE AS IT DOES IF I WERE TO PUT STOCK

    IE
    IE CELL B16,PURCHASE ORDER,CELL K12

    Hi Steve,

    Please see post 112 where you'll note I modified the code to allow for upper and lower case 'J'

    http://www.excelforum.com/showpost.p...&postcount=112

    The 'Glass Reject......' stuff was your original specification. If you want this to be the same as the name used by the Stock option, then just change the text to read "Purchase Order" - or anything you want.

    You might want to consider holding the names you wish to use for the two choices, in two more variable cells on the sheet, and then use those cell references in the macro just like the other cell variables.

    Rgds

  7. #127
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    i cant see how to get the code though richard from that post

  8. #128
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    richard richard richard

    thanks to you and your patience ive got it

    thanks so much mate ive been tinkering and managed to get there

    phew


    cant thank you enough for all your effort , cheers

    here is my final code and it works

    Please Login or Register  to view this content.

+ Reply to Thread
Page 9 of 9 FirstFirst ... 7 8 9

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1