Hi All,
I am looking for a Macro that pull the data from Remedy and it should promt for start date & end date, I am not sure what are all the details required for this. Please let me know if I miss any of the required parameter.
I have tried pulling the data using MS Query and was able to pull the data. In the table instead of having a standard date I have changed it to [Enter Start Date] as a parameter query and it is working in Query however I am getting an error "Driver] Parameter missing" in excel and my query is lost.
Driver used for this is "DSN=AR System ODBC Data Source;ARServer=remedy03;UID=userid;ARAuthentication=;SERVER=NotTheServer"
The code mentioned below works if the date is constant as mentioned below. I have attached the sample result sheet.
Thanks in advance for all your help!!
Regadrs,
Humac
Bookmarks