I did this a lot at my last job. Some portions of the spreadsheet function like tables and calculations on data. Others control input variables. Yet others would just display the data in charts and graphs.
Sound familiar?
Generally speaking, I'll use Excel when I want to go quickly from nothing to displayable content (it also helps that it's easier to explain away an Excel formula than show someone a mess of Haskell). And, on a tangential note, it certainly helps that pretty much every school or office computer will have some version of Excel.
There's no question that spreadsheets are programs, albeit not written in a general-purpose language. Question for you: what do you do in VBA? i.e. in what areas does the spreadsheet alone not suffice?
How much VBA could be replaced if Excel gave you the ability to make functions just out of spreadsheet cells? That is: build any calculation you like in a spreadsheet, tell Excel "make this calculation be a function called FOO", then use it wherever you want like a normal function: "=FOO(123,A1)" or what have you.
On VBA being replaced-- I don't know. It depends who the users you're talking about are. Most people I worked with didn't know any VBA because our models weren't that complicated. I in particular was working on a project that was computationally heavy.
(My email's in my profile if you'd rather discuss it offline.)
On the flip side I think it would be great for the engineers to spend some time in marketing and close up that divide to work better together. Often I see both sides try to keep each other out other their business when much value can be had when marketing gels with engineering.