Consulting

Results 1 to 1 of 1

Thread: "Run-time error '1004' with .xlt file

  1. #1

    "Run-time error '1004' with .xlt file

    Hi everyone

    I copied a template sheet excel from PC1 to PC2 .
    ( PC 1 use Windows 7 and excel 2007 ) , ( PC2 use Windows 10 and excel 2016 ) .

    But I can't run it on PC2 , it was show a message error
    "Run-time error '1004' Sorry, we couldn't find E:\Workzone\A566-z349b\zoneinfo.csv . Is it possible it was moved, renamed or deleted? "

    It always appear error, but if i create a folder name A566-z349b, it is okay .
    My file type is .xlt file ,but I can't upload it , so I changed it to .xlsm file

    I attached file template , please check it and let me know why


    Public Sub ReadCsv()


    Dim SaveSheet As String, SaveWindow As String

    SaveSheet = ActiveSheet.Name

    Worksheets("TempSheet_I").Activate
    Range("A1").CurrentRegion.Select
    Selection.ClearContents
    Cells(1, 1).Select

    Workbooks.Open Filename:=pCsvPath (This line appear bug, pCsvPath = E:\Workzone\A566-z349b\zoneinfo.csv )
    Range("A1").CurrentRegion.Select
    Selection.Copy
    ActiveWindow.WindowState = xlMinimized
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •