R
Refugee
_
I'm trying to convert an Excel VBA application that we've been using to
Vista and Office 2007, and I'm running into lots of problems.
I already discovered that the common file dialog box isn't available any
more, and I've replaced that with the Find_File command.
But my next problem is with the FlexGrid control. I found the ocx control in
Vista, and I've pointed my reference to it, but when I try to add it to a
form, I get the message that it isn't safe and not permitted.
So what are you all using as a replacement? To make this tougher, I'm in a
corporate environment with a locked down desktop, so I can't go out and
install VB or some 3rd party control. (Actually, I might be able to do that
if my department is willing to pay hundreds of dollars extra per month to
unlock this machine and sign all kinds of waivers in blood -- but then I
don't know whether 3rd party controls would work when I rolled them out and
all of the other users still have locked machines.)
If I can find a solution to the Flexgrid problem, then I get to try to
investigate why the Solver add-in that my code calls isn't found, even though
I'm pointing to it in the References dialog box (at least I know how to write
my own Solver replacement if I can't get the add-in to cooperate).
I'm trying to convert an Excel VBA application that we've been using to
Vista and Office 2007, and I'm running into lots of problems.
I already discovered that the common file dialog box isn't available any
more, and I've replaced that with the Find_File command.
But my next problem is with the FlexGrid control. I found the ocx control in
Vista, and I've pointed my reference to it, but when I try to add it to a
form, I get the message that it isn't safe and not permitted.
So what are you all using as a replacement? To make this tougher, I'm in a
corporate environment with a locked down desktop, so I can't go out and
install VB or some 3rd party control. (Actually, I might be able to do that
if my department is willing to pay hundreds of dollars extra per month to
unlock this machine and sign all kinds of waivers in blood -- but then I
don't know whether 3rd party controls would work when I rolled them out and
all of the other users still have locked machines.)
If I can find a solution to the Flexgrid problem, then I get to try to
investigate why the Solver add-in that my code calls isn't found, even though
I'm pointing to it in the References dialog box (at least I know how to write
my own Solver replacement if I can't get the add-in to cooperate).