Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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) |