myfolder

I am experiencing some issues that Excel reportingrun-timer error "5" when assigning Outlook <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo...

the issue is that the code is is deleting more than i ask for. it also deletes a cell that is not colored. Sub delete_test_2() Dim MyFolder As String Dim cell As Range Application.ScreenUpdating = False With Sheets("Delete Revs") MyFolder = .Range("K1").Value & "\" For Each cell...

I am trying to delete old files from a folder. file names are in column C and old files are colored RGB(255,0,0) i get an error when running this code." file not found". i tried peacing different codes together but, i'm still learning. Sub Delete_test() Dim MyFolder As String Dim MyFile As...

I have code to open 1 of multiple folders, depending on the selection. Previously it worked like a charm. Now it hangs on MyFolder. I have no idea what is wrong. I have trouble shot it, & it hangs on the same location. Here is the code: Sub Partner_Resources()Dim MyValue Dim i As String...

I would like to have a code that will search the items in my listbox. The search should not be case sensitive. This is my code Private Sub UserForm_Initialize()Dim MyFolder As String Dim MyFile As String Dim j As Integer MyFolder = "C:\Test" MyFile = Dir(MyFolder & "\*.xls") Do While MyFile <>...

Hi Everyone, I have the macro below on a button in a worksheet and I want it to open "C:\Users\HOME\Dropbox\DSR DAILY IMPORT" so we can select a file which it does BUT it also opens "My Documents" folder as well? I'm not seeing why that is happening? Thank you! ​Sub Macro1()<code...

I have a macro to search duplicate file name in excel file (LogFile.xlsx). If found show it on macro file (SearchDuplicate.xlsm) otherwise insert the file name in logfile. Please !! help ! Sub Button1_Click() Dim MyFolder As String, MyFile As String Dim LastRowLogFile As Long, m As Long Dim...

This code works in early binding: Dim fso As Scripting.FileSysemObject Set fso = New Scripting.FileSystemObject Dim MyFolder As Folder Set MyFolder = fso.GetFolder("C:\MyData") Dim Num As Integer Num = MyFolder.Files.Count To change to late binding, how do I declare MyFolder? For...

Hi there, I've got 13 files in directory (SMA (1).xlsm to SMA (12).xlsm plus "Data File.xlsm". I need to write code that opens each file (except one called "Data File.xlsm") runs "macro 3" in each file (same name in each file) and after that closes each file after saving changes. I have written...

I have a code that changes the name of the most recently saved file in the folder to StandardFileToImport.txt, and then imports the contents it into excel every 10 seconds. This works fine on the computer where I originally made the code, but when I try it on several other different computers...

Hi I need help i haven't been able to work out the best way to do this: refresh a formula in myworkbook >>> check to see if a list of file names in my worksheet match the files that are in the same folder >>>if they are, then put a yes next to the file name cell and also put the number of...