Re: Pasting Dates from Clipboard of Web Page to Excel

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Tim,

What does your code look like? If you can get the text from the clipboard
then you might be able to extract the date and format it as you want....

Tim


"Tim Childs" <tsnip1@xxxxxxxxxxx> wrote in message
news:e1I5CqhQGHA.1556@xxxxxxxxxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: problems pasting Adobe Illustrator graphics-->Inserting them, DISCOVERY
    ... the "Clipboard" is not involved in Insert>File... ... it seems to be no longer a vector format. ... it checks the timestamp on the picture file it finds ... But if the document content and sketches are co-evolving a lot --a very ...
    (microsoft.public.mac.office.word)
  • Re: OpenClipboard
    ... YOU ARE DECLARING LOCAL VARIABLES AND NAMING THEM AS IF THEY ... OpenClipboar, an assertion failure window is pop out, and the program ... buffer to the clipboard, but it doesn't mention what format it is in; ... why you are assuming that it is in CF_BITMAP format. ...
    (microsoft.public.vc.mfc)
  • Re: Cant paste images from Snapz Pro into Word 2008
    ... But I am trying to find out what is ON THE CLIPBOARD? ... The native format an application places on the clipboard when you copy will ... with the screen capture application Snapz Pro, ...
    (microsoft.public.mac.office.word)
  • Re: Disabled CommandBarButton image in Office 2000 is always empty
    ... When I create the DIBs I face the problem that Office 2000 apps show empty command bar buttons. ... // S_OFF2000_CLIP_IMAGE was filled earlier with the localized name of the clipboard format "Toolbar Button Face" ... // I tried adding only the Toolbar format or both - neither way the disabled button image was displayed ...
    (microsoft.public.office.developer.com.add_ins)
  • Re: SetClipBoard returns Junk characters!
    ... "The system performs implicit data format conversion between certain clipboard formats ... But in unicode build of my app, ...
    (microsoft.public.vc.mfc)