Search results for query: *

The following code from PHV a few years ago is great for making a new directory when more than one sub folder may need to be created. Sub myMkDir(strFolderName As String) On Error Resume Next Dim a, t As String, i As Integer a = Split(strFolderName, "\") t = a(0) For i = 1 To UBound(a) t = t &...

I have a spreadsheet on the network for other users and someone changed the columns from A,B,C... to 1,2,3... This results in column A1 being identified as R1C1. A standard formula: =SUM(C5:C54) is now =SUM(R[-50]C:R[-1]C). My questions are how did someone make this change and how can I...

This is probably the easiest question of the day, but I cannot fine a way to open an existing Excel spreadsheet with the click of a command button. Any help would be greatly appreciated!

Is there any way to have a message box pop up AFTER ALL additions or changes are entered on both a main form AND a subform? I realize that when you move from a main form to a subform Access automatically saves the current record before changes can be made to the subform. However, to the user...

The following code works fine in Access 2000/Windows 2000: With Application.FileSearch .NewSearch .LookIn = strMoveFrom .SearchSubFolders = False .LastModified = msoLastModifiedToday .FileType = msoFileTypeAllFiles .Execute msoSortByFileName More...

I have a simple app that copies files from one location to another. The file names to be copied are listed in an array (myList) and error trapping is in place that generates a message box EACH time a file is not found. Question, instead of a message box for every file not found, is it possible...