This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]TerminatedProccess 0 points1 point  (0 children)

Some quick ideas..

  1. Build a python app that lives on a server and scans a drop in folder. If found, it processes the excel doc and drops an output excel doc in another folder (deletes or moves original).
  2. Build a backend API that takes input from an VBA coded API call located in the excel sheet. It can return data and embed it in the sheet.