+ Reply to Thread
Results 1 to 4 of 4

code for opening a file

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    code for opening a file

    Isn't this code supposed to open a file? It's not working. There is no error but it doesn't open file but then debugs on line input.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: code for opening a file

    Shouldn't #FileNumber be #1 ?

    Hope this helps.

    Pete

  3. #3
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: code for opening a file

    Quote Originally Posted by Pete_UK View Post
    Shouldn't #FileNumber be #1 ?

    Hope this helps.

    Pete
    I would agree with that or FileNumber is a variable that = 1.
    I don't see it declared in this code, so you should check if it has a value if it's a public variable declared somewhere else.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  4. #4
    Forum Contributor
    Join Date
    10-13-2012
    Location
    Southern California
    MS-Off Ver
    Excel 2007
    Posts
    401

    Re: code for opening a file

    I answered this question in your original post.

    http://www.excelforum.com/excel-prog...ng-a-file.html

+ 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. code for opening a file
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2015, 07:10 PM
  2. [SOLVED] Opening PDF file via code
    By MarmaladeLover in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2014, 09:19 AM
  3. [SOLVED] VBA code for opening a file with a variable version number in the file name
    By trishcollins in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2014, 04:38 PM
  4. [SOLVED] VB Code to copy without opening the file
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-05-2013, 08:24 PM
  5. [SOLVED] Error in code - play music file automatically after opening file
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-15-2013, 10:06 AM
  6. [SOLVED] VBA-code for opening a file max x times
    By Saturn in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-03-2013, 09:43 AM
  7. [SOLVED] Code for opening file if match with file name is found
    By cokillerliu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-25-2013, 08:41 PM

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