RE: Disable Adobe save file prompt

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'm not clear on what the "pop up" does. Without knowing, I might suggest
putting this before and after the save and see what it does

Application.DisplayAlerts = FALSE 'before
Application.DisplayAlerts = TRUE 'after
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"JumboShrimps" wrote:

Using full Adobe Acrobat Standard (not Distiller) 7.0 with Excel
2000.

Have over 2,000 pdf's to generate every month.

Process runs on three separate computers fetching data across
SQL server simultaneously.

After Excel spreadsheet is opened, current VBA code
A) connects to SQL Server and returns data based on ID of office.
B) Populates cells within four tabs on spreadsheet with
data specific to that office.
C) Output data to ind.pdf file on shared drive for others to access.
D) Fetch next office's data on SQL server.
E) process begins again until all 2,000 pdf's are created.

Each PC is assigned to generate different sets of
offices so there's no file writing conflict.

For some reason, the code bombs out and the selection to
output in PDF is lost, output is sent to default printer instead.

Used the Application.Activeprinter code posted in this group
making sure the printer is set back to Adobe Acrobat before
printing begins for each set of office data fetched.

On my own computer the first time I selected Adobe Acrobat as
the print device for this spreadsheet, and set save-file-to the
shared drive (and some other settings), the settings
were somehow hard coded into Excel, so Excel knows
when I select Adobe Acrobat, PDF's go to the shared drive.
Never had to uncheck the boxes about fonts, etc
or tell Adobe where to save the files

However, the other two computers -
used mostly for processes like
this and have no one working on them in between,
always prompt for saving the file once the code begins
to write out the PDF file,
(and some other check box's
like fonts have to be clicked again).
All computers are running Excel 2000 on Windows XP sp2.

VBA code, of course sets the directory and pdf file name,
after the data is fetched,
but the other two computers generate the Adobe prompt
when the code starts to output PDF file.

Is there any way to either disable the Adobe pop up,
or use code to tell Adobe what settings we need without
the popup?

Adobe SDK group was not helpful and sources
like PlanetPDF are absolutely worthless.




.

Relevant Pages

  • Re: how can I copy information from adobe into excel?
    ... On typical PDF files however, you can just click on the Adobe Select tool and then use the mouse to select what you want, and do a copy/paste in the normal way. ... Or a really crude approach is to directly load the PDF file into Excel as you would any text file. ...
    (microsoft.public.excel.misc)
  • PDF wont open from excel file
    ... I have a link to a local PDF file in ... This PDF file will open fine from Adobe or from my documents, ... but when I click on the link in excel, the screen flashes momentarily, ...
    (microsoft.public.excel)
  • How do I see PDF comments in Excel insert object
    ... I open a new Excel worksheet, Insert, Object, Adobe, I select a pdf file, the ... preview shows up in Excel as a hatched picture, ...
    (microsoft.public.excel.misc)
  • Disable Adobe save file prompt
    ... Using full Adobe Acrobat Standard 7.0 with Excel ... Process runs on three separate computers fetching data across ...
    (microsoft.public.excel.programming)
  • =?windows-1252?Q?=28Bloomberg=29_=97_Adobe_Systems_Inc=2E_is_overhauling_th?= =?windows-1252
    ... Chief Technology Officer Kevin Lynch plans to release what Adobe calls ... its Creative Cloud software package early next year. ... in his San Francisco office, surrounded by the six computers, two ... Creative Cloud will move Adobe tools including the Photoshop photo- ...
    (alt.coffee)