Macro works great in 2007 but not in older excel format

**Tom R.** · 04-17-2013, 05:54 PM

Macro works great in 2007 created from a expert in this forum. One associate I work with uses a older excel format 98 I believe and willl not upgrade??.

The code below errors when promting the user here

Please Login or Register  to view this content.

I also would bet it would error elsewhere too. Is there anyone that could help out converting this code to the earlier version.

Please Login or Register  to view this content.

Thanks, Tom

**JosephP** · 04-17-2013, 06:26 PM

does he use a mac or did you mean 97 rather than 98?

**Tom R.** · 04-17-2013, 07:14 PM

Hello, Thanks, for your reply... Joe Also, sorry for the time lag. I had to reboot. My co-worker has 97

I tried to record the macro with his excel but this did not work. This was a attept to see if I could do it. But im green at it.

Regards, Tom

**JosephP** · 04-18-2013, 03:25 AM

the filedialog didn't exist in office 97 but I'm afraid I can't help beyond that because I don't have a copy of office 97!

**Tom R.** · 04-18-2013, 05:52 AM

Thanks, Joe for your reply. I'm sure not many are using office 97 anymore. I'll still plug around this issue since there won't be any upgrade on his system. Stubburn is what stuburn does.

Best Regards, Tom