Macro to generate Reports

[pragnesh_50]

Hi


I want to generate report form my company system. I think it can be automated by excel macro.


Following are the steps to generate report:


1. Go to Link > http://10.6.33.22/onlinetools/mis/owb%20search/OWB%20Search%20with%20Assignment%20Details.asp


2. Enter Login ID & Password


3.Choose options as follows to generated report:

CATEGORY = FILD CLEARING

RETAILER = EPICS(BE)

CODE TYPE = ALL

COUNTRY = BLEGIUM

LANGUAGE = ENGLISH

START DATE = YESTERDAYS DATE (IF MONDY THAN START DATE = FRIDAY)

END DATE = T0DAYS DATE

COOSE OUTPUT = EXCEL (65,000 RAWS MAX), ATTACHMENT


4. Save CSV file on specific path (may be desktop for the moment)


Could any one suggest Macro for these?


Regards,

Pragnesh

 

[SirJB7]

Hi, Pragnesh!

1. doesn't work: The server at 10.6.33.22 is taking too long to respond.

Regards!

 

[pragnesh_50]

I think the server will be excess by company employee only.

 

[vijaySharma]

Pragnesh,


You can use the Internet Explorer library inside your VBA Project and then write code to do this.


Since we cannot access the site, cannot show you the steps.... but the general way to go is to use IE Object.


Hope this helps...


~VijaySharma