How do I Print multiple spreadsheets at once without having to sa.

[Guest]

Good afternoon all,
I am trying to print about 230 excel spreadsheets. I performed a custom
search using windows search, selected files I need printed, and then
drag-n-drop to the printer of choice. However, each file opens up in Excel
and prompts me to save changes before moving to the next file.

Is there a way to print them w/out being prompted to save? I don't look
forward to clicking no 200 times.

Dawson
:\

 

[Guest]

not sure if this will work or not, but have you tried

Application.DisplayAlerts = False

alternatively, if you're utilizing VBA to print these, you could use the
following on workbook close:

activeworkbook.close savechanges=false 'or true if you prefer

hope this helps!
-chad

 

[Guest]

Hey Chad,
I am selecting all the excel files and dragging them to the printer icon. I
am not utilizing VBA. I just want to mass print ïŠ

Dawson

 

[Earl Kiosterud]

Dawson,

There may be volatile functions (like RAND()) in a worksheet.

Try this. Start Excel. In Tools - Options - Calculation, set calculation to manual. Leave
the new empty workbook open. This stupidly sets the calc switch to manual for all
subsequently opened workbooks, possibly a boon in your situation. Now try your print. I
used the Print command in the right-click menu with selected files in a folder, and didn't
test this by dragging into a printer as you're doing.

Don't let the workbooks actually get saved, as they'll get saved with the calc switch set to
manual. No one knows why it's this way, and it's rumored that it'll be fixed in 2057.

 

[Bruce Sinclair]

Dawson,

There may be volatile functions (like RAND()) in a worksheet.

Note that there are other volatile functions that do this too of course ...
=today() is the one I'm thinking of. If I open a file with that in and print
it (only, not even a cursor move else), XL tells me there are changes I need
to save. Nice work around

 

[Guest]

I felt I was close, too! I set the options per the previous post.

The error message says:

Do you want to save changes to xxxx.xls?
Microsoft Office Excel recalculates formulas when opening files last saved
by an earlier version of Excel.

Dawson

 

[Earl Kiosterud]

Bruce,

Guess it's time to write some code.