| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting Dates from Clipboard of Web Page to Excel
Hi from Europe!
I am using VBA to paste a clipboard filled with figures and dates from a Web page but the VBA is altering 7 March 2006 (07/03/06) to 3 July 2006 (03/07/2006). This only happens in VB code - when pasting manually the date is pasted fine. I have searched the newsgroups but the only solution seems to be to use Excel 2002 which I don't have. The date is always in the third column of the clipboard - is it possible to interrogate the clipboard? Are there any other avenues to explore? Thanks in advance Tim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting delimited text from clipboard directly into Excel Spreadsh | New Users to Excel | |||
| How can I turn off the clipboard icon when cut and pasting? | Setting up and Configuration of Excel | |||
| Excel - give users option to keep info in clipboard after pasting | Excel Discussion (Misc queries) | |||
| Excel clipboard should allow pasting of formulae not just values | Excel Discussion (Misc queries) | |||
| Pasting from Excel Clipboard with VBA Macro | Excel Programming | |||
Threaded Mode
