Re: create an acess report from multiple exel files ...Excel files have different names. ... If you have an Access .mdb file with links to each/all the spreadsheets, ... stored in folders by month order. ... At the end of the month, I need to make a report giving:... (microsoft.public.access.reports)
Re: Can not open excel files without open application ...~Anne Troy... > I need help to open my Excel files in desktop, ... > folders.... > try to open Excel in an other folder then it launch Microsoft Office... (microsoft.public.excel.misc)
Can not open excel files without open application ... I need help to open my Excel files in desktop, ...folders.... I have acces to my files only on application by FILE, ... try to open Excel in an other folder then it launch Microsoft Office 2000. ... (microsoft.public.excel.misc)
Re: macro to move from directory to directory ... The first code looked for the folder names in column A and the workbook names in ... > find the files in the folders.... I did change the default location to save Excel files... (microsoft.public.excel)
Public Const on a Drive ... I have a series of excel files located in a folder called ... Winthin that MasterFolder,... Since all the files within these folders are all linked by macros, ...Public Const to identify my directories instead of having to retype the full ... (microsoft.public.excel.programming)
