LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron M.
 
Posts: n/a
Default 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
general macro question ynissel Excel Discussion (Misc queries) 17 February 24th 06 03:15 PM
Concatinate a filename CLR Excel Discussion (Misc queries) 28 August 1st 05 11:45 PM
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
Dave just one more question Jennifer Excel Discussion (Misc queries) 4 April 4th 05 09:08 PM
Attn: Dave P. Question re Pix Calls via Macro DocuMike Excel Discussion (Misc queries) 1 January 10th 05 01:38 AM


All times are GMT +1. The time now is 02:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"