- zeroes being truncated
Hi, I have a tab delimited file that has products that I import into design software and I am having a problem opening it in excel because the product codes sometimes lead with zeroes. How can I open the file without getting rid of the zeroes? I can open the file with notepad and see all the pro...
- Yet another macro...
Hi everybody,I know it can sound trivial, but I cant solve this problem:I'm using in an excel macro: Range(RangeFrom).Copy Range(RangeTo).PasteSpecial Paste:=xlPasteValues, _ Operation:=xlNone, SkipBlanks:=False, Transpose:=FalseThe fact is that I would like to trim blank spaces th...
- Yet another excel macro
Hey I need some quick guidance for a excel macro.. I need a macro that does this:1) Selects sheet22) Copies all of sheet 2 to sheet 13) Deletes sheet23) Selects sheet 33) Copies all fo sheet 2 into next available space on sheet 14) Deletes sheet 3.....Here is the problem though... how can we aut...
- YAE7F: Yet Another Excel 2007 Flaw
I really, really like it when a company takes a stable, useful product and rewrites it so as to turn it into a flaky -- and therefore less useful -- product. It gives meaning to my existence as a customer. So here's the latest glitch/flaw in Excel 2007: I have an xlsx spreadsheet. I don...
- xp formatting issue
I recently upgraded from office 2k to xp. I have an xls file with links to another xls file. If the cell in the source file is empty the cell in the linked file is showing a 0 (or zero value) rather than a blank cell. This was not happening in 2k.Does anyone know why this is happening and how...
- XML2Excel: Import to different sheets
The xsl availabe at http://xslfactory.free.fr is said to transform an XML file to a big spreadsheet. I want to open the transformation output with MS Excel such that the data are - as announced - sorted to different sheets. How can I have Excel provide me with the output on different sheets? Or...