error Icon 400

Hi all,

I regularly extract a excel sheet from a financial system. I grabbed portions of VBA coding (i am not a coder) on the net so i can do the following smoothly and easily:

A- insert of image from hardrive
B- assign this image a CTRL +F function
C- highlight the row and column of the current active cell to easily read related information on one line

and

D- I recorded a macro to reshaped the file presentation in a click.

those macros are stored on a "extractionsupport.xlsm" file. so when i do a Excel extraction from my financial system in a file called "data.xls", I open the "extractionsupport.xlsm" at the same time containing macro recordings , and launch those macro from and for "data.xls"

A and B work fine, but c doesn't (nothing happens) and D : i got an red cross error icon with the text "400".
Strange thing is that if i launch those macros on the hosted file ("extractionsupport.xlsm"), it works fine.

here is the coding :

Please Login or Register  to view this content.

I hope this is clear ...
I don't understand any piece of code... so i am really lost... your help would be much welcomed :)
thank you so much guys !!!

Celiostat

ps : let me know if you need more piece of information ! or the excel file

Hello cellostat,

When working with different versions of programs there can be problems. Problems like properties or methods that exist in one version but not the other. That is the case here. I have made changes to your code so it will work with either version. In VBA it is rare to have to select something before you can perform an action. You will see an absence of "Select" and "Selection" in the code.

Please Login or Register  to view this content.

Hello cellostat,

After your last post, I think it best if you post a copy of the workbook for review. It will answer a lot more questions faster.