W
White Horse
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
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