Hi everybody, something crazy is happening to me. I wrote an external executable ("graph.exe") which is supposed to save a .xlsm file,
close it, read some data from it, do some calculations, and print the results back into the same spreadsheet. When I double click "graph.exe" everything works. So I created a button in the spreadsheet I mentioned that should call "graph.exe" and therefore initiate the whole process. Here is the code:
When I click the button the .xlsm file is saved and closed, BUT than an error happens and "graph.exe" is not able to read any data from the sheet just closed! I tried to define an hyperlink to "graph.exe" as well, but I get the same problem! Does anyone know why? I was thinking it may have something to do with excel security settings or privacy options, but at this point I don't have a clue. Any suggestion would be greatly appreciated.
Bookmarks