Results 1 to 5 of 5

Filename inludes " " around name when saving

Threaded View

  1. #1
    Registered User
    Join Date
    05-31-2006
    Posts
    58

    Filename inludes " " around name when saving

    I am saving a .csv to a .xls and regardless of what method I use to save it in a macro there are quote marks around the filename in the dialog box. This only appears to happen if I start with a .csv as I have tested it with a .xls and there is no issue. I have tried using the following code so far.

    Application.Dialogs(xlDialogSaveAs).Show (WkbkName)
    FileSaveName = Application.GetSaveAsFilename(fileFilter:="Excel Files (*.xls), *.xls")
    Last edited by Apel; 07-27-2009 at 08:41 AM.

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