+ Reply to Thread
Results 1 to 3 of 3

(Automation Error) How to retrive data between from date to system date using excel VBA

  1. 11-22-2015, 02:38 AM #1
    Kalpesh93
    Kalpesh93 is offline
    Registered User
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    MS-OFFICE 2010
    Posts
    15

    (Automation Error) How to retrive data between from date to system date using excel VBA

    Good Afternoon Experts,

    I am trying to extract a data in an excel through different excel using ADODB.Connection but when I am trying to retrive data between from date to system date I am getting an automation error in excel.

    Have checked various article but unable to validate those condition because I don't have sql server so I am directly putting into excel coding but again same error I am getting.

    Please help......

    Please Login or Register  to view this content.
    Below is debug print from strsql
    Please Login or Register  to view this content.
    Last edited by Kalpesh93; 11-22-2015 at 06:51 AM.
    Reply With QuoteRegister To Reply
  2. 11-22-2015, 05:31 AM #2
    Kalpesh93
    Kalpesh93 is offline
    Registered User
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    MS-OFFICE 2010
    Posts
    15

    Re: How to retrive data between from date to system date using excel VBA

    Can anyone please help me?
    Reply With QuoteRegister To Reply
  3. 11-22-2015, 06:50 AM #3
    Kalpesh93
    Kalpesh93 is offline
    Registered User
    Join Date
    12-03-2014
    Location
    India
    MS-Off Ver
    MS-OFFICE 2010
    Posts
    15

    Re: How to retrive data between from date to system date using excel VBA

    Finally found out the error cause...

    Actually the error was because of the quotes 
    Please Login or Register  to view this content.
    which I was using in coding but the same was replacing after with 
    Please Login or Register  to view this content.
    . It worked.
    Thanks all
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to retrive date
    By rizmomin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-17-2015, 09:44 AM
  2. [SOLVED] VBA Macro to Color Row Text If Date in Cell is greater than system date
    By slick9456 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-24-2014, 06:09 PM
  3. [SOLVED] Counting the days positive or negative between a date (inserted value) to the system date
    By dafonso in forum Excel General
    Replies: 5
    Last Post: 10-02-2013, 09:49 AM
  4. Date independent of System date in column of Excel
    By gaursh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2011, 06:30 AM
  5. using Calendar form to store a date changes my system date/time
    By mslynng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2009, 02:08 PM
  6. Excel 2007 : Changing row colour if column D date is before current system date
    By trevor432990 in forum Excel General
    Replies: 8
    Last Post: 08-22-2009, 10:03 AM
  7. Negative date values without changing the Date System
    By softuser in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2007, 06:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1