Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inputbox to import file
Greetings,
Target: append data to a table from a daily file is saved in a folder with name and date, "fileYYMMDD.csv" Problem: "sometimes" the sub-routine works, others doesn't: 1004 Run time Error, the file could not be found. In my laptop works flawlesly, and in the office sometimes works but I coun't not isolate the variable to determine the bug. Would you please help me with this challenge? Thank you. This is the routine I am using: Sub Name() Dim NextRow As Long NextRow = Range("B65536").End(xlUp).Row + 1 mybook = InputBox("Enter File Name to Open:", "imYYMMDD.csv Format") If mybook = "" Then Exit Sub Application.ScreenUpdating = False Application.DisplayAlerts = False Workbooks.Open FileName:=mybook ChDir "C:\Whatever path\Folder" Range("B1:B10") = "=Today()*1" Range("B1:D10").Copy Workbooks(mybook).Close ThisWorkbook.Activate Cells(NextRow, 2).Select ActiveSheet.Paste End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
How do I import text file, analyze data, export results, open next file | Excel Programming | |||
Import Data with the filename coming from inputbox ? | Excel Programming | |||
inputbox vs. userform/combobox vs. Windows file handlers ??? | Excel Programming | |||
Import text file into excel with preset file layout, delimeters VBA | Excel Programming |