topic Re: VBA in qlikview in QlikView https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549548#M1122839 <HTML><HEAD></HEAD><BODY><P>that sounds like a much stronger solution than i currenlty have and will get to work using that solution.</P><P>thanks alot</P></BODY></HTML> Thu, 23 Jan 2014 08:15:17 GMT samuel_brierley 2014-01-23T08:15:17Z VBA in qlikview https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549544#M1122835 <HTML><HEAD></HEAD><BODY><P>Hi i currently have a spreadsheet that downloads outlook calender information. I have provided a link so you can see what ive done and also to take away with you as its pretty useful.</P><P>it requires me to put in someones name and a start and end date then retrieves information based on those parameters.</P><P>I have field that contain peoples names and a calender in my qlikview tool.</P><P>is there a way to get my qikview tool to do what my spreadsheet is doing?</P><P>it will have to be done completely in the script and im assuming 1 download for all names through all dates (maybe just last 2 months to 6 months in the future) and then use the normal filters to do their business but I have absolutley no clue to do what i described in qlikview. any help?</P><P>p.s I am a desktop user so cant open anything, im hoping there is simply somewhere i can post my already working code in qlikview with a few minor edits.</P><P></P><P><A href="https://www.dropbox.com/s/wk6qtk1w1k9rd8u/calendar.xlsm" title="https://www.dropbox.com/s/wk6qtk1w1k9rd8u/calendar.xlsm">Dropbox - calendar.xlsm</A><A href="https://www.dropbox.com/s/wk6qtk1w1k9rd8u/calendar.xlsm" title="https://www.dropbox.com/s/wk6qtk1w1k9rd8u/calendar.xlsm">https://www.dropbox.com/s/wk6qtk1w1k9rd8u/calendar.xlsm</A></P></BODY></HTML> Wed, 22 Jan 2014 11:17:30 GMT https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549544#M1122835 samuel_brierley 2014-01-22T11:17:30Z Re: VBA in qlikview https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549545#M1122836 <HTML><HEAD></HEAD><BODY><P>You can create list boxes for Name and Date and the user can sort the data using these.</P></BODY></HTML> Wed, 22 Jan 2014 20:53:28 GMT https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549545#M1122836 Nicole-Smith 2014-01-22T20:53:28Z Re: VBA in qlikview https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549546#M1122837 <HTML><HEAD></HEAD><BODY><P>That currently what im doing what im after is a way to cut out the outlook intermediary.</P></BODY></HTML> Thu, 23 Jan 2014 07:42:36 GMT https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549546#M1122837 samuel_brierley 2014-01-23T07:42:36Z Re: VBA in qlikview https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549547#M1122838 <HTML><HEAD></HEAD><BODY><P>Hi Samuel,</P><P></P><P>Forgive me "firewalled" from Dropbox.... so can't see your sample.</P><P></P><P>I have done quite a bit with Outlook and VBA, so these pointers may be useful (or not). Outlook doesn't talk too nicely with Excel as its state based, you open change something and the save.</P><P></P><P>You might have more success in creating views in Access with all Data, creating a datasource to point at your Access DB and the Qlikview points at your datasource. Essentially you would be just using Qlikview going forward as once your stream is configured it would not need touching.</P><P></P><P>Hope this helps a little.</P><P></P><P>Rob</P></BODY></HTML> Thu, 23 Jan 2014 08:11:11 GMT https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549547#M1122838 2014-01-23T08:11:11Z Re: VBA in qlikview https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549548#M1122839 <HTML><HEAD></HEAD><BODY><P>that sounds like a much stronger solution than i currenlty have and will get to work using that solution.</P><P>thanks alot</P></BODY></HTML> Thu, 23 Jan 2014 08:15:17 GMT https://community.qlik.com/t5/QlikView/VBA-in-qlikview/m-p/549548#M1122839 samuel_brierley 2014-01-23T08:15:17Z