Results 1 to 5 of 5

Unable to detect CSV file.

Threaded View

JapanDave Unable to detect CSV file. 09-28-2011, 08:35 PM
tigeravatar Re: Unable to detect CSV file. 09-29-2011, 06:35 AM
JapanDave Re: Unable to detect CSV file. 09-29-2011, 09:05 AM
tigeravatar Re: Unable to detect CSV file. 09-29-2011, 09:08 AM
JapanDave Re: Unable to detect CSV file. 09-29-2011, 09:14 AM
  1. #1
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Unable to detect CSV file.

    I have some code that prompts you to select a file to extract data from, but when I open the folder with the CSV files it is empty, but if I have a normal ".xls" file it detects it fine. The code worked on my previous PC which was Vista, butI just upgraded my PC to Windows 7 and Office 2010. Could this be the cause, or is the code not working the way it should?

    Static wbDataPath As String: wbDataPath = Application.GetOpenFilename("Excel Files, *.xls*")
        If wbDataPath = "False" Then Exit Sub
    Last edited by JapanDave; 09-29-2011 at 09:14 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