1. All the data files are emailed to me. Currently I save them in different places.
C:\FlexibakeConversions\Data
C:\Albany\data
C:\midstate\data
C:\ahold\Data
C:\kkb\data
2. C:\midstate\data\08.15.20_Recap.xlsx
C:\ahold\Data\0056919000647_0004353672.csv
C:\FlexibakeConversions\Data\HEIDELBERG-INVCR092220.csv
3. .xlsx
.csv
Not a bad file system, but I strongly recommend that you reverse the Folder names and place all inputs in subfolders of "Data". That would make it much easier to code and easier to backup and easier to move when the time comes. You can also think about adding a SubSubFolder "Archive" to each SubFolder
Other than the editorializing in re Locations, note the details below
Client
|
Data Store Location |
File Name Patteren |
File Type |
Flexibake |
C:\Data\Flexibake |
HEIDELBERG-INVCR & 5 digit number |
csv |
Albany |
C:\Data\Albany |
? |
? |
midstate |
C:\Data\midstate |
DateFormat("mm.dd.yy") & _Recap |
xlsx |
ahold |
C:\Data\ahold |
13 digit numer & _ & 11 digits number |
csv |
kkb |
C:\Data\kkb |
? |
? |
? |
C:\Data\? |
? |
? |
? |
C:\Data\? |
? |
? |
|
|
|
|
Can you fill in the blanks above So I can start a Workbook for this Project? Also tell me what you intend to do with the Location directory tree.