http://wikisend.com/download/779280/Orl Mechanics Work.xlsm
Orl Mechanics Work.xlsm
the macro is called saveandstartover
the file that saves as the RO file is empty the name is XXXXX XXXXX any info that I put in it does not stay with it
the poreq puts the same info on the roreq then they get split up, if you fill in the vendor, date, equip # XXXXX equip mileage on the poreqform it should be placed on the ro form
http://wikisend.com/download/324662/Orl1 Mechanics Work.xlsm
Orl1 Mechanics Work.xlsm
as soon as you run the macro the last steps are to clear all these contents but if you go into the po file it created you can get the info back from there
If its a fix of using a different formula to input the cells on the vehicle repair order form instead of the if statement tell me how to word it or give me a example and I can type it all in " the if statement was the only way I new to get the values I needed"
The PO side is still working good but the RO is only supposed to save that one sheet not the whole workbook, I have to email that file to corporate and they only want the one sheet
I tried running it again and when I hit the button on the bottom of the page it still does the same thing it saves the sheet only but all the info on it is missing
from what it looks like to me is when the page is created originally it is linked with the po req page but when they get split up and saved the link is broke and none of the values stay with the sheet so we need to figure out how to save those fields as text instead of results from a formula so no link is needed?
I'm guessing but does that sound close?
it still don't keep any of the info it saves it by the name correctly but like before it will not keep the info on the separately saved ro sheet
Sorry to be a pain I know this is a hard one I have been trying different thing for a week that's why I had to call on the pro's
It works except the new saved ro file is missing the logo in the top left corner and can we have only one sheet we don't need sheet 2 or 3 showing
Are you still there?
Sorry to hear that you were so close I thought you had it, well thanks for trying I really appreciate it
Hello again. It's Mike. I saw that your previous Expert left the conversation. I have the change here that will copy the logo. As far as the other worksheets to which you refer, I don't see any additional worksheets once the macro completes.
Here's the change:
' saves poreqform with the file name taken from cell k69 Sheets("POREQFORM").Select Sheets("POREQFORM").Copy thisfile = Range("k69").Value ActiveSheet.Shapes.Range(Array("Picture 4")).Select Selection.Copy ActiveWorkbook.SaveAs Filename:="D:\new sws folder\maintenance\poreq\" & thisfile ActiveWorkbook.Close
Sheets("Vehicle Repair Order").Select Set ws = ActiveSheet Set wb = Workbooks.Add ActiveSheet.Paste ws.Cells.Copy ActiveSheet.Cells.PasteSpecial Paste:=xlValues ActiveSheet.Cells.PasteSpecial Paste:=xlFormats
Its almost there
The logo needs to be over 3 cells to the right and 2 cells down also the file that is saved is to large it needs to be 1 page this one prints as 4
It wouldn't let me download the file I tried to open as a excel sheet and its asking for a id and password
while waiting I started over and was able to get it to do what I wanted but the macro is huge im sure I didn't do it the most efficient way and really would like to see the way you did it (This is how im learning).
I have 1 more question posted could you help with this one also its almost like the last one you did except for printing the file it needs to be saved in another location
I hope im not to much trouble I am a novice at this but learning more each day