Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using “Application.DisplayAlerts = False gives ”Method or Data Member not found" compile error
Thank you MakeItSo for the explanation and the code. It worked perfectly! You too combo, thank you for your comments!- Calhoun99
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Using “Application.DisplayAlerts = False gives ”Method or Data Member not found" compile error
I have a module in Access to format cells in an Excel spreadsheet. Sub FormatData() Workbooks.Open FileName:="C:\Users\john.doe\Documents\scripts\apps\allow\Weekly_Cash_Trending" Workbooks("Weekly_Cash_Trending.xlsx").Activate Columns("C:C").Select Selection.NumberFormat =...- Calhoun99
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA code to re-name a text file, execute a macro, then repeat (for all files in a folder)
the tmp = Dir will repeat for that specific file, and return an empty string when all files are renamed, which is your exit condition - the code loops correctly. For all file in the specified folder. :-) -
VBA code to re-name a text file, execute a macro, then repeat (for all files in a folder)
This was resolved by removing the If Len(Dir(...)) condition. Using Dir inside the loop breaks the Dir outside the loop. Corrected code below. Function process() ' Dim tmp As String tmp = Dir("C:\Users\Calhoun\Documents\REPORTING\Correspondence\*.txt") Do While tmp > "" on error... -
VBA code to re-name a text file, execute a macro, then repeat (for all files in a folder)
I am very new to VBA, so please be patient. I need to to re-name .txt files in a folder to a file name that never changes (it is linked as a table in Access). Run a macro that scrapes data into another table, then repeat the process for all the files in the folder (loop). The code below renames...
