Changing values in separate excel files

[afa13]

Hello,
I want to change the sane tab in different excel files in the same directory (folder). I found a code in this forum that did just that.
I ran it as a module in the developer tab in excel.
However, I want to know if it is possible to execute the code by saving it in Notepad as a specific extension and running it directly.
Thanks.

 

[ChrisRamsden]

I may be misunderstanding the ask but could you not just link the cells using =filepath,filename,sheetname,cell (or type = in the first cell you want to link while having both spreadsheets open at the same time, then click between them and select the cell you wish to link - this will automatically fill in the filepath when one of them is closed.)
If you link A1 to A1 you can then use autofill to link all cells in a range that you want. Saves you using VBA and the spreadsheets will update whenever you open them again (or save them)
Hope this helps

 

[afa13]

The issue at hand is as follows:
I want to change the value(string) in many excel files, so i found a code that would do just that. However, to execute it I have to access VBA.
My question is if I could do the same by creating a file and executing it.

 

[ChrisRamsden]

As far as i am aware most of the microsfot office suite has the ability to run macros (inluding word) so i guess you could run it from another application as long as it has the ability to do so. Is there a specific reason why you cannot have a "Master" spreadsheet to run the macro from? What is your issue accessing VBA?