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.
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?
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?
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
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...
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?
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 :)
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...
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...
