Disable Date Recognitions -Importing HTML File on Hard Drive

dale3290 · May 10th, 2002, 02:43 PM

When I use a web query to download a web page I have an option in the advanced button to disable date recognition. That is I can import "1/2" as "1/2" and not as January 2, 20002.

How can I disable this in VBA Macro

Dale

Juan Pablo González · May 11th, 2002, 09:00 AM

Have you tried recording a macro while doing the Web query ? it can give you great ideas on how the code is written.

May 11th, 2002, 09:00 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Have you tried recording a macro while doing the Web query ? it can give you great ideas on how the code is written. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 02:43 PM	#1
dale3290 New Member Join Date: Apr 2002 Location: Dalew Posts: 7	When I use a web query to download a web page I have an option in the advanced button to disable date recognition. That is I can import "1/2" as "1/2" and not as January 2, 20002. How can I disable this in VBA Macro Dale