|
So I am working on excel 2010 64bit on Win8 64bit, programming a macro and trying to create a form containing a date picker (calendar).
This is not an inbuild control anymore, as it used to be.
OK, googled, downloaded the corresponding ocx, and tried to register it. Did not work.
OK, googled, learned that you need "super admin privileges" (I was already admin in the previous step). Fine. Registered. Date pciker did not show up in excel.
OK, googled, learned that you need to add the control in the reference list. Did that. Date pciker still did not show up in the additional controls.
OK, googled, and finally learned that MS has not provided a 64bit version of the common controls yet. Would have worked in any other combination OS32/Office32, OS64/Office32, but not OS64/Office64.
The only thing useful in all this, is that I learned that when you go in the bottom left corner and right-click in Win8, a super context menu appears with a lot of useful shortcuts.
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
|
I have the feeling that you missed the great honor and privilege to work with M$ finest technologies you can see in action and i mean ActiveX and COM. What a joy to the world.
Microsoft ... the only place where VARIANT_TRUE != true
|
|
|
|
|
I really don't understand why everything has to be so complicated when it comes to 64 bit. It's not exactly like it's a new technology... 
I've also run across several things that work perfectly fine in 32 bits, but not at all in 64 bits...
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
Do not argue with an idiot. He will drag you down to his level and beat you with experience
Greg King
-----
I always wanted to be somebody, but now I realize I should have been more specific.
Lily Tomlin, Actress
|
|
|
|
|
I dream of the day of working in a 64bit environment.
Hell our legacy system is still in MS Access 2000 running on a 32bit XP.
I have a feeling that Windows Whine will have died the moment we leave XP at this rate 
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
And then you'll upgrade from XP .. to XP x64
|
|
|
|
|
Rage wrote: MS has not provided a 64bit version of the common controls yet
Actually spend time on their most profitable product line? That's just silly. Better to spend time and money messing up all the icons and colors in Visual Studio, creating an abominable site for App Store developers and developing a tablet nobody wants.
|
|
|
|
|
Rage wrote: The only thing useful in all this, is that I learned that when you go in the bottom left corner and right-click in Win8, a super context menu appears with a lot of useful shortcuts.
You can also get to the menu by pressing Win+X on your keyboard.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
You may be able to create your own DateTimePicker control using VB.Net. The only reason I say "may be able to" is because I do not have Office 64 to test this, but it works great for my 32 bit Office 2007.
Microsoft released a SDK to create ActiveX controls in VB.Net that can be hosted in VB6 and the created controls work great in Excel as well. The SDK is targeted to VS2008 and VS2010 and installs a template for creating am ActiveX UserControl in VB.Net.
Back to the future! – New version of the VB6 InteropForms toolkit is released!![^]
Microsoft InteropForms Toolkit 2.1[^]
As this was designed for VB6, the template targets x86. This in itself is appropriate, but the ninnies did this under the AnyCPU configuration. So you think AnyCPU is targeted, but in reality it is x86; I mention this because I think you will want to target AnyCPU for this to work with Office 64 bit.
|
|
|
|
|
...you see a clickbait link titled "The Surprising Link Between MS and Sunshine" and wonder how anyone could be surprised about Microsoft being run by a bunch of sunshines.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt
|
|
|
|
|
Yep,,I keep laughing at headlines or stories with the word sunshine in, looking around for someone to share the joke with then realising it is just me that gets it.
“I believe that there is an equality to all humanity. We all suck.” Bill Hicks
|
|
|
|
|
I do that every time I see Florida's nickname. 
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Oh good, I thought it was just me! 
|
|
|
|
|
...in the last three years or so?
|
|
|
|
|
The Code Project website was closed down a couple of years ago. There are no-one here anymore except us hamsters!
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
Do not argue with an idiot. He will drag you down to his level and beat you with experience
Greg King
-----
I always wanted to be somebody, but now I realize I should have been more specific.
Lily Tomlin, Actress
|
|
|
|
|
|
A lot of CCCs, some jokes in Soapbox, many good articles, some strange Q&A questions.. and more..
Wellcome back!
The signature is in building process.. Please wait...
|
|
|
|
|
.... livestream spammers & contracting trolls too [^]
|
|
|
|
|
Now you want to miss the productive work being here ?
Welcome back to the Timepass cafeteria.
|
|
|
|
|
I let rip in my office one morning, so bad I had to leave myself!
|
|
|
|
|
But you looked sexy, though[^]
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
Do not argue with an idiot. He will drag you down to his level and beat you with experience
Greg King
-----
I always wanted to be somebody, but now I realize I should have been more specific.
Lily Tomlin, Actress
|
|
|
|
|
 thanks.......
|
|
|
|
|
SFA. 
If there is one thing more dangerous than getting between a bear and her cubs it's getting between my wife and her chocolate.
|
|
|
|
|
Hey ! Leckey ! Welcome back !!!
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
