VB6.0 : Collect Data from many Excel file

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • wassup
    New Member
    • May 2007
    • 34
    #1

    VB6.0 : Collect Data from many Excel file

    Hi all,

    Big Problem. Now I have a folder contain a few of Excel file. What I want is when I click a button it will prompt out an Open dialog, and I will select the folder I want and click OK, then the program will auto open all Excel file inside folder. After that it will collect the data inside all of the Excel file include Graph and Picture and paste inside Access database. Please teach me step by step if anyone know, I am very appreciate to all of your help.

    *If anyone have this kind example can forward to my email.
    [Removed by Moderator]
    Last edited by Killer42; May 15 '07, 03:20 AM. Reason: Removed e-mail address
    Tags: None
    • Dököll
      Recognized Expert Top Contributor
      • Nov 2006
      • 2379
      #2
      Originally posted by wassup
      Hi all,

      Big Problem. Now I have a folder contain a few of Excel file. What I want is when I click a button it will prompt out an Open dialog, and I will select the folder I want and click OK, then the program will auto open all Excel file inside folder. After that it will collect the data inside all of the Excel file include Graph and Picture and paste inside Access database. Please teach me step by step if anyone know, I am very appreciate to all of your help.

      *If anyone have this kind example can forward to my email.
      BWare
      WhatZup, wassup!

      Fetched a bit for this one. This loops through files, you can plug in a message box yourself:

      http://msdn2.microsoft.com/en-us/library/ms403358.aspx

      Good luck with project!

      Oh, just noticed your email. Word on the street is "they'll come a knockin' and spamin'" Might want to leave that out next time:-)

        Comment

        • Killer42
          Recognized Expert Expert
          • Oct 2006
          • 8429
          #3
          Originally posted by Dököll
          Oh, just noticed your email. Word on the street is "they'll come a knockin' and spamin'" Might want to leave that out next time:-)
          True.

          Spammers and scammers tend to scan groups like this to pick up e-mail addresses. If you want members to e-mail you, turn on the option in your TSDN Control Panel which allows them to do it through there.

            Comment

            • danp129
              Recognized Expert Contributor
              • Jul 2006
              • 323
              #4
              But if you're like many of us and have the same username on forums as you do with your e-mail provider you're kinda screwed either way... I'm sure you weren't lucky enough to get 'wassup' at hotmail or yahoo though :) Would be nice to be able to set a Display Name or something.

                Comment

                • wassup
                  New Member
                  • May 2007
                  • 34
                  #5
                  Thanks all, I still newbie about this so don't know its will become a serious issue. Thanks very much.

                    Comment

                    • Killer42
                      Recognized Expert Expert
                      • Oct 2006
                      • 8429
                      #6
                      Originally posted by danp129
                      But if you're like many of us and have the same username on forums as you do with your e-mail provider you're kinda screwed either way...
                      Why is that?

                        Comment

                        Previous template Next
                        Working...