I meant this to be for word, sorry, can you still help me?
Hi All,
I am designing a "Non-Conformance report" from word. I'd like my team members to open this file, type the information in, automatically print after the last cell has been selected, then save automatically (as the next sequential number we actually type into the report) and saved in the folder where the reports are stored. eg. therefore, if we enter a number, say 1111, into the "report #" field I would like the file to be saved as NonCon1111.doc. Would anyone be able to help create this macro? (please keep in mind that my computer programming skills arn't as great as everyone else's in here! Thankyou everyone. Please reply to Kind regards Peter Finlay |
I meant this to be for word, sorry, can you still help me?
Peter,
Just checked in Word. It is ActiveDocument.SaveAs, Application.DisplaAlerts applies, so the rest should work. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Peter Finlay" wrote in message u... Hi All, I am designing a "Non-Conformance report" from word. I'd like my team members to open this file, type the information in, automatically print after the last cell has been selected, then save automatically (as the next sequential number we actually type into the report) and saved in the folder where the reports are stored. eg. therefore, if we enter a number, say 1111, into the "report #" field I would like the file to be saved as NonCon1111.doc. Would anyone be able to help create this macro? (please keep in mind that my computer programming skills arn't as great as everyone else's in here! Thankyou everyone. Please reply to Kind regards Peter Finlay |
All times are GMT +1. The time now is 06:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com