View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Łukasz Szczepański Łukasz Szczepański is offline
external usenet poster
 
Posts: 3
Default How to reference to other Excel application in VBA

Hi,

I would like to copy some data to my spreadsheet from workbook which is
opened from web. The problem is that "Export to Excel" button always opens
new Excel application, so I can't reference to new workbook from VBA.

How can I check other running applications and how to copy data from other
Excel application to my workbook?

Thanks in advance,