+ Reply to Thread
Results 1 to 2 of 2

Copy selection to .csv

  1. #1
    Registered User
    Join Date
    02-04-2009
    Location
    Red Rocks of Utah
    MS-Off Ver
    Excel 2004
    Posts
    4

    Copy selection to .csv

    Hello,

    I found the following macro to copy a selection of a worksheet and save as a .csv file using name in a cell reference as the file name. The problem is it work work on a mac, and from what I can find it has to do with the file filter.
    I have traced my issue to:
    FileFilter:="Comma Seperated Values (*.csv), *.csv)", _

    When I run the macro as written below I get =

    Run-time error '1004'

    Method 'GetSaveAsFilename' of object '_Application' failed

    Any insight is greatly appreciated!

    Thanks!

    Here is the code:
    Please Login or Register  to view this content.

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Copy selection to .csv

    see the tips here: http://www.rondebruin.nl/mac.htm#GetOpenFilename
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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