Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Melko
  • Order by date
  1. Melko

    Dealing with negative co-workers....

    Look for an other job.
  2. Melko

    How do I choose a network printer in a macro?

    I am not a VBA espert, but I guess that you can execute a external program. Just execute rundll32 printui.dll,PrintUIEntry /y /n "printer" /q for setting the printer you wish as default. Print at the end of your macro just repeat again for re set the right one.
  3. Melko

    Conditional sum, with 2 conditions

    JohnGP, I am afraid that is do not work that way. I mean, if both condition are true I'll just have the sum of ALL data in the c6:c15 and not only the ones that respect the condition and if both condition are not meet I'll just hve nothing. Am I wrong?
  4. Melko

    Conditional sum, with 2 conditions

    Array formulas? What is that? Wow, I have to try...
  5. Melko

    Printing more than one pages at once.

    I have the need of printing lots of different section of a drawing in lots of A4 sheets. There is a way to automatize this process? Using layouts maybe?
  6. Melko

    I cannot view PDF Files on my computer

    Disable it, it is far better downloading the .pdf and seeing them later with the reader. A good thing could be also use Ghostscript related programs to convert .pdf in other format like .html
  7. Melko

    VOLO VIEW 3

    it isnt free?
  8. Melko

    Conditional sum, with 2 conditions

    I found a good solution... Since month never overtook 12 and day never overtook 31 it is enough strip all the date in a single number, like this: E.G. 13/06/2004 is the date (cell a1) with the formula =year(a1)*10000+month(a1)*100+day(a1) become 20040613 easily usable for conditions :) in my...
  9. Melko

    Conditional sum, with 2 conditions

    I have to sum a column data when, not just one condition is met, but 2. In my case the year and the month of a date must equal to what I want. Is that possible?
  10. Melko

    Clean cookie "index.dat" file??

    Using Windows 2000 the best and easy way is makeing a starting script, a .bat file with the following commands: rd /s/q (your cookies folder) md (you cookies folder)\index.dat executed once (as startup script) will deactivate the index.dat file forever making a folder with the same name :)
  11. Melko

    Add-on that adds the chance to manage cell color and background.

    err... no... I have to use only formulas. The conditional formatting do not help me...
  12. Melko

    How do you open an .ica file

    May this helps? http://download2.citrix.com/files/en/products/nfr/ica/ica32t.exe
  13. Melko

    PDF Question

    You can tranform ANY file you can print in .pdf. Install a "HP Color LaserJet PS" that print to "files". Download and install Ghostscript and Ghostgum (a gui for Ghostscript). Print the file using that virtual printer and it will create a .prn file. Using Ghostgum convert...
  14. Melko

    Add-on that adds the chance to manage cell color and background.

    Does it exist? Or it is already possible do, only with formulas enlarge, colorize or shink cell?
  15. Melko

    Conditional formatting help.

    I'll try to explain better... I have a long list of data and in the first column I have a date. 1/1/3 DATA DATA DATA ect. 2/1/3 DATA DATA DATA ect. 5/1/3 DATA DATA DATA ect. 5/1/3 DATA DATA DATA ect. 5/1/3 DATA DATA DATA ect. I made a formula that detects the change of the date alternating a 0...
  16. Melko

    Need a hatch pattern

    Probably you have to make it by yourself... try HACI
  17. Melko

    Conditional formatting help.

    I'd like to change a whole row background color if a cell value is odd or not. Is that possible?
  18. Melko

    Creating an original hatch

    Try HACI www.arbeit.ro/haci/ I used the free version that is already quite cool with simple hatchs, but if you need complex ones you should really buy it. It is not expensive and it works perfecly. Good luck.
  19. Melko

    Fast CSV columns sorting

    Thanks everyone, as lots said, there is no need of traspose. But the idea of make a list of number and sort using them is quite good and worked perfecly. I'll try to make a macro that add a new row write in it the numbers, sorts colunms and delete the row. Eng tips ROCKS!
  20. Melko

    Fast CSV columns sorting

    ivanlocke ideas seems good. Also pmover's one seems good... I'll try them both....

Part and Inventory Search

Back
Top