PERSONAL.XLSB

%3CLINGO-SUB%20id%3D%22lingo-sub-3073517%22%20slang%3D%22en-US%22%3EPERSONAL.XLSB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073517%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20macro%20enabled%20excel%20workbook%2C%20in%20it%20one%20sheet%20contains%20name%20%26amp%3B%20phone%20numbers%20of%20my%20suppliers.%20i%20have%20put%20this%20sheet%20as%20hidden%20%26amp%3B%20using%20a%20custom%20made%20form%20i%20am%20getting%20phone%20numbers%20of%20the%20required%20person.%20I%20have%20provided%3B%20add%2C%20edit%20%26amp%3B%20delete%20options%20too%20in%20the%20code.%20(this%20iam%20using%20as%20my%20phone%20book)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20i%20intend%20now%20is%20to%20get%20this%20phone%20book%20in%20any%20excel%20file%20which%20is%20open%20at%20that%20time.%20I%20have%20copied%20the%20code%20%26amp%3B%20the%20form%20to%20the%20PERSONAL.XLSB%20file.%20But%20i%20think%20the%20work%20sheet%20that%20contains%20the%20phone%20number%20details%20can%20not%20be%20manageable%20(that%20sheet%20i%20have%20copied%20to%20the%20xlsb%20file)%20in%20xlsb%20file.%20pls%20advice%20how%20it%20can%20be%20made%20workable%3F%20if%20no%20direct%20way%2C%20any%20tricky%20way%2Fcode%20available%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EHariprasadhari%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3073517%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3073831%22%20slang%3D%22en-US%22%3ERe%3A%20PERSONAL.XLSB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073831%22%20slang%3D%22en-US%22%3EDear%20Doug%20Robbins%2C%3CBR%20%2F%3E%3CBR%20%2F%3EMany%20thanks%20for%20your%20quick%20response.%3CBR%20%2F%3EBut%20still%20it%20is%20not%20working%2C%20see%20below%20my%20followed%20steps%3CBR%20%2F%3ESaved%20my%20macro-enabled%20workbook%20(.xlsm)%20to%20.xlam%20file%20as%20you%20suggested.%3CBR%20%2F%3EBy%20default%20it%20saved%20to%20my%20%E2%80%98%E2%80%A6%5CAppData%5CRoaming%5CMicrosoft%5CAddIns%E2%80%99%20folder%3CBR%20%2F%3EThen%20i%20went%20to%20the%20developer%20tab%2C%20checked%20the%20add-in%20(the%20same%20file%20saved%20now)%3CBR%20%2F%3EThe%20macros%20is%20there%2C%20but%20can%E2%80%99t%20run.%20Getting%20error%20as%20below.%20The%20reason%20I%20believe%20is%2C%20the%20data%20saved%20in%20the%20worksheet%20is%20not%20visible%20in%20xlam%20file%20%26amp%3B%20the%20custom%20form%20can%E2%80%99t%20fetch%20the%20data%20from%20it.%20Pls%20advice%20if%20i%20missed%20anything.%3CBR%20%2F%3E%3CBR%20%2F%3ERun-time%20error%20'380'%3CBR%20%2F%3ECould%20not%20set%20the%20RowSource%20property.%20Invalid%20property%20value%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3CBR%20%2F%3EHariprasadhari.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3073695%22%20slang%3D%22en-US%22%3ERe%3A%20PERSONAL.XLSB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3073695%22%20slang%3D%22en-US%22%3EYou%20should%20save%20the%20xlsb%20file%20as%20an%20Excel%20Add-in%20(xlam).%3CBR%20%2F%3E%3CBR%20%2F%3ESee%20%3CA%20href%3D%22https%3A%2F%2Ftrumpexcel.com%2Fexcel-add-in%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftrumpexcel.com%2Fexcel-add-in%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have a macro enabled excel workbook, in it one sheet contains name & phone numbers of my suppliers. i have put this sheet as hidden & using a custom made form i am getting phone numbers of the required person. I have provided; add, edit & delete options too in the code. (this iam using as my phone book)

 

What i intend now is to get this phone book in any excel file which is open at that time. I have copied the code & the form to the PERSONAL.XLSB file. But i think the work sheet that contains the phone number details can not be manageable (that sheet i have copied to the xlsb file) in xlsb file. pls advice how it can be made workable? if no direct way, any tricky way/code available?

 

Thanks,

Hariprasadhari

 

4 Replies
You should save the xlsb file as an Excel Add-in (xlam).

See https://trumpexcel.com/excel-add-in/
Dear Doug Robbins,

Many thanks for your quick response.
But still it is not working, see below my followed steps
Saved my macro-enabled workbook (.xlsm) to .xlam file as you suggested.
By default it saved to my ‘…\AppData\Roaming\Microsoft\AddIns’ folder
Then i went to the developer tab, checked the add-in (the same file saved now)
The macros is there, but can’t run. Getting error as below. The reason I believe is, the data saved in the worksheet is not visible in xlam file & the custom form can’t fetch the data from it. Pls advice if i missed anything.

Run-time error '380'
Could not set the RowSource property. Invalid property value

Thanks,
Hariprasadhari.
If you send a copy of the xlam file to me at dougrobbinsmvp[atsymbol]gmail[dot]com so that I can see exactly what you have, I will see if I can sort it out for you.
Dear Doug Robbins,

Thanks for your quick response again.
I have shared the sample file to you now, kindly check & advice.

Thanks,
Hariprasadhari.