View Full Version : Re: Translating an XP macro type file to Excel v.X Mac


Mike Middleton
07-08-2003, 05:08 PM
"Mike Middleton" <middleton[at]starband.net> wrote in message news:...
> George Bussey -
>
> > ... when I try to run it, I get the message, "compile error in
hidden
> module: frmOneway" ... <
>
> I get that same error message when I try to run it with Windows Excel 97
and
> Windows Excel 2002 (Office XP).
>
> You may want to contact Chris Albright again, even though he said "I just
> tried this updated version (the attached file) on my PC, and it worked
> fine." Or, try it on someone else's computer first (Windows or Mac) before
> you contact him.
>
> - Mike Middleton, www.usfca.edu/~middleton
>
>

George Bussey
07-09-2003, 05:35 AM
On 7/8/03 1:08 PM, in article eI7rIOXRDHA.2228[at]tk2msftngp13.phx.gbl, "Mike
Middleton" <middleton[at]starband.net> wrote:

>
> "Mike Middleton" <middleton[at]starband.net> wrote in message news:...
>> George Bussey -
>>
>>> ... when I try to run it, I get the message, "compile error in
> hidden
>> module: frmOneway" ... <
>>
>> I get that same error message when I try to run it with Windows Excel 97
> and
>> Windows Excel 2002 (Office XP).
>>
>> You may want to contact Chris Albright again, even though he said "I just
>> tried this updated version (the attached file) on my PC, and it worked
>> fine." Or, try it on someone else's computer first (Windows or Mac) before
>> you contact him.
>>
>> - Mike Middleton, www.usfca.edu/~middleton
>>
>>
>
>
Thanks for the info.... I'll try the download you suggested, then get back
to Chris... He talked about deleting some stuff from his original program...
Maybe have him put that stuff back ... I'll let you know what I discover.

George

George Bussey
07-12-2003, 02:47 AM
On 7/8/03 1:08 PM, in article eI7rIOXRDHA.2228[at]tk2msftngp13.phx.gbl, "Mike
Middleton" <middleton[at]starband.net> wrote:

>
> "Mike Middleton" <middleton[at]starband.net> wrote in message news:...
>> George Bussey -
>>
>>> ... when I try to run it, I get the message, "compile error in
> hidden
>> module: frmOneway" ... <
>>
>> I get that same error message when I try to run it with Windows Excel 97
> and
>> Windows Excel 2002 (Office XP).
>>
>> You may want to contact Chris Albright again, even though he said "I just
>> tried this updated version (the attached file) on my PC, and it worked
>> fine." Or, try it on someone else's computer first (Windows or Mac) before
>> you contact him.
>>
>> - Mike Middleton, www.usfca.edu/~middleton
>>
>>
>
>


I have now tried his "unedited" macros and get some of the same types of
mistakes.... Can you tell how this was written? VB?? Just running a
macro?? I am not technical but I'd like to ask him the correct questions...
I'm thinking that if he could send me something that was editable at my end,
we, as a group, might be able to find the errors and create something that
works on the mac, which would be useful to those doing complex spreadsheet
"what if" analyses....

George

Mike Middleton
07-16-2003, 02:10 AM
George Bussey -

> I have now tried his "unedited" macros and get some of the same types of
mistakes.... Can you tell how this was written? ... <

Excel VBA.

- Mike Middleton, www.usfca.edu/~middleton