| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert every xls file in a folder to csv
Andrew and MArk thanks everything works great now.
Andrew Taylor wrote: This is probably because it's looking in the wrong directory: the FIleNames() array doesn't contain the full path, so VBA is trying to find it in whatever it thinks is the current directory. Try Workbooks.Open FileName:=ThisWorkbook.Path & "\" & FileNames(i) JI wrote: I am getting an error at this part: Workbooks.Open FileName:=FileNames(i) the message is that it cant find the file and to make sure the directory or name hasn't changed, it has the file name included in the message. I think the code works to collect and store all the files, it just is having problem going back to the list to open the files. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
| open file from folder save in new folder | Excel Programming | |||
| Create Folder and Text File in folder | Excel Programming | |||
| Move file to different folder | Excel Programming | |||
![JI[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
