Some Excel Questions for You
A few things that have been on my todo list for awhile, maybe you know the answer:
1. Is there an intellisense object?
- I want to list the properties of an Object in a worksheet. Is there an easy way? I don’t want to use large classes or read libraries etc.
2. Does anybody know of a free barcode solution?
- Please no “free trial”, rather a bona fide, preferably open source solution to printing scannable barcodes? I’ve even tried creating my own(I drew a rectangle with many lines and grouped them, This and This were very helpful), however I haven’t had time to complete it.
3. How do you identify the underlying type of a variant?
- If you create a variable of type variant, then set it equal to 2, how do you know the underlying type is now Integer? I seem to remember doing this at some point in my life(possibly my VB days).
4. How do I convert Excel to a calculating webpage?
- Once again, Please no “free trial”, I’m aware there are commercial solutions, I’m not that interested. I haven’t even taken a shot at this yet. Basically I want to convert a spreadsheet to calculating HTML, not just a spreadsheet embedded in IE. Is there any code on the net to do this?
1. Listing the properties of an object: I have some code that work well for it. It provides a pop-up text box when an event happens (in this case, a new RSS article) and then fades out after a certain time. I’m pretty sure it could be easily modified to provide a popup list of objects on a worksheet and then fade. Let me know if you’re interested.
2. No idea.
3. Use TypeName(variable name) after setting the variable equal to something.
4. XML combined with DHTML is your best solution for this. It shouldn’t be too hard to do. Let me know if you have specific questions.
Mark
Thanks for the input Mark…
1. It’s not that important, I just thought there would be an intuitive way.
3. Perfect!
4. I may look you up when I get there, which could be awhile.