Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel file on web with filters


I have an excel file on a website. This excel file has auto filter on
all columns. I need to provide data to users with different filters
turned on (lot of different combinations of filters). Is it possible
that when a user clicks on a link on the website, before opening that
excel file, a macro or some script runs so that data is filtered
depending on which link user clicked?

Or is there any other way to do it (other than creating copies of excel
file, saving it with the filters that I need and then linking
individual links to those different files with different filters turned
on)?

Thanks,
Sanjay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=504610

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove auto filters from a file I exported out of Salesfo SusanM Excel Worksheet Functions 0 May 7th 09 06:18 PM
Pivot Table filters, especially DATE filters chris Excel Worksheet Functions 0 August 27th 08 04:33 AM
Data filters in Excel 2007 not working for one file Brian Toller Excel Worksheet Functions 3 August 31st 07 05:50 PM
Filters, Subtotal & Intacted Results after the filters' Removal kasiopi Excel Discussion (Misc queries) 5 February 24th 06 12:18 PM
Trouble with Filters on a large file Michael Excel Discussion (Misc queries) 4 January 18th 05 11:23 PM


All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"