+ Reply to Thread
Page 8 of 9 FirstFirst ... 6 7 8 9 LastLast
Results 106 to 120 of 128

auto save to a file via macro or program?

  1. #106
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    in cell b69 and b70

    i plan to have 2 destinations

    b69 will be \\server\job_file
    b70 will be \\server\Master Documents

    if there is a j number ( ie j1234 ) in cell g23 then it will need to be stored in the destination in b69 as per the glass order you did for me

    and it should read something like

    \\server\job_file\cell g23\-\cell I23

    and like it to be saved as

    cell b16,purchase order,cell k12

  2. #107
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    if cell g23 contains stock

    then it will need to go to destination b70

  3. #108
    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,930
    Steve

    I'm attaching your template with the macro within it - also shown below.

    Please Login or Register  to view this content.
    Rgds
    Attached Files Attached Files

  4. #109
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hi richard

    sorry for the delay
    am at home now
    and ive reattached a sheet for you to see that will be the same but one i can use at home

    http://www.savefile.com/files/1535584

  5. #110
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    so, as you can see i have changed the destinations

    i want to use the click here to save button but i need to assign it a macro to do so

    ok so lets talk through the sheet

    this sheet is a purchase order sheet

    if cell g23 has a j reference followed by 4 numbers ( there will be no letters after the numbers ) ( ie j4567 ) then it needs to go to destination in cell b69

    C:\Documents and Settings\name\Desktop\job folder

    it will then go the appropriate folder

    C:\Documents and Settings\name\Desktop\job folder\j4567

    it will then add the hyphen and cell I23

    C:\Documents and Settings\name\Desktop\job folder\j4567 - smith

    it will then add the docs

    C:\Documents and Settings\name\Desktop\job folder\j4567 - smith\docs

    and hopefully it will save itself as

    cell b16 purchase order cell k12.xls

  6. #111
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    if cell g23 has a reference that says stock then it needs to go to destination in cell b70

    C:\Documents and Settings\name\Desktop\master documents

    it will then go the appropriate folder

    C:\Documents and Settings\name\Desktop\master documents\stock purchase orders

    and hopefully it will save itself as

    cell b16 purchase order cell k12.xls
    Last edited by stevesunfold; 05-02-2008 at 03:06 PM.

  7. #112
    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,930
    Steve,

    A small addition to the attached file. The previous only tested for an upper case 'J' at the start of the Job number. I've changed it so that it will recognise both an upper and lower case 'j' as per the example workbook.

    Rgds
    Attached Files Attached Files

  8. #113
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    im getting 400 error richard

  9. #114
    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,930
    Quote Originally Posted by stevesunfold
    im getting 400 error richard
    On which line?

    The paths and names that the code generates from the template you supplied is as below. The first one is the job, and the other for the Purchase Order

    Can you confirm that all the folders before the final bit which contains the .xls filename actually exist?

    If not play around with cells G23, I23, B69, B70, B16 and K12, which contain all the relevant text values.

    What's that reference to 'name' in B69 & B70? Is this really a folder? If not change it as appropriate. The code will work provided the folders etc. exist.

    Please Login or Register  to view this content.
    Rgds

  10. #115
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    basically name is my name and yes its a folder

    there are 2 destinations

    one for if cell g23 is a j number

    and the other destination is for if cell g23 fsays stock

    if its a j number it needs to be saved in the relevant job folder followed by space hyphen space then the customer name in cell I23

    if its stock it should go in the second destination

    the should all be saved as purchase order ( glass error report as youve got at mo )

  11. #116
    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,930
    [QUOTE=stevesunfold]basically name is my name and yes its a folder

    there are 2 destinations
    ...

    Steve,

    When you refer to 'name' and say it's my name, do you mean you've got a folder called 'Steve' or is there in fact a folder called 'name'?

    If the former you'll need to change cell B69 & B70 accordingly so that they contain the characters 'Steve'

    Have you examined the paths/folders in my last post and confirmed you really do have them on your system?

    Rgds

  12. #117
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    hi richard

    yes does as you requested but am confused as to why Glass Reject Order And Error Report Form j4567.xls is part of the code

    as its a purchase order form and not glass reject order and error report form

  13. #118
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    would you be kind enough to put the whole code here please

    amybe i can change the glass part??

  14. #119
    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,930
    Quote Originally Posted by stevesunfold
    hi richard

    yes does as you requested but am confused as to why Glass Reject Order And Error Report Form j4567.xls is part of the code

    as its a purchase order form and not glass reject order and error report form
    Only because that's what was in the original specification.
    Those words are hard coded in the macro. If you don't want them, just remove them, and the 'Range("G23") which is the job number, just leaving the ".xls" bit.

    Rgds

  15. #120
    Forum Contributor
    Join Date
    06-23-2007
    Posts
    690
    would you mind posting th code please mate
    cos i cant seem to see it
    i have tried the right click view code but cant see anything


    thanks mate

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

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