At A7 sheet Homepage, select Office. GET FILE button to select the file and
get into
2014-08-30 22:10 GMT+07:00 Eugene Bernard :
> Mr Basole,
>
> Thanks for the attachements,
>
> I am getting an error msg as in the attachment, even after adding Ms-ado
> object library.
>
> [image: Inline image
Was precisely the error: problem with the file name. * xls.
To work well, every day change the name, for example: 31/08/2014 and rename
to (T3108.xls).
Then do the test with your file. If you have any problems, please send me
an example of your file (Tddmm.xls).
Regards,
Basole.
2014-08-30 12:
Dear Basole,
Please ignore my earlier mail,
I removed the slash in between dd/mm from the below statement from your
example
fileXLS = "T" & Replace(Format(Date, "dd/mm"), "/", "") & ".xls" like
below,
fileXLS = "T" & Replace(Format(Date, "ddmm"), "/", "") & ".xls" and example
sent by you
star
Mr Basole,
Thanks for the attachements,
I am getting an error msg as in the attachment, even after adding Ms-ado
object library.
[image: Inline image 1]
TIA.
Eugene
On Fri, Aug 29, 2014 at 11:06 PM, Ricardo® wrote:
> Ok, is attached files.
> To test, hold the 2 files in the same folder
>
Ok, is attached files.
To test, hold the 2 files in the same folder
Regards,
Basole.
2014-08-29 11:58 GMT-03:00 Eugene Bernard :
> Basole,
>
> Thanks for your solution.
>
> Can you please send me the working example along with excel file with
> sample data.
>
> I tried your code with my data,
Basole,
Thanks for your solution.
Can you please send me the working example along with excel file with
sample data.
I tried your code with my data, and i am getting an error message.
Regards
Eugene
On Saturday, August 23, 2014 7:04:59 PM UTC+5:30, Basole wrote:
>
> Hi,
>
> See this example
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
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
