On Thu, 20 Jul 2006 16:46:53 -0400 "G. Roderick Singleton" <[EMAIL PROTECTED]> spake:
> On Thu, 2006-07-20 at 16:25 -0400, Bill wrote: > > On Mon, 17 Jul 2006 16:21:41 -0400 > > Bill <[EMAIL PROTECTED]> spake: > > > > > > > > Hello, > > > > > > I have had the misfortune of being given a large amount of data in an > > > XLS file. My goal, in the end is to get this all out to CSV files for > > > processing and inclusion into a database. > > > > > > The problem is that part of the information is contained in hyperlinks > > > in the spreadsheet. So I have a field like: > > > > > > "Website" > > > > > > and it points at: > > > > > > "www.websitename.com" > > > > > > I need to have the latter in my output when I export, yet cannot find a > > > way to do it. > > > > > > The closest I have come so far is exporting it as xhtml, and then I > > > would need to run something on it to parse the html. Yeech > > > > > > Hopefully there is a cleaner way, > > > > > > Thanks much for any help > > > > > > > Ironically, I was able to get it through macro's on Excel. For fun I > > imported it into OpenOffice and it basically forced me to kill > > openoffice to get it to stop. Basically everyline that called the > > function generated a popup that it would not work. > > > > Ah well, if anyone has any other ideas for this, that would be great. > > > > Thanks anyway > > Any chance you could post a link to a demo file that illustrates the > problem. That way we could actually see what you see and, perhaps, offer > some way of handling the data. It would also be nice to know what your > settings are in Tools > Options > Load & Save > VBA > > Saving as CSV does lose the hyperlink but the warning does come up so I > am not too surprized. > -- Sure, here is a link to the spreadsheet. http://modok.explosivo.com/~wbchmura/transfer/urlsamplespreadsheet.xls I'll take it down in a week or two. I'd be happy to either have the option to save the hyperlink, or if there was a way I could copy it to another column (like the vba in this one would). Then I could just copy and paste and save. Oh, my VBA settings have all the boxes checked. I am on openoffice version 2.0.3 Thanks for any help... Basically oocalc just errors on every time the function is called in the sheet. Take care, Bill --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
