Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Copy Info from Excel Sheet Displayed in IE
My machine has Windows XP SP2, Excel 2003, and IE6.
On an Excel worksheet, I have a hyperlink to a query existing in a third party payroll program. I can "click" the hyperlink and run this query from VBA with no problem. The result is an Excel spreadsheet displayed in IE. I need to copy (using VBA - "Selection.CurrentRegion.Select") the data displayed in the IE window back to the workbook containing the VBA. This would be my preferred way. I tried "My Computer, Tools, Folder Options, File Types", selecting "xls", then Advanced and removing the check from "Browse in Same Window". However, I was prompted for two or three security issues, and the resulting file was in a new instance of Excel. This is not my preferred way since I don't know how to program between the two instances to get the results back to the workbook containing the code. I also may not be able to change other users' settings. Nothing I've seen posted in the groups completely addresses this, although some have come close. Thanks, Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Info from 1 sheet to another within same workbook | Excel Worksheet Functions | |||
copy info from another sheet | Excel Worksheet Functions | |||
Copy info to new sheet | Excel Programming | |||
how do I copy info from one sheet to another via a formula? | Excel Worksheet Functions | |||
Still trying to copy info from one sheet to another | Excel Programming |