+ Reply to Thread
Results 1 to 1 of 1

Opening a .CSV as a separate document using VBA on MAC

  1. #1
    Registered User
    Join Date
    04-23-2016
    Location
    Milton Keynes
    MS-Off Ver
    15.19.1 2016
    Posts
    1

    Opening a .CSV as a separate document using VBA on MAC

    Hi all,

    I was wondering if anyone can help me with some code to open a file on macbook.

    I have a macro to process some data, basically i open my main workbook .xlsm and run a macro to open a .csv file. The macro then just copy's the data selected in the .csv and pastes it into my .xlsm workbook.

    The macro i've been using has worked perfectly on windows but now i've moved over to mac i can't get it to work.

    Here is the code i've used on Windows:

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Please Login or Register  to view this content.
    I'm unsure if there may be some errors that will carry over from windows other than this?

    My VBA is pretty basic and some of this code was written by a colleague who doesn't know how to help either. Hopefully a straight forward fix

    Cheers,
    Rob
    Last edited by 6StringJazzer; 04-23-2016 at 06:25 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 05-28-2014, 04:18 PM
  2. How to add Opening A WordPerfect Document
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2009, 12:24 AM
  3. Opening a document to a new window
    By chalky in forum Excel General
    Replies: 5
    Last Post: 05-11-2007, 03:33 PM
  4. [SOLVED] Opening a word document
    By RobH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-30-2006, 07:41 AM
  5. [SOLVED] Opening Protected XL Document
    By jo_peti in forum Excel General
    Replies: 0
    Last Post: 07-26-2005, 03:05 AM
  6. Opening a csv document
    By excel dummie in forum Excel General
    Replies: 0
    Last Post: 03-17-2005, 06:46 PM
  7. Do this when opening new document
    By semtex in forum Excel General
    Replies: 23
    Last Post: 01-08-2005, 10:32 AM

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