[RESOLVED] Files developed for XL2010 breaking when opened/saved in XL2013

[CTBarbarin]

Hi all,

I have many XL files set up Early Binding referencing MS Word 14.0 Object Library...now we gotta go through the process of converting them to Late Binding.

I found si_the_geek's XL Tutorial and this post: Useful functions and downloads

Excel constants module
This is a pre-written module which contains all of the Excel constants (e.g.: xlLeft), to enable you to keep the constant names in your code when you are using Late-binding. Just add the module to your project! (NB: this download also contains similar modules for the other Office products).

This is provided by Microsoft, and can be downloaded here: http://support.microsoft.com/kb/112671 (alternative)

Note that the above file is designed for Excel 97, so it does not contain constants which have been added more recently (it does however contain almost everything you need). You can see a list of constants in the Excel 2003 constants page, which contains those for Excel 97 plus newer ones.

(I hope I got that quote right...since I had to create it from scratch, so to speak)

Since that post is ancient, those links are dead. I tried Googling for updated info to no avail.

Anyone know if MS is maintaining this with each new version? Links to download module please? Or...does someone have that module (or a sample) they can post...or a tutorial/example to walk me through setting my own up?

Thanks for any help anyone can provide,

CTB

[si_the_geek]

Welcome to VBForums

I suspected this would happen (which is why I included an alternative link), but at least the constants page is still there (but converting that to code based constants would take a lot more work).

Thankfully an archive site has a copy of the page, and apparently the download:
http://wayback.archive.org/web/20141....com/kb/112671
I haven't tested this, so would recommend taking precautions (eg: open it in a Virtual Machine if you have the option).
edit: I'd recommend using the file in the post below instead!


While looking for it, I found an alternative to the constants page:
https://msdn.microsoft.com/en-us/lib...constants.aspx
...and a page that seems to describe how to get the values of all constants (basically the equivalent of the constants page):
https://support.microsoft.com/en-us/...ce-application

[si_the_geek]

I decided to create a module based on the values on the constants pages (so I can add it directly to the tutorial), which I've attached. You can open it in Notepad to check the values etc.

Could you give it a try, and see if it works for you?

[westconn1]

you can also enumerate all the constants from the currently installed excel version using typelibraryinfo

[CTBarbarin]

Thanks, Si, for all of your help.

I decided to create a module based on the values on the constants pages (so I can add it directly to the tutorial), which I've attached. You can open it in Notepad to check the values etc.

Could you give it a try, and see if it works for you?

I hope you didn't go through too much trouble for that. I opened and looked at that file. I'm sure that would work just fine (hopefully someone else will be able to use it), but I don't need XL constants as these are XL files I'm working with.

I need WD constants.

...and a page that seems to describe how to get the values of all constants (basically the equivalent of the constants page):
https://support.microsoft.com/en-us/...ce-application

I used this method to create a list of all of WD's constants...so when it comes time, this will help out a lot.

Thanks again,

CTB

[si_the_geek]

Thanks, Si, for all of your help.

No problem, I'm glad you got a solution out of it

As you now have it sorted out, could you please do us a little favour, and mark the thread as Resolved?
(this saves time reading for those of us who like to answer questions, and also helps those who search to find answers)

You can do it by clicking on "Thread tools" just above the first post in this thread, then "Mark thread resolved". (like various other features of this site, you need JavaScript enabled in your browser for this to work).

I hope you didn't go through too much trouble for that.

I figured you won't be the last person to want the now-gone download, so I should update the tutorial with some of the things I've posted here... thankfully the module was basically a glorified copy+paste (using a formula in Excel to write the code), so wasn't too bad.

It's a shame the module isn't useful for you, but I'm sure at some point somebody else will let me know whether or not it works.