Interacting with Excel open in IE

K

ksgoodwin

I have a web based Excel application I want to manipulate. It is a
single Excel sheet in an IE window. Using Excel 2003 and XP. I can
not change the starting application displayed. I have been able to add
additional sheets, copy, paste and manipulate the data, format the new
sheets, add an AutoFilter, Sort the data, add equations, etc. I am
using the Personal.xls file to run the macros using a ctrl + q key
shortcut. However, I would like to run various sorts on the data after
initial macros are finished. Sort on various columns (12 months of
data).

What would be the suggested approach? Where would I store the macros?

Ken
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top