. http://brutalpop.ic.cz/rhorse-3.html?utopicid=02jl1 __._,_.___ Reply to sender | Reply to group | Reply via web post | Start a New Topic Messages in this topic (1) Recent Activity: New Members 5 Visit Your Group ---------------------------------- Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA. ----------------------------------...
Sabtu, 31 Maret 2012
[ExcelVBA] Re: Rename Files in Folders to Include Folder Names
I know I could do this with DOS commands, but I'm trying to figure out a way to do everything with an Excel workbook. Data and new spreadsheets are being created every day. Ideally, once done and the data from a workbook is collected in the collector tool, I want my code to delete the workbook. --- In ExcelVBA@yahoogroups.com, Dr John C Bullas <john.bullas@...> wrote: > > I think DOS commands can grab folder names > > http://www.msfn.org/board/topic/56320-retrieve-current-directory-name-in-batch/ > > Any good? > > Dr B > > On 30 March 2012 23:29, sspatriots <sspatriots@...> wrote: > > Hi, > > > > I'm not certain on how this can be done,...
[ExcelVBA] Re: Rename Files in Folders to Include Folder Names
Sorry, the file names are automatically created every time the torque analyzer is run. The tool number and thread designation determine which folder the file will be dropped into. So, short answer is I would have to rename the files every time I use the collector workbook to bring in all the data from the individual workbook spreadsheets containing the data. --- In ExcelVBA@yahoogroups.com, "David Smart" <smartware.consulting@...> wrote: > > You haven't said whether the renaming is a one-off task or will need to be > done on a continuing basis. > > For editing of file names within directories, I use "Oscar's Renamer" which > give me an editor screen for working on all the...
[smf_addin] Digest Number 2162
EXCEL Stock Market Functions Add-in Messages In This Digest (2 Messages) 1a. Re: Call/Put Spreadsheet From: bobc94595 1b. Re: Call/Put Spreadsheet From: Randy Harmelink View All Topics | Create New Topic Messages 1a. Re: Call/Put Spreadsheet Posted by: "bobc94595" conlonrc@comcast.net bobc94595 Fri Mar 30, 2012 9:38 am (PDT)...
[belajar-excel] Digest Number 1569
Milis Belajar Microsoft Excel Messages In This Digest (12 Messages) 1a. Re: Macro - belajar deteksi nama sheets From: hendrik karnadi 1b. Re: Macro - belajar deteksi nama sheets From: cuma.milis@gmail.com 2a. Form Pdf data excel From: sarma diaz 2b. Re: Form Pdf data excel From: Rara Wilis 2c. Re: Form Pdf data excel From: Triyoso 2d. Re: Form Pdf data excel From: sarma diaz ...
Langganan:
Postingan (Atom)