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 :
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
Bookmarks