If you would like to link all Dbase files, any linkable file for that matter, in MS Access, use the following code. I read somewhere that refreshing the links is slower than deleting and creating new links. Sub LinkAllTblsinDir() Dim sTblNm As String, sPath As String, sFileNm As String sPath = “C:\DW\” ‘Turn of the […]
Continue readingIf you want get or print file names from a certain directory, then you can use following code. Sub GetFileNames() Dim sPath As String, sFileNm As String sPath = “C:\DW\” ‘You can also use Application.GetOpenFilename to get a file name from a folder, ‘and then extract the Directory name from that string ‘You can also […]
Continue readingProblem Are you frustrated that you have to concatenate a big range of cells in Excel, but you have to do so using CONCATENATE function by entering each cell and typing a comma after every cell? Well, here’s a solution to it. A procedure or a function whatever you like. If you use the procedure, […]
Continue readingI didn’t know this before today when an user at MrExcel wondered why he was not getting consistent answers with Excel and VBA. The key is negative numbers. If you happen to have negative numbers (one of them) and you want to calculate MOD, you should use this code in VBA yourmodval=n-d*INT(n/d) Where n is […]
Continue readingIf you want to change references of a formula, you could toggle F4 key inside the formula to change the references from Absolute, Column Absolute Row Absolute or all relative. Although, if you have to change references from a range, you can use these two options1. Download ASAP utilities, because it’s worth it, they have […]
Continue reading