ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   XL Query. Urgent Please help. (https://www.excelbanter.com/excel-programming/275174-xl-query-urgent-please-help.html)

jinijug

XL Query. Urgent Please help.
 
Requirement:
1) We have 12 users using XL sheets to enter data. All 12 users have
their own format. We need to capture the input from only a few
columns(present in all the 12 sheets in different locations) and export
the same as a CSV format.
2) This CSV format has to be stored in a standard location with a
standard name.
3) The application ,if possible, should be pop up a web page (send a
request to a servlet with the XL file location), the user can click a
button on the resulting page and send the file to the server.

I would a solution for each or all of the above as a single one. Please
give any pointers you can.

thanks in advance.



------------------------------------------------
Message posted from http://www.ExcelTip.com/

-- View and post Excel related usenet messages directly from http://www.ExcelTip.com/forum
-- Hundreds of free MS Excel tips, tricks and solutions at http://www.ExcelTip.com/
------------------------------------------------


All times are GMT +1. The time now is 03:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com