Ok, I have looked this up but don't quite know what to do. As the title says, I created my workbook tracking program in 2013.
Others at work use 2007 and I get some errors, like with Application.PrintCommunication for example.
I know I have to Bind some references, but how do I go about that and what do I bind?
Hi, Aris,
maybe post the code which is causing the run-time error to have a look at.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Ok, I'll post it when I get home later. It all works perfectOriginally Posted by HaHoBe
In 2013, it just errors out in 2007. I put so much work into
These workbooks , to come to a halt because of a version,
Would drive me insane! Lol
Here is the line that throws the error:
Is this not available in 2007? How do I bind the new references to my file?
Please Login or Register to view this content.
Hi, Aris,
have you tried commenting the code lines
andPlease Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
No - it was only introduced in 2010. Just remove it as Holger said - you can't add references to get round it.Here is the line that throws the error:
Is this not available in 2007? How do I bind the new references to my file?Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
Ok. Is there a code line that I can check what someone version of excel is?
Then I'll just fix it so if they have an old version it skips that section of code.
To the best of my recollection, 2007 was still VBA6 so you could use:
Please Login or Register to view this content.
Ok I'll give that a shot. Btw, what are the # for?
It's conditional compilation so the compiler will ignore the code completely unless the VBA7 constant has a value 1. Otherwise you would have to have separate modules for all the code that is specific to any particular version.
Ok, I just commented those pages out and it is fine. Nice easy fixes are always the best!
Thanks all!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks