+ Reply to Thread
Results 1 to 12 of 12

ExecuteExcel4File Doesn't see the file

  1. 06-03-2018, 04:32 AM #1
    mheyecan
    mheyecan is offline
    Registered User
    Join Date
    06-03-2018
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    6

    ExecuteExcel4File Doesn't see the file

    Hello,

    I have tried the create code that will take datas from daily reports on folder that has name Report 01.05.2018.xlsx,

    when i manully type the data to code 

    Please Login or Register  to view this content.
    the code works just fine. But when i try to read the file name from parameter

    Please Login or Register  to view this content.
    Here is the whole script.

    Please Login or Register  to view this content.

    Thank You !
    Reply With QuoteRegister To Reply
  2. 06-03-2018, 07:27 AM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: ExecuteExcel4File Doesn't see the file

    When does it fails .. when day number is greater than 9 ??
    What is the result for
    "Aden Çatı Kaplama Günlük Faaliyet 0" & FileDate
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  3. 06-03-2018, 08:15 AM #3
    mheyecan
    mheyecan is offline
    Registered User
    Join Date
    06-03-2018
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    6

    Re: ExecuteExcel4File Doesn't see the file

    Nope, for tracking i am overwriting the FileDate parameter as

    Please Login or Register  to view this content.
    so it is returning Aden Çatı Kaplama Günlük Faaliyet 02.05.2018.xlsx
    Reply With QuoteRegister To Reply
  4. 06-03-2018, 08:26 AM #4
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,652

    Re: ExecuteExcel4File Doesn't see the file

    You got wrong path separator.
    It is not "/".
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 06-03-2018, 08:30 AM #5
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: ExecuteExcel4File Doesn't see the file

    so it is returning Aden Çatı Kaplama Günlük Faaliyet 02.05.2018.xlsx
    and for 11 what is the result, it ??
    Reply With QuoteRegister To Reply
  6. 06-03-2018, 09:31 AM #6
    mheyecan
    mheyecan is offline
    Registered User
    Join Date
    06-03-2018
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    6

    Re: ExecuteExcel4File Doesn't see the file

    Hello again,

    I am using IOS "/" works when i manullay write the file name.
    i know it seem odd but parameter returns the right number

    when FileDate = 10 ** i will add if state and change the 0 with 1 ofter file date 9 but for now i manually change


    Ekran Resmi 2018-06-03 16.16.25.png
    Ekran Resmi 2018-06-03 16.26.14.png
    Last edited by mheyecan; 06-03-2018 at 09:33 AM.
    Reply With QuoteRegister To Reply
  7. 06-03-2018, 10:29 AM #7
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: ExecuteExcel4File Doesn't see the file

    You can use

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 06-03-2018, 10:34 AM #8
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: ExecuteExcel4File Doesn't see the file

    Have you dpne step by step a debugging of your code ?
    At which statement it fails ?
    Reply With QuoteRegister To Reply
  9. 06-03-2018, 10:51 AM #9
    mheyecan
    mheyecan is offline
    Registered User
    Join Date
    06-03-2018
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    6

    Re: ExecuteExcel4File Doesn't see the file

    Nope, i will try and update.
    Last edited by mheyecan; 06-03-2018 at 10:53 AM.
    Reply With QuoteRegister To Reply
  10. 06-03-2018, 11:22 AM #10
    mheyecan
    mheyecan is offline
    Registered User
    Join Date
    06-03-2018
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    6

    Re: ExecuteExcel4File Doesn't see the file

    Now it finds some the files but not all of them and integer i starts from 31th which i dont know why

    Ekran Resmi 2018-06-03 18.19.12.png
    Reply With QuoteRegister To Reply
  11. 06-03-2018, 11:31 AM #11
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: ExecuteExcel4File Doesn't see the file

    What is the code modification to get some improvements ?
    When you go step by step for the loop have watch the variable I, FileDate etc ...
    Are the values correct : Use the watch window to display values
    Reply With QuoteRegister To Reply
  12. 06-03-2018, 11:39 AM #12
    mheyecan
    mheyecan is offline
    Registered User
    Join Date
    06-03-2018
    Location
    Istanbul
    MS-Off Ver
    2016
    Posts
    6

    Re: ExecuteExcel4File Doesn't see the file

    format( FileDate,"dd") helped me to improve
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Moving file doesn't work for Arabic file names
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-08-2018, 07:52 AM
  2. If file exists, run a particular macro, if it doesn't, look for another file
    By tim120harvey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-04-2011, 12:28 PM
  3. Shared File doesn't exist
    By rvancura32 in forum Excel General
    Replies: 0
    Last Post: 02-09-2009, 01:19 PM
  4. xls spool file doesn't automatically link to new xls file
    By zimon72 in forum Excel General
    Replies: 0
    Last Post: 01-19-2006, 04:23 AM
  5. [SOLVED] Double-clicking .xls file opens Excel but doesn't open the file
    By DG in forum Excel General
    Replies: 4
    Last Post: 01-05-2006, 10:25 PM
  6. [SOLVED] clicking .XLS file opens Excel 2003 but doesn't find the file
    By Arrow Computer in forum Excel General
    Replies: 2
    Last Post: 08-09-2005, 11:05 PM
  7. Personal.XLS file doesn't remain with Excel file when emailed
    By Dianne & Shane Bursey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2005, 03:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1