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.

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.

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

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