topic Re: macros in QlikView https://community.qlik.com/t5/QlikView/macros/m-p/1009374#M956066 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>I already have the table. I need to insert the values into the table..</P></BODY></HTML> Tue, 17 Nov 2015 09:52:44 GMT raadwiptec 2015-11-17T09:52:44Z macros https://community.qlik.com/t5/QlikView/macros/m-p/1009368#M956060 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>Can anybody share the macro or vb script to write a table in the access database.</P></BODY></HTML> Tue, 17 Nov 2015 09:10:00 GMT https://community.qlik.com/t5/QlikView/macros/m-p/1009368#M956060 raadwiptec 2015-11-17T09:10:00Z Re: macros https://community.qlik.com/t5/QlikView/macros/m-p/1009369#M956061 <HTML><HEAD></HEAD><BODY><P>see the following thread:</P><P></P><P><A href="https://bytes.com/topic/access/answers/771480-possible-write-macro-creates-new-table" title="https://bytes.com/topic/access/answers/771480-possible-write-macro-creates-new-table">Possible to write a macro that creates a new table? - Microsoft Access / VBA</A></P></BODY></HTML> Tue, 17 Nov 2015 09:27:33 GMT https://community.qlik.com/t5/QlikView/macros/m-p/1009369#M956061 Anonymous 2015-11-17T09:27:33Z Re: macros https://community.qlik.com/t5/QlikView/macros/m-p/1009370#M956062 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/72934">Problem with WriteBack to MS-Access</A></P></BODY></HTML> Tue, 17 Nov 2015 09:29:55 GMT https://community.qlik.com/t5/QlikView/macros/m-p/1009370#M956062 Siva_Sankar 2015-11-17T09:29:55Z Re: macros https://community.qlik.com/t5/QlikView/macros/m-p/1009371#M956063 <HTML><HEAD></HEAD><BODY><P>see the below link</P><P></P><P><A href="https://community.qlikview.com/thread/1048" title="https://community.qlikview.com/thread/1048">Update and external Database with a Macro. | Qlik Community</A></P></BODY></HTML> Tue, 17 Nov 2015 09:31:04 GMT https://community.qlik.com/t5/QlikView/macros/m-p/1009371#M956063 Kushal_Chawda 2015-11-17T09:31:04Z Re: macros https://community.qlik.com/t5/QlikView/macros/m-p/1009372#M956064 <HTML><HEAD></HEAD><BODY><P>set MAccApp = CreateObject("MSacess.Application")</P><P><SPAN style="font-size: 13.3333px;">MAccApp</SPAN>.Visible = true</P><P>set <SPAN style="font-size: 13.3333px;">MAcc</SPAN>Doc =<SPAN style="font-size: 13.3333px;">MAccApp</SPAN>.Dat.Open("Template file")</P><P></P><P>set PHARMA = <SPAN style="font-size: 13.3333px;">MAcc</SPAN><SPAN style="font-size: 13.3333px;">Doc</SPAN>.Database("Datasheet Name")</P><P>ActiveDocument.GetSheetObject("ChartId").CopyTableToClipboard true</P><P> <SPAN style="font-size: 13.3333px;">MAcc</SPAN><SPAN style="font-size: 13.3333px;">Doc</SPAN>.<SPAN style="font-size: 13.3333px;">Database</SPAN>("<SPAN style="font-size: 13.3333px;">Datasheet Name</SPAN>").Activate&nbsp; </P><P></P><P></P><P>This should work</P></BODY></HTML> Tue, 17 Nov 2015 09:33:18 GMT https://community.qlik.com/t5/QlikView/macros/m-p/1009372#M956064 2015-11-17T09:33:18Z Re: macros https://community.qlik.com/t5/QlikView/macros/m-p/1009373#M956065 <HTML><HEAD></HEAD><BODY><P>Hi devanand,</P><P></P><P>already table exists in the database. I need to insert the values in the table. does the above code does the same.</P></BODY></HTML> Tue, 17 Nov 2015 09:48:25 GMT https://community.qlik.com/t5/QlikView/macros/m-p/1009373#M956065 raadwiptec 2015-11-17T09:48:25Z Re: macros https://community.qlik.com/t5/QlikView/macros/m-p/1009374#M956066 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>I already have the table. I need to insert the values into the table..</P></BODY></HTML> Tue, 17 Nov 2015 09:52:44 GMT https://community.qlik.com/t5/QlikView/macros/m-p/1009374#M956066 raadwiptec 2015-11-17T09:52:44Z