Forum Discussion
Data from .xlsx files in folder
Hi, I just started exploring VBA, Macro, and etc. There is a folder on our server that purchase orders are saved in as their number and type. I.E. 25000-S, 25001-J, 25002-R, and so forth. I have tried to get data through query but it brings them in
with binary in column A, 25000-S.xlsx in column B, date created, last accessed, and so forth. What I need is for the contents of that folder to add data from specific cells on each p.o. as they are added. For example if I open either read only p.o. template, save it as 25004-M to Vendor A, and close it then I would want the p.o. number in G4 to go to the row following 25003 in column A, M same row column B, and Vendor A same row column E. What would the process be for getting the workbook that I manually enter these in to automatically update itself as new purchase orders were saved in the folder? Thanks for your time and any help you can offer.
with binary in column A, 25000-S.xlsx in column B, date created, last accessed, and so forth. What I need is for the contents of that folder to add data from specific cells on each p.o. as they are added. For example if I open either read only p.o. template, save it as 25004-M to Vendor A, and close it then I would want the p.o. number in G4 to go to the row following 25003 in column A, M same row column B, and Vendor A same row column E. What would the process be for getting the workbook that I manually enter these in to automatically update itself as new purchase orders were saved in the folder? Thanks for your time and any help you can offer.
No RepliesBe the first to reply