VBA converter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon Prior - 29 Mar 2006 13:20 GMT

Hi there

I¹m trying to run a Windows originated Excel spreadsheet with visual basic
embedded commands on Office 2004. The Mactopia website offers a vba
converter for Office 2004, but only downloads the one for Office X which
will not install.

Does anyone know of a source for a 2004 converter?

Thanks

Simon

Reply to this Message

JE McGimpsey - 29 Mar 2006 14:50 GMT

> I¹m trying to run a Windows originated Excel spreadsheet with visual basic
> embedded commands on Office 2004. The Mactopia website offers a vba
> converter for Office 2004, but only downloads the one for Office X which
> will not install.
>
> Does anyone know of a source for a 2004 converter?

I thought the VBA converter was unnecessary in XL2004, but I might be
wrong.

However, I suspect it's not at all what you want. The VBA converter has
nothing to do with what platform the VBA was generated on, it's a
converter for pre-XL97(Win)/XL98(Mac) file formats.

All subsequent file formats (e.g., MacXL98/01/v.X/04 and
WinXL97/00/02/03) are identical, so no conversion is necessary.

MacOffice VBA and WinOffice 97 VBA is version 5. All subsequent Win
versions are VBA6. There's no automatic conversion available from VBA6
to VBA5. I'm not sure what "visual basic embedded commands" means, but
for most differences there are a number of workarounds available.

What specifically isn't converting?

Reply to this Message

Simon Prior - 29 Mar 2006 15:03 GMT

On 29/3/06 14:50, in article
jemcgimpsey-4D0D69.06504729032006@msnews.microsoft.com, "JE McGimpsey"
<jemcgimpsey@mvps.org> wrote:

>> I¹m trying to run a Windows originated Excel spreadsheet with visual basic
>> embedded commands on Office 2004. The Mactopia website offers a vba
[quoted text clipped - 19 lines]
>
> What specifically isn't converting?

I'm using a custom built budget spreadsheet. When I try to run it on a PC
and click on buttons to insert or delete rows (which also add formulae all
over the place) I get 'compile error in hidden module: sheet 6'. When I run
it on the Mac it doesn't recognise the buttons at all.
I've spoken to the IT department who suggest downloading VB runtime for the
windows machine and have no interest at all in the Mac.
As far as I can tell there are hidden macros somewhere; sadly I am just
competent enough to be dangerous and so don't know whether all they do is
fill down formulae or if they link to other sheets, profit margins or heaven
knows what.

And no one can tell me.

Thanks for your interest and help.

Reply to this Message

JE McGimpsey - 29 Mar 2006 19:39 GMT

> I'm using a custom built budget spreadsheet. When I try to run it on a PC
> and click on buttons to insert or delete rows (which also add formulae all
[quoted text clipped - 6 lines]
> fill down formulae or if they link to other sheets, profit margins or heaven
> knows what.

The buttons are ActiveX buttons from the Control Toolbox. Unfortunately,
ActiveX is a technology only implemented in Windows.

The workaround is to use Forms buttons and attach macros to them. This
is relatively simple to do, usually, but would need some knowledge of
VBA coding.

Reply to this Message

Mac Forum / Applications / Excel / March 2006

VBA converter