Dealing with excel files what can be used besides VBA?

Question

I have been working on an excel file which will combine each of the excel files sent by the users. So I will have a user entry row per file.

I started by using VBA. I thought that it would be the best, natural choice, though I did not know how to use it previously. At the moment I have come across problems that I have no idea how to solve in VBA - I want to open each of the excel files that contains a user form seamlessly even if it contains VBA code, but what happens is that each opening user gets a dialog that requires them to accept or reject VBA.

I really like to learn new things but it is starting to annoy me. I do hope there some other solution to do that, but not in VBA. Is it possible to do that in some other language, and fire it from VBA?

I would love to have all bounded in that master excel file, or at most just to provide some library. The excel version is 2003.

Answer 1

how are you opening the file? Workbooks.Open will open an excel file which has vba without asking the user to accept or reject code.

Perhaps its an issue with the security settings you have. You can check these out from the menu - Tools, Macro and then security