For years now I’ve been creating tools for my co-workers in VBA (vb in excel) now I’ve upgraded a bit to having Visual Basic Express on my home computer. I can do so much more and its the same language so theres no extra learning.
But how do I make one that is an EXE file so my co-workers can use it. I work for a large cell phone company and theres no way of getting VBE approved to go on all machines. Someone please help with directions or an easier alternative. I’ve looked into using C+/C# but honestly i dont want to lean more coding.

I have a main sheet with dates (month-year) in a column. Against each value in the column there is a row of calculations in several other columns.
I then have as many sheets as there are rows with the dates on the main sheet. Each of these sheets contains detailed calculation that uses data from a particular row (month) in the main sheet.
I can obtain the sheetname using Cell(“filename”) then by using Mid string to get to the sheet name. I now need to use the sheetname I extracted and put it in a formula that refers to a row in the main sheet that has the same value as the sheetname. i.e. in a sheet named April-08 I need to create formulae that refer to values in row April-08 from the main sheet.
I can do this in VBA, but I need to use formulae instead because this workbook will be sent to many users who will either have no rights to change security options or have no idea how to deal with the warning message that comes up when you open a book with a macro or code.
Can this be done at all?

Now I want to export the images back out of Matlab into another program (Word, Excel?) so I can line them all up to print. I use the imagesc function to make the barcode. The program takes the Excel data one at a time and generates the barcode. When one is done the next one will overwrite the old one in the Matlab plot. How can I export them so they all are kept? Please help, I asked before and got one answer which was like “do a VBA” which means nothing to me because I am not a programmer. I need to do this so I am trudging through Matlab learning on the way. Thanks.