testsubjec
New Member
- Joined
- Jul 14, 2011
- Messages
- 33
Hi All,
I'm in process of wanting to create an Excel Spreadsheet which will have two input fields called "Collection Date" and "Delivery Date". The user inputs the date DD/MM/YYYY into these two fields and then clicks a button "Get Data". This calls a SQL Stored Procedure "EXEC dbo.ssp_GetJobData 17/01/2018, 18/01/2018" and populates the worksheet with the data returned from executing the stored procedure.
Now, back in the day using VBA I could do this no problem but because our IT have now given us Office 365 Business ( I believe our Excel version is 1711 ) I am unable to do VBA and Excel is wanting to use the Power BI stuff. Sadly I haven't got a clue how to use the Power BI stuff but I need to get this solution working ASAP.
Please could someone point me in the right direction and help me.
Thank you!!
I'm in process of wanting to create an Excel Spreadsheet which will have two input fields called "Collection Date" and "Delivery Date". The user inputs the date DD/MM/YYYY into these two fields and then clicks a button "Get Data". This calls a SQL Stored Procedure "EXEC dbo.ssp_GetJobData 17/01/2018, 18/01/2018" and populates the worksheet with the data returned from executing the stored procedure.
Now, back in the day using VBA I could do this no problem but because our IT have now given us Office 365 Business ( I believe our Excel version is 1711 ) I am unable to do VBA and Excel is wanting to use the Power BI stuff. Sadly I haven't got a clue how to use the Power BI stuff but I need to get this solution working ASAP.
Please could someone point me in the right direction and help me.
Thank you!!
