Macro migration from MS Office 2003 to 2010

[Vardenf]

Hello,

I've migrated from Windows XP/Office 2003 to Windows Vista/Office 2010.

Everything works fine exept of my old macros. They have beed programmed... probably at 1997? But they worked just fine, till now.

I read on the web that it is because of some incompatibilities since Office 2007. But can you please tell me WHAT EXACTLY needs to be updated in my code?

Attachment 321592

Please Login or Register  to view this content.

What I need is to scan folder C:\Mouse and there find .xls file (Mouse.xls) which will apear in ComboBox (via attached screenshot).

Something wrong with .LookIn command?

Thank you

Vardenf

[nathansav]

I think application.filesearch isnt there anymore. not 100% though.

[ag273n]

i tried clicking on the link for the attached file to see what's broken in it and i got an error...

"Invalid Attachment specified. If you followed a valid link, please notify the administrator"

[AlphaFrog]

Yes Applicatin.FileSearch was discounted in 2007. Use the Dir function or File System Object in the Scripting Runtime lib.

This is uses the Dir function (untested). This is just an example. There's a good chance I missed something.

Please Login or Register  to view this content.

[Vardenf]

Here is the link for an attachement:


http://postimg.org/image/k5oho244v/

Thank you

[Vardenf]

Hello,

thank you very much, with little changes it works, BUT the next problem occured:

Please Login or Register  to view this content.

Now, after successful file-search it apeared in the ComboBox. Now, when I select this file, following question appears:

Imput data are in file Mouse.xls?

Attachment 321906

After click Yes it should open file and check data version:

Attachment 321910

BUT instead of that it doesn't open the file but following error appears:

Error during opening file number 1004. Can not continue! Call autor of the aplication.

Attachment 321908

Only one workaroud I found is:

1) Open document with this code (cheese.xls), DO NOT run macro yet, let document opened
2) Open Mouse.xls -> Save As -> Rewrite original Mouse file, close Mouse.xls document
3) Run macro on cheese.xls
This way it works, BUT I have to do this everytime I open cheese.xls!

What's wrong with this 1004 error?


Thank you for help

[Vardenf]

Here are mirrors for screenshots:

http://s15.postimg.org/m3epjuisb/Mouse.jpg
http://s15.postimg.org/o990ecm8r/Mouse_Error.jpg
http://s15.postimg.org/cy6cpzfdn/Mouse_Q.jpg

[AlphaFrog]

Your attachments are not valid.

Images are not very useful.

I don't know what your "Open file" code looks like.

[Vardenf]

Hello,

here is code where error window appears:

Please Login or Register  to view this content.

I guess, is it again because of MS Office 2007< changes?


Thank you verry much