<div>
Microsoft query should still working find in ver 2007 but I'm not sure how PEMAC works
</div>


Microsoft query should still working find in ver 2007 but I'm not sure how PEMAC works

<div>
Yeah, I thought so too..but apparently not. <a href="http://www.pemac.com" rel="ugc">www.pemac.com</a>&nbsp;is the website.
</div>


Yeah, I thought so too..but apparently not. www.pemac.com [http://www.pemac.com] is the website.

<div>
Appreciate the help. Did contact company directly but didn't find them very helpful on this issue to be honest.
</div>


Appreciate the help. Did contact company directly but didn't find them very helpful on this issue to be honest.

<div>
<div class="content wysiwyg-content">
I have a situation where a customer wants to link a cell in their Excel worksheet to a table in a programme called PEMAC. In &quot;old&quot; Excel they could .(via Microsoft query) but not in 2007 and later.. any of you have any suggestions for a workaround via Excel - cube functions? etc
</div>
</div>


I have a situation where a customer wants to link a cell in their Excel worksheet to a table in a programme called PEMAC. In "old" Excel they could .(via Microsoft query) but not in 2007 and later.. any of you have any suggestions for a workaround via Excel - cube functions? etc

pull a field from a programme into Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.