Object not set error - excel 2007

[bnath001]

I have some VBA code that calls a webservice to get some data.

I have also installed Microsoft office soap type library on the machine.

I get "Object not set" error on the following line:
webServiceRequest.TimePeriod.TimeSlot = inputTimeSlot

Not sure what to do. I appreciate some advise/help.

Sub ImportMarketData()

Dim marketDataService As New clsws_FHLBSFCurveService
Dim webServiceRequest As struct_FHLBSFCurveRequest
Dim inputDate As String
Dim inputTimeSlot As String

inputDate = InputBox(Prompt:="Market-Data Date:", _
Title:="Market-Data Date", Default:="12/31/2006")

inputTimeSlot = InputBox(Prompt:="Market-Data TimeSlot:", _
Title:="Market-Data TimeSlot", Default:="EndOfMonth")

webServiceRequest.TimePeriod.TimeSlot = inputTimeSlot
webServiceRequest.TimePeriod.TimeStamp = DateValue(inputDate)

webServiceRequest.CurveClassName = "DNCOCurve"
Set curveResponse = marketDataService.wsm_GetCurve(webServiceRequest)

[shg]

Welcome to the forum, bnath.

Please take a few minutes to read the forum rules, and then edit your post to add code tags.