macro migration from XP to windows7

M

Maud

I'm using a macro to open thousands of .dat files and work on them unde
excel. My laptop crashed so I had to transition from XP and office 200
to windows 7 and office 2007.
My macro is not working anymore.
I can send the piece of code which is out of order
 
A

Auric__

Maud said:
I'm using a macro to open thousands of .dat files and work on them under
excel. My laptop crashed so I had to transition from XP and office 2003
to windows 7 and office 2007.
My macro is not working anymore.
I can send the piece of code which is out of order.

Either post it here, or upload it to a site like pastebin.com.
 
M

Martin Brown

I'm using a macro to open thousands of .dat files and work on them under
excel. My laptop crashed so I had to transition from XP and office 2003
to windows 7 and office 2007.
My macro is not working anymore.

Not suprising.

Mickeysoft introduced a vast number of gratuitous incompatibilities and
removed certain file dialogue functions in the move to XL2007. It wasn't
remotely stable until SP 2 and still has some interesting quirks.
I can send the piece of code which is out of order.

You could be out of luck entirely with thousands of files in XL2007. I
have seen leakage problems when a few hundred are processed that way.

If you value your sanity I recommend sticking with XL2003 for this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top