Search results

Hi All, I currently have an Access VBA module that browses for a folder name using Getfolder (SHBrowseForFolder function), then gets a list of all the Excel files in the chosen folder using Dir(folder & "\*.xls") and opens and processes each file in turn using Excel Automation. Can anyone tell...

Hi Guys, Has anyone got any experience of using the SHBrowseForFolder function to get a Web Folder path. With what I have got so far, it will sometimes, but not always, show the Web Folder structure in the Get Folder window but even when it does, the return value only gives the folder name, not...

Apologies if this has been asked before …. I have not been able to find an answer for it in the forums. I have a fixed format, single page, report with many fields on it, several of which are Memo fields. On some occasions, the report field is insufficiently sized to take all the text and I...

Hi Guys, Apologies if this has been asked before …. I have not been able to find an answer for it in the forums. I have a form with in excess of fifty text boxes on it (actual & forecast spend by month, subcategorised by operational and capital spend, with totalling to give total forecasted...