Consulting

Results 1 to 3 of 3

Thread: Solved: Maybe Excel is not the problem

  1. #1

    Wink Solved: Maybe Excel is not the problem

    I originally posted my problem in the Excel forumsorry,cant post the link)
    the thread is
    "cant open xls file saved from outlook using vb"

    In short I have users that will recieve data as an attachment in Outlook.
    The code I use looks in outlook for specific subject and when found copies the attachment to the harddrive.

    The problem comes with the automated open of the saved xls file.

    I get a message "Unable to get the open property of the workbook class".

    I've noticed that the size was originally 358kb, in outlook as an attachment the size is 364kb and when the code run that copies the attachment to the harddrive the size is 360kb. Manually saving from outlook give an increased file size also.

    I get the error with the 360kb file on the harddrive. I can manually open the saved xls file. If I open the saved file and do a save, without any changes, the file size is 358kb.

    The code to open and save as a csv file then works.

    I list all the code in the original post.

    Hoping someone can point me in the right direction. I'm using Office 2003, and XP sp2.

  2. #2
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  3. #3
    the solution is, I'll have to settle for a workaround.

Posting Permissions

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