+ Reply to Thread
Results 1 to 11 of 11

What is best idea to keep all my data in the macro module ?

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    What is best idea to keep all my data in the macro module ?

    Is it good idea to keep my all data in the Array macro module . it is required for Excel Addins .Say for example. I am having almost 5000 data in the sheet 2 range (A1:B5000). & in sheet1 having just simple Vlookup formula to get the data from sheet 2. But I want that ,I will keep all data of sheet 2 range (A1:B5000) in the macro module by Array macro.& after that I will take out all desire data by vlookup. Below array macro running good , but it has limitation , it can’t store lost of data
    Please Login or Register  to view this content.
    what is best idea to keep all my data in the macro module ,I can hide sheet2 (which having actual data) but I want to know is it possible to keep all my data inside the macro module ? Without helping array macro as it has limitation. I have seen some VBA software & its having self hidden database (not cascade with access database)

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: What is best idea to keep all my data in the macro module ?

    it is never a good idea to hardcode data into your code. you can use a sheet within an add-in to store it easily or use an external data file-whether it be text file, database or other
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: What is best idea to keep all my data in the macro module ?

    you can use a sheet within an add-in to store it easily or use an external data file-whether it be text file, database or other
    Hi, JosephP
    Thanks for reply , I will happy it you provide me the solution step by step . as I am very much keen interested to learn all possible way to keep huge data inside the excel add-in.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: What is best idea to keep all my data in the macro module ?

    you can save the add-in as a regular workbook, add the data to one of its sheets then save it as an add-in again

  5. #5
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: What is best idea to keep all my data in the macro module ?

    Hi, JosephP
    Thanks for reply, i have attached my workbook, if possible then make it as Add-in.
    Attached Files Attached Files

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: What is best idea to keep all my data in the macro module ?

    just use File-SaveAs and change the type to an add-in

  7. #7
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: What is best idea to keep all my data in the macro module ?

    Hi, JosephP,
    Add-in prepared & selected it from Add-in list successfully ,but when I try open add-in I didn’t get my two sheet “rlcrp” & sheet “tx” the converted add-in work book I can’t upload in this forum. When I try to upload my add-in. Iit didn’t find any add-in that folder except other file. but the actual add-in is there !!! my be www.excel forum.com not supported .xlam format. However check the attachment to see the snaps
    Attached Files Attached Files

  8. #8
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: What is best idea to keep all my data in the macro module ?

    you cannot see the sheets in an add-in because the workbook is hidden. your code can still read the data

  9. #9
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: What is best idea to keep all my data in the macro module ?

    You know that I was two sheet “rlcrp” & “tx”, if workbook is hidden , then where I will past my input data , & where I will get the output data (that is vlookup by sheet “TX” ).

  10. #10
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: What is best idea to keep all my data in the macro module ?

    you put the data in the add-in before you save it as an add-in. if the data will change then do not store it in the add-in, use a separate file

  11. #11
    Forum Contributor
    Join Date
    06-08-2012
    Location
    BD
    MS-Off Ver
    Microsoft Office 2016
    Posts
    633

    Re: What is best idea to keep all my data in the macro module ?

    Hi, JosephP,
    all possible way I did with the help of internet previously but I failed. however don’t waste your valuable time regarding the same issue . I am going to close this issue as my ambition to make add-in will not come in to true. I am very much disappointed that I can’t make understand other easy way. If there is no way I should go back the old traditional way where there are two sheets “rlcrp” &“tx” vlookup as well. If you notice that my Attached macro workbook is working fine for me & I am using it on regular basis to make my job smoothly . however I am extremely sorry for killing your valuable time in the chain chat…

+ 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