Running macros in spreadsheers (Office 2000 SR1a)

Topic

New Reply

Hi all!

I have a spreadsheet which contains a macro to convert the spreadsheet into a PDF document using Acrobat’s PDFWriter and it works perfectly in Excel.

Now what I am currently doing is opening the spreadsheet in Access by means of an Excel object and then running the macro to convert the spreadsheet to PDF and then closing the spreadsheet.

Problem is that I get an error message saying that Acrobat is not installed and that I must please install Acrobat’s PDFWriter. I know that I got the same error message in Excel until I set the Reference to Acrobat PDFWriter, but I can’t find the Acrobat PDFWriter under the References in Access.

Does anyone know how I can force Access to refer to Excel’s References when running an Excel macro inside an Excel object?

Thanks

James

Reply | Quote

Replies

I think you’re going to have to use the Browse button in Access to find the file Excel’s references are using. You can’t make one application use the references for another.

Reply | Quote

Hi Charlotte

Thanks for the information, I suspected as much about the lack of inter-application operability for references. I did try the browse option, but since the PDFWriter’s code for Excel exists in a XLA file and Access is unable to utilize it, that option is not available either.

Anyone else got any ideas or pointers?

Thanks

James

Reply | Quote

You can’t set a reference to it even if you select the All Files option for file type under browse?

Reply | Quote

No – Access is beeing pathetic not and allowing the XLA file to contain references or its not recognising the references in the XLA file.

Reply | Quote