Results 1 to 6 of 6

Thread: visual basic 6 and excel problem

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jul 2007
    Posts
    18

    visual basic 6 and excel problem

    Dear forum,

    I need some help with the visual basic 6. I made a small application and I face a strange for me problem. The programs it passes same data files into excel. After that it made several checks and if it finds problem note them by changing the row color. The problem I must deal with is that when I try to call the sorting function from excel I receive an error 1004, which means that the function it could not be called. Could someone inform me where the mistake it and how I could fix it, what I am doing wrong.
    I upload the code and a data file in order to understand the problem better.
    Thanks in advance for your time.
    Last edited by RobDog888; Apr 5th, 2008 at 03:31 PM. Reason: Removed zip attachment which contained a single exe

  2. #2
    Lively Member ashokkumard's Avatar
    Join Date
    Aug 2007
    Location
    India
    Posts
    119

    Re: visual basic 6 and excel problem

    Hi

    Could u please post your code, so that it will be helpful for us to identify the error.
    Thanks
    Ashok

    Nothing is permanent except changes!..

  3. #3
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: visual basic 6 and excel problem

    Your zip file contains an exe only.

    That is useless to us for two reasons.

    2. No one is going to download an exe file, regardless of who posts it. You can never be sure what it is going to do.

    1. How can we offer suggestions on fixing code we can't see. If you want assistance, please post the code you are using. At the very least, remove your current attachment and reattach a zip file with the source code in it.

  4. #4

    Thread Starter
    Junior Member
    Join Date
    Jul 2007
    Posts
    18

    Re: visual basic 6 and excel problem

    Oh i am sorry.
    I upload the source code.
    Attached Files Attached Files

  5. #5

  6. #6
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: visual basic 6 and excel problem

    Zip attachment in your first post removed because uploading executables is not allowed in efforts to protect our members.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

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



Click Here to Expand Forum to Full Width