+ Reply to Thread
Results 1 to 6 of 6

macro adjustment required - importing file into excel 2007

  1. #1
    Registered User
    Join Date
    01-16-2012
    Location
    perth
    MS-Off Ver
    Excel 2007
    Posts
    3

    macro adjustment required - importing file into excel 2007

    Hi

    Very new to excel 2007. I have the following piece of code that allows me to import and array the data in excel 2003 but does not work for excel 2007. Does anybody have any ideas?


    Please Login or Register  to view this content.

    Thank you in advance


    Matt
    Last edited by TMS; 01-16-2012 at 04:14 AM. Reason: Added Code Tags

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: macro adjustment required - importing file into excel 2007

    Please attach the text file so we can test it at our end.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    01-16-2012
    Location
    perth
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: macro adjustment required - importing file into excel 2007

    It won't let me upload the file. Not sure if this is against forum rules but if you PM me your email address I can send you both files

    Cheers

    Matt
    Last edited by mattyk; 01-16-2012 at 04:10 AM.

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: macro adjustment required - importing file into excel 2007

    You can try zipping the file and then uploading it. Its better you upload the file here so that others too can assist you.

  5. #5
    Registered User
    Join Date
    01-16-2012
    Location
    perth
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: macro adjustment required - importing file into excel 2007

    per attached

    Cheers

    Matt
    Attached Files Attached Files

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: macro adjustment required - importing file into excel 2007

    Are you getting any error msg while importing it in 2007?

+ 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