Anyone using spreadsheet server who can help me?

[jazminecat]

I'm evaluating spreadsheet server for JDE, and am trying to write some vba functions to speed things up but i'm stuck. i can't access the menus in vba, and don't know how to program vba to perform the F9 function. Has anyone done custom worksheets with this product that can help me out? thanks!

 

[Housemartins]

An easy way to extract raw data from the database server is by using .ASP. We do that for quick reports and we have raised an IIS for that purpose on a common PC.
We have maintained a grid in .asp to keep the data is a descent shape etc. The compatibility of .asp and all among microsoft products makes your work flexible at all platforms vbasic, excel, vba, scripting etc.