Re: $$Excel-Macros$$ Keeping two blank cell & that is merged after the text "Expire Date:"

2014-08-23 Thread Vaibhav Joshi
Hi Check this... Cheers!! On Sun, Aug 24, 2014 at 8:12 AM, Nur Hossain wrote: > Dear All , My previous attached file was wrong. here is the update file. > > > > On 8/23/14, Nur Hossain Dear all, I am having data like below in the cell A & B in the sheet input > cell A cell B > T

$$Excel-Macros$$ Keeping two blank cell & that is merged after the text "Expire Date:"

2014-08-23 Thread Nur Hossain
Dear All , My previous attached file was wrong. here is the update file. On 8/23/14, Nur Hossain https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wi

$$Excel-Macros$$ Create macro to save macro template as macro enabled workbook using cell value as file name

2014-08-23 Thread rjagain62
*Create macro to save macro template as macro enabled workbook using cell value as file name* This is what I'm trying to do. Save the Macro Template on a network drive as a Macro Excel file using a cell value as the file name. I got this working but now when I try to open the file it saved the

$$Excel-Macros$$ Keeping two blank cell & that is merged after the text "Expire Date:"

2014-08-23 Thread Nur Hossain
Dear all, I am having data like below in the cell A & B in the sheet input cell A cell B Tra Code:RNSPIN News:what ever it is PDate: 8/5/2013 Expire Date: 8/12/2013 Tra Code:BD NEW News:what ever it is PDate: 8/5/2013 Expire Date: 8/12/2013 Tra Code:CS N

Re: Fwd: $$Excel-Macros$$ Doubt MBA

2014-08-23 Thread Marcio Bandeira
Tks in advance for the help. Yes, I´m using Outlook and the extension of the file is PDF. I appreciate your help. Marcio. 2014-08-22 8:24 GMT-03:00 Paul Schreiner : > what email program are you using? (Outlook?) > Is "File_Name" and "File_Name2" the full names? or is there also a file > extens

Re: $$Excel-Macros$$ Help required for changing the file name in a query programmatically

2014-08-23 Thread Ricardo®
Hi, See this example extracts the data from your file T2308.xls (T & date: and change the name according to the current(or system date)), using ADO and SQL statement. regards. Basole 2014-08-23 8:55 GMT-03:00 Eugene Bernard : > Dear all, > > I am daily using the attached sample query file t

$$Excel-Macros$$ Help required for changing the file name in a query programmatically

2014-08-23 Thread Eugene Bernard
Dear all, I am daily using the attached sample query file to extract data from an excel file stored in my windows desktop. I am pasting below a part of code from the test.dqy file, where I am daily changing the file name based on the date on which it is being run. Instead of changing it manually