I know it must be on this forum somewhere but I've serached and can't find it. I would like to be able to open a template and save the contents of cell B19 as the file name.
Can I do this so i don't have to press a button to run the macro. I have only done one macro previously and that was with the help of people on this forum so please don't get to technical.
If possible I would like to be able to save it on the server X:\reports\offender PDF's
Apparently this is supposed to work
Please Login or Register to view this content.
Unfortunately I get this error message
Please Login or Register to view this content.
Last edited by Anonbrumbie; 10-07-2009 at 06:22 AM.
The OzGrid website has started inexplicably adding an extra blank line between every line of text. That's usually not a problem until you get those multi-line pieces of code...which is broken completely by the extra lines. You have to take all of those lines out.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Many thanks
Do you know what I add to get it to run automatically
Last edited by Anonbrumbie; 10-07-2009 at 11:14 AM.
Please explain.
I want to be able to have the macro run without having to hit a short cut key or Alt F8. Ideally I would also like it to save straight to a folder on the server.
I can only just get my head around basic formulas so macros might as well be another language
When exactly should this macro run itself? What in your mind would be the triggering moment that causes the sheet to selfsave/selfname?
I must be missing something here.
What I want is to enter the data in the cell and then when I click on save as I want the macro to run. Currently I have to click on "run" or a short cut key to make it happen.
Edit
The penny has finally dropped. I didn't realise "run" incorprated save as. I thought it preceeded save as.
Last edited by Anonbrumbie; 10-07-2009 at 01:36 PM.
There is a workbook-event macro called Worbook_BeforeSave. If you create this event in the ThisWorkbook module, it intercepts the SAVE command and runs its code prior to a normal save. This macro will run its own code and then abort the normal save, so it always tries to save the sheet with the name in B19.
Please Login or Register to view this content.
Last edited by JBeaucaire; 10-07-2009 at 01:59 PM.
thanks for your help. It works. I just wish I knew how
Read through the macro line by line. Most VBA isn't that complicated to decipher when you know exactly what it is doing and just don't know how. As you read the code and find a line confuses you, Google that one term:
Excel VBA MsgBox
Excel VBA SaveAs
...and so some quick research on that term. Be sure to NOT Google terms that were declared as variables in the macro since they are user defined. (like strName in you macro).
If you find you really can't decipher, ask again here about the specific line of code that remains a mystery.
=============
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks