+ Reply to Thread
Results 1 to 7 of 7

Data Portal Design Requires Advanced Coding

  1. #1
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile Data Portal Design Requires Advanced Coding

    This short snippet of code was designed to create a data portal between two open instances of Excel. The purpose of doing so is two fold:
    1) to transfer the data realtime
    2) to allow for two simultaneous executions of code

    The code below develops two errors when it gets to the COPY FROM....COPY TO code line:

    1) Microsoft is waiting for another application to complete an OLE action
    2) Copy method of class failed

    Any ideas on why I am getting these errors would be appreciated. My main purpose is to be able to make data available, in one session of excel, to another session so that only the newest data is carried over and appended to the database.

    Please Login or Register  to view this content.
    Last edited by SDruley; 09-18-2011 at 12:25 PM.
    Turn Data into Information
    Turn Information into Knowledge
    Turn Knowledge into Direction
    Turn Direction into Leadership
    Turn Leadership into Results
    Stephen Druley

    It's not how quickly you think
    But how deeply you think
    The quality of thinking is measured
    by remoteness to conformance
    Stephen Druley

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,517

    Re: Data Portal Design Requires Advanced Coding

    No idea really but just a guess ... as you're trying to open an.xlsm file, I would expect you to get a message about enabling macros. Perhaps you could digitally sign the workbook so that it doesn't ask that question.

    Just a thought

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Data Portal Design Requires Advanced Coding

    I fear your thread title doesn't match the forum rules' requirements...

    Secondly I fear you overcomplicate things using 2 instances of Excel.
    As I indicated before, it's much simpler to have a hidden sheet, containing a Querytable, which results are being copied to another sheet every time the querytable has been refreshed (earlier I posted the class code to do so).



  4. #4
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Smile Re: Data Portal Design Requires Advanced Coding

    TMShucks,

    Thank you for your idea. I will look into the digital signature to see if this has an effect.

    snb,

    As always, great input. Please check your email.

  5. #5
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Re: Data Portal Design Requires Advanced Coding

    This coding challenge has been solved. The new code is as follows:

    HTML Code: 

  6. #6
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,015

    Re: Data Portal Design Requires Advanced Coding

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Read this to understand why we ask you to do this.

    You are not exactly new to this forum, so please make sure you abide by its rules in future.

    Thanks.
    Everyone who confuses correlation and causation ends up dead.

  7. #7
    Valued Forum Contributor SDruley's Avatar
    Join Date
    04-27-2009
    Location
    Conover, NC
    MS-Off Ver
    Excel 2010 64 bit
    Posts
    415

    Re: Data Portal Design Requires Advanced Coding

    Romperstomper,

    Thank you for your tactfully worded guidance.

    sdsruley

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1