MrRhodes2004
09-22-2014, 03:10 PM
Group,
I have a macro that I have been using for a while and has worked until recently. I do not know if something with Excel 2013 has changed or the ftp site that I am pulling from.
Cells(3,12) = ftp://ftp.dot.state.tx.us/pub/txdot-info/cmd/cserve/bidprice/as1458.txt
Code Snippet:
Dim Source as String
Source = Cells(3, 12).Value
Workbooks.Open source
When I open the file manually, it opens without issue. Now, when I try to open the file programmatically I get an error:
Microsoft Office Excel cannot access the file. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
I have tried adding the modifiers to Workbooks.open but I still seem to get an error.
Any thoughts or suggestions would be helpful.
Michael
I have a macro that I have been using for a while and has worked until recently. I do not know if something with Excel 2013 has changed or the ftp site that I am pulling from.
Cells(3,12) = ftp://ftp.dot.state.tx.us/pub/txdot-info/cmd/cserve/bidprice/as1458.txt
Code Snippet:
Dim Source as String
Source = Cells(3, 12).Value
Workbooks.Open source
When I open the file manually, it opens without issue. Now, when I try to open the file programmatically I get an error:
Microsoft Office Excel cannot access the file. There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.
I have tried adding the modifiers to Workbooks.open but I still seem to get an error.
Any thoughts or suggestions would be helpful.
Michael