Disable PDF in Excel

C

crapit

I mean disable PDF from starting up in Excel. How to I set the page setup
paper size to A4 as default?
 
M

Myrna Larson

Not sure what you mean WRT "[disabling] PDF from starting up in Excel", but
Acrobat 6 puts file named PDFMaker.XLA in your XLSTART directory. If you
remove that file, you won't see the Acrobat toolbar, but you can still create
a PDF by "printing" to the Adobe PDF "printer".
 
S

Stan Scott

The default templates used by Excel are called Book.xls and Sheet.xls. If
you create these files then you define your own default workbook and
worksheet, which will appear each time you open Excel or add a new
worksheet. You can set these XLS files with all of your default settings,
including page size.

The files must reside in the XLStart folder, which is in
....\user_name\Application Data\Microsoft\Excel\XLStart.

Stan Scott
New York City
 
T

Tom Ogilvy

If excel can open your file, then I would guess it isn't really a PDF.

Sounds like you need to edit your file associations in window's folder
options.
 
C

crapit

I removed the PDFmaker.xla but excel still load it.
Myrna Larson said:
Not sure what you mean WRT "[disabling] PDF from starting up in Excel", but
Acrobat 6 puts file named PDFMaker.XLA in your XLSTART directory. If you
remove that file, you won't see the Acrobat toolbar, but you can still create
a PDF by "printing" to the Adobe PDF "printer".
Click to expand...
 
C

crapit

For starting, it refer to the book.xls in the XLStart folder. But what about
subsequent workbook?
 
D

Dave Peterson

Does this mean you're double clicking on a .pdf file in windows explorer and
excel is opening it?

If yes, then one way to reset the file assocation for .pdf (like Tom mentioned)
is to reinstall adobe reader.

If you can't reinstall Adobe Reader, you may want to shift rightclick on a .pdf
in windows explorer and choose "Open With".

Choose "adobe reader" (you may have to browse for it) and make sure you click
the "always use this program to open this type of file".

If this isn't what you meant, post back with some more details--including how
you open the .pdf in excel.
 
C

crapit

I mean with the PDF plug-in for excel!
Dave Peterson said:
Does this mean you're double clicking on a .pdf file in windows explorer and
excel is opening it?

If yes, then one way to reset the file assocation for .pdf (like Tom mentioned)
is to reinstall adobe reader.

If you can't reinstall Adobe Reader, you may want to shift rightclick on a ..pdf
in windows explorer and choose "Open With".

Choose "adobe reader" (you may have to browse for it) and make sure you click
the "always use this program to open this type of file".

If this isn't what you meant, post back with some more details--including how
you open the .pdf in excel.
Click to expand...
 
R

ross

Hi

Maybe this will help?


For i = 1 To AddIns.Count
Sheets(1).Cells(i, 1).Value = Application.AddIns(i).Path
Next i

put this code into a button on sheet 1 and find the PDF file then go
to the dir and delete it. Remove the add ref from tools>add ins and
close excel.

Hopfully this should work, if not you might have a virus?


good luck
ross
 
C

crapit

Finally it work by shift the pdfmaker.xla to other location from
C:\Documents and Settings\user\Application Data\Microsoft\Excel\XLSTART
C:\Program Files\Adobe\Acrobat 6.0\PDFMaker\
 
Top