ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   web query (https://www.excelbanter.com/excel-discussion-misc-queries/269864-web-query.html)

gaa978

web query
 
hello
if we have a web page to show grade by entering student ID
how I can export a range of about 1000 student grade to excel

like this
http://www.damascusuniversity.edu.sy/ol/ems/

student id 413900 414500

thanks

beenobama

I'm using a web query in excel so I can't put a comma or a space infront of the text to stop it autoformatting to date format. I've tried checking the box preserve formatting in the web query options box but it seems to ignore this and automatically convert anything it can into a date format.


All times are GMT +1. The time now is 06:58 PM.

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