Load Runner 9.5 Fail to recogonize .Xlsm files

I'm working on performance testing with Lr 9.5 for Citrix based Apps with SAP as back end. We have a Windows based client (excel sheet)with .xlsm (excel sheet enabled with macros) files connect to server. We have Web Http licence for tunning tests. This application looks similar to SAP GUI.
Please let me know the following:
1. which protocol I should use for the tool to recogonize the transactions in Excel sheet (cells).
2. Is there any limitation with licence to reconize excel sheet with macros.
3. Any ApI / patch inorder to identify the trasactions.