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 strongm 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
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)
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...
