+ Reply to Thread
Results 1 to 2 of 2

Excel Automation from Access

  1. #1
    Sam Tyler
    Guest

    Excel Automation from Access

    I have data from an outside text file that I'm linking to in Access. I'm
    then using the Access VBA to create an Excel workbook (I was going to try to
    use TransferSpreadsheet, but the format and cell placement was too tricky).
    The problem is that when I try to set the Formula property from Access, it
    doesn't work. It just copies it as a string. I posted this in the Access
    Programming as well, but since I'm doing it from Access, it gets a bit
    complicated and I'm not sure exactly where it fits.

  2. #2
    Forum Contributor
    Join Date
    11-16-2004
    Posts
    282
    Hi Sam,

    Copy the following VB code into a module in MS Access. It will create an instance of Excel, create a new workbook and insert a simple formula into cell A1 of the new workbook:

    Please Login or Register  to view this content.
    Hope this helps,
    theDude

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1