| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA HELP! MsgBox & File & Sumif ******
which other post?
"Madiya" wrote: On May 20, 8:05 pm, alshiks wrote: Hi Everyone! Was anyone able to help with this? I need help with the following section from that query: " Is there any possible way to program in VBA in such way that when msgbox pops up at the very start and I just type in the file name "ABC123" Open up the correct file on correct month? i.e. A. if file name is ABC123 for this report then go to path 'C:\Documents \Database'\ABC123\ if file name is DEF456 then go to path 'C:\Documents \Database'\DEF456\ B. Then, if it is Jan-05 go to correct year folder under then open up correct xls file. i.e. 'C:\Documents\Database'\ABC123\2005\Jan 05.xls " Many Thanks! "James8309" wrote: Are B5:AO5 real dates, or strings of month/years? = I just typed Jan 05 in cell B5 then did autofill to AO5.- Hide quoted text - - Show quoted text - see your other post. Regards, Madiya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to generate a msgbox telling how large the file is | Excel Programming | |||
| clear the file now available msgbox | Excel Worksheet Functions | |||
| Pop up MsgBox upon opening Excel File | Excel Discussion (Misc queries) | |||
| Msgbox saying "Unable to read file" | Excel Discussion (Misc queries) | |||
| Display Current File Name in MsgBox | Excel Programming | |||
Threaded Mode
