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.

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." <[email protected]> wrote in message
news:[email protected]...
> 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.
>

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

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
>