+ Reply to Thread
Results 1 to 4 of 4

Extracting certain data from macro file

  1. #1
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Extracting certain data from macro file

    Hi All,

    I have attached one macro file in which my users are adding some data related to our work.

    I want another macro file which will automatically extract all the data's in which there is query raised. (Cases where query type is filled). If the macro will give me option from which date to what date I want the data that would be awesome...

    The file I have attached has very less data but after a week it gets heavier. Please can anyone help me out with this ?? Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Extracting certain data from macro file

    The script is password protected.


    e/ Where would you like the data extracted to? The query sheet?
    Last edited by Solus Rankin; 08-07-2013 at 08:35 AM.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  3. #3
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Extracting certain data from macro file

    Hi,

    Firstly thanks for your reply.

    Password is 1989.

    I want the data in a new macro file. I mean as soon as I run the macro file, I should get the data.

    The thing is I have different macro files like i attached. So if the macro will give me an option to select the macro from which I can extract, it will be superb...

  4. #4
    Forum Contributor
    Join Date
    04-01-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Extracting certain data from macro file

    Hello..Any update on this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extracting data from one excel file to another
    By kclalwani in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 06-07-2013, 12:43 AM
  2. [SOLVED] Macro for extracting data into a master excel file.
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 05-10-2013, 06:07 PM
  3. Replies: 0
    Last Post: 06-15-2011, 02:22 PM
  4. Extracting Data from a .txt file
    By baby_rach in forum Access Programming / VBA / Macros
    Replies: 4
    Last Post: 06-15-2010, 10:09 AM
  5. Replies: 18
    Last Post: 10-24-2005, 05:05 PM

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