Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bernie, Dave, Doug, et. al. - question for you
You guys have saved my neck with some wonderful help lately, and I fell
like I owe you one. You'll never pay for a drink when I'm around! Most recently, I asked about code that would let you click on a button to erase a file from one folder and save it to another one. Bernie replied with this: Sub SaveInApprovedFolder() Dim DeleteFile As String Application.DisplayAlerts = False DeleteFile = ActiveWorkbook.FullName ActiveWorkbook.SaveAs "Drive:\Approved file path\" & ActiveWorkbook.Name Kill DeleteFile Application.DisplayAlerts = True End Sub And of course it works perfectly. But I'm feeling kinda self-concious about running to this newsgroup EVERY time I need some Excel code. Is there a good book or someplace where I could learn this myself? I think the above code is Visual Basic, but I'm afraid if I just buy "a book on Visual Basic" and start reading it, I'll get bogged down in 1,000 pages of stuff that I'll never use in Excel. Is there a book or something that focuses specifically on this kind of Excel code? Thanks again to all you guys, Ron M. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bernie, Dave, Doug, et. al. - question for you
Don't worry about coming back. We do it for fun, and it matters not whether
you ask 1 or 100 questions. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Ron M." wrote in message oups.com... You guys have saved my neck with some wonderful help lately, and I fell like I owe you one. You'll never pay for a drink when I'm around! Most recently, I asked about code that would let you click on a button to erase a file from one folder and save it to another one. Bernie replied with this: Sub SaveInApprovedFolder() Dim DeleteFile As String Application.DisplayAlerts = False DeleteFile = ActiveWorkbook.FullName ActiveWorkbook.SaveAs "Drive:\Approved file path\" & ActiveWorkbook.Name Kill DeleteFile Application.DisplayAlerts = True End Sub And of course it works perfectly. But I'm feeling kinda self-concious about running to this newsgroup EVERY time I need some Excel code. Is there a good book or someplace where I could learn this myself? I think the above code is Visual Basic, but I'm afraid if I just buy "a book on Visual Basic" and start reading it, I'll get bogged down in 1,000 pages of stuff that I'll never use in Excel. Is there a book or something that focuses specifically on this kind of Excel code? Thanks again to all you guys, Ron M. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bernie, Dave, Doug, et. al. - question for you
Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html John Walkenbach's is a nice one to start with. Depending on how advanced you are... Professional Excel Development By Stephen Bullen, Rob Bovey, John Green See if you can find them in your local bookstore/internet site and you can choose what one you like best. ===== And don't forget you can search google before you give in to asking a question <vbg. http://groups.google.com/advanced_group_search "Ron M." wrote: You guys have saved my neck with some wonderful help lately, and I fell like I owe you one. You'll never pay for a drink when I'm around! Most recently, I asked about code that would let you click on a button to erase a file from one folder and save it to another one. Bernie replied with this: Sub SaveInApprovedFolder() Dim DeleteFile As String Application.DisplayAlerts = False DeleteFile = ActiveWorkbook.FullName ActiveWorkbook.SaveAs "Drive:\Approved file path\" & ActiveWorkbook.Name Kill DeleteFile Application.DisplayAlerts = True End Sub And of course it works perfectly. But I'm feeling kinda self-concious about running to this newsgroup EVERY time I need some Excel code. Is there a good book or someplace where I could learn this myself? I think the above code is Visual Basic, but I'm afraid if I just buy "a book on Visual Basic" and start reading it, I'll get bogged down in 1,000 pages of stuff that I'll never use in Excel. Is there a book or something that focuses specifically on this kind of Excel code? Thanks again to all you guys, Ron M. -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bernie, Dave, Doug, et. al. - question for you
I am no vba expert by any means but i find that the macro recording tool can
give you a lot of help.Start with that and then use a book or this group to generalise or modify your code accordingly. -- paul remove nospam for email addy! "Dave Peterson" wrote: Debra Dalgleish has a list of books at her site: http://www.contextures.com/xlbooks.html John Walkenbach's is a nice one to start with. Depending on how advanced you are... Professional Excel Development By Stephen Bullen, Rob Bovey, John Green See if you can find them in your local bookstore/internet site and you can choose what one you like best. ===== And don't forget you can search google before you give in to asking a question <vbg. http://groups.google.com/advanced_group_search "Ron M." wrote: You guys have saved my neck with some wonderful help lately, and I fell like I owe you one. You'll never pay for a drink when I'm around! Most recently, I asked about code that would let you click on a button to erase a file from one folder and save it to another one. Bernie replied with this: Sub SaveInApprovedFolder() Dim DeleteFile As String Application.DisplayAlerts = False DeleteFile = ActiveWorkbook.FullName ActiveWorkbook.SaveAs "Drive:\Approved file path\" & ActiveWorkbook.Name Kill DeleteFile Application.DisplayAlerts = True End Sub And of course it works perfectly. But I'm feeling kinda self-concious about running to this newsgroup EVERY time I need some Excel code. Is there a good book or someplace where I could learn this myself? I think the above code is Visual Basic, but I'm afraid if I just buy "a book on Visual Basic" and start reading it, I'll get bogged down in 1,000 pages of stuff that I'll never use in Excel. Is there a book or something that focuses specifically on this kind of Excel code? Thanks again to all you guys, Ron M. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
general macro question | Excel Discussion (Misc queries) | |||
Concatinate a filename | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Dave just one more question | Excel Discussion (Misc queries) | |||
Attn: Dave P. Question re Pix Calls via Macro | Excel Discussion (Misc queries) |