I have a form where user can make a new ‘appointment’, when saving, VBA creates piece of code and new Shape into calendar worksheet (and to Outlook, but that is not the point here). I hear your problem, now show me your problem I run the Inspector few times, and It gave different results every time. I visited the links given by the Inspector, no help there. only way to stop the Inspector and see the results was CRT-ALT-DEL –Stop…) It keeps getting better, same Microsoft software stated:ĬODE: MyFullName = ThisWorkbook.FullName”” Textbox.Text wasn’t working, I found and run Microsoft Excel Code Compatibility Inspector (CII), and it showed that I have few thousand of those Textbox.Text elements that are “Deprecated” – “Potentially contains removed items the object model” – What? I found solution: now I just have to redo every calendar on all my forms… Thanks. I need to learn this.Ĭalendar active-X component was missing. Of course I could copy-paste every piece of my code to programmers discussion forums, get laughed at, and after some weeks I might get some of them to work, but what I really need is real information written to basic VBA user. What I really want is some pointers to real information, if there is any! I just need to know why my code doesn’t work anymore, and what to do about it. No, I don’t need it to backwards compatible with anything, it is enough that it works with my new computer, and new software (In my case it is 64 bits, if anyone wonders). How do I make my old 2007 VBA to work with 2010? ![]() ![]() I found a lot of blogs aimed to professional programmers who are hoping to make bullet proof code to serve anything from Office 0 to Office2010, 32 bits to 64 bits (No 8 bits here?), but none of the articles talked about the main business, The End User with whole lot of homemade coding to survive a day. For two days I searched web, trying to find any documentation for the end user, no luck. Now I tried to use my old stuff on Office 2010, and everything is just little bit off to be usable. ![]() None of them were programming masterpieces, but those worked and got work done with excel, and office 2007. ![]() Now I have a bunch of quick-and-dirty VBA to go with my old worksheets. As typical small-business user, when my laptop broke I HAD to upgrade to Office 2010 (2007 isn’t on market anymore).
0 Comments
Leave a Reply. |