Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington (Greater Manchester area)/Cheshire, UK
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Running macros in spreadsheers (Office 2000 SR1a)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Running macros in spreadsheers (Office 2000 SR1a)

    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.
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington (Greater Manchester area)/Cheshire, UK
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running macros in spreadsheers (Office 2000 SR1a)

    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

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Running macros in spreadsheers (Office 2000 SR1a)

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

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Warrington (Greater Manchester area)/Cheshire, UK
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Running macros in spreadsheers (Office 2000 SR1a)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •