Oops… sorry, I think I found the answer by just googling for it. Haven't tested yet, but the answer might be found here<http://www.oooforum.org/forum/viewtopic.phtml?t=10060&start=0&postdays=0&postorder=asc&highlight=systemclipboard> .
Will try it out later. Thanks for reading anyway. J.R. 2009/1/1 Johnny Rosenberg <gurus.knu...@gmail.com> > I want to do the following: > > With my web browser I go to my bank's web page and log in to my account. > Then a summary of all my accounts shows up. I select all of its text and > press Ctrl+c. > > Then I switch to OpenOffice.org and I want my macro to do things with > what's in the clipboard. > > As for now I solved the problem in an ugly way, by just pressing Ctrl+v to > paste it in some random cells, then select the cells and let the macro work > with what it gets from there and then finally erase those cells. > > What I would like to do, is to get the information directly from the clip > board. Is that possible? > > The data from my bank's web site seems to be plain text with \t (TAB > character) to separate the columns from each other. > > I don't know if it's relevant, but I guess it won't hurt to tell you what I > want to do with the information from the clipboard: > > I only want the last column, which is the sums of my accounts. Since my > bank use a character for a thousands delimiter, a dot actually, > OpenOffice.org thinks I am dealing with text if I paste it to a cell. > > Since I'm Swedish, a number with two decimals can look like this: # ### > ##0,00 > In the clipboard, it looks like this: #.###.##0,00 (some use dot between > each three numbers, but spaces are also common and looks nicer if you ask > me) > In OpenOffice.org BASIC, I need to use this format, to make it work > properly: ######0.00 > So my macro will simply remove all dots, which makes it look like this: > ######0,00. Then it will replace the comma with a dot, like this: > ######0.00. Setting the value of a cell to something in that format, like > 1234.57, will make the cell to be numerical. If I look in the cell directly > on the spreadsheet, it will look like 1234,57, since my default language is > set to Swedish, but obviously OpenOffice.org BASIC doesn't care about that. > > Well, there you have some unnecessary information, but perhaps it explains > a bit things like what and why… > > So, to sum it up, I need to read from the clipboard, perhaps row by row, > determining the last column of each row, convert it to a format that makes > more sense and then paste the converted values to some cells in the > spreadsheet. The macro I've already written already deals with the > formatting and it works fine, but it reads the information from other cells > rather than from the clipboard, and I want to obtain the information > DIRECTLY from the clipboard. > > I hope this is not too confusing… > > What I need to know is just how to get what's currently in the clipboard… > > Best regards > > Johnny Rosenberg >
