|
|
#10
09-03-2018, 12:13 AM
|
||||
|
||||
Put a break point (or a Stop instruction) directly after this line (or its equivalent):
MyFileName = CurrentWB.Path & "\QBOUploads\" & Sheets("Analysis").Range("I1").Value & Format(Now(), "dd-mm-yyyy") & ".csv" Then when the code reaches that point and stops, type the following in the Immediate pane and press Enter: ?MyFileName Do you get a correct file name and path? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Entering a column value in a cell, to be used as part of a reference in a formula in another cell
|
paulkaye | Excel | 4 | 02-26-2017 04:18 AM |
| entering name in outlook does not autofill | Franksplace2 | Word | 0 | 03-08-2015 04:10 PM |
|
entering duration in months
|
ketanco | Project | 1 | 12-17-2014 01:09 PM |
|
entering lump sum costs
|
ketanco | Project | 1 | 12-24-2011 12:56 PM |
| Entering Contact details | GemmaD | Outlook | 0 | 12-18-2008 06:41 AM |
Windows 10 
Office 2016
Threaded Mode