I have coding i am store data as dictionary
When dictionary using in sub makro
Please Login or Register to view this content.
This bellow is error
But if using call mydic ,that will be sucsesPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by 6StringJazzer; 02-12-2018 at 10:52 AM. Reason: removed incorrect characters from title
You have syntax errors in the code you have posted so it won't compile. This suggests that you just typed the code into your post, so there could be other errors. We need to see the actual code that you are running.
When posting code, first compile the code, then copy the code from the VBA window and paste it into your post so we have a valid starting point.
Please explain what "is error" means.This bellow is error
- Does the code run?
- Does it run but do nothing?
- Does it produce error messages? If so, what do the messages say?
- Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
- Does it hang?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Along with what 6StringJazzer has said, if your code is in separate modules you'll need to change your Dim Statement toPlease Login or Register to view this content.
I has do also as public
But when run in other macro must calling
mydic
Also if you want to use dic without calling it first (you need to fill the dictionary) you should put your first code in ThisWorkbook. Especially in workbook.open so it gets filled on startup.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Yes i has do to
But if dictionary has change data value before workbook.close then its also must open Wb again
You can work on dic as normal.
Try this as test.
Put this in standard module.
Put this in ThisworkbookPlease Login or Register to view this content.
Run workbook_open first, then sub tstPlease Login or Register to view this content.
Then
If using workbook.open
Same as call mydic in sub makro
I should have explained myself better.
Put both codes in workbook. Save and Close.
Reopen so Workbook_open runs automatically. You just need to run tst.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks