017. Excel VBA for FOLDERS AND FILES (DIR and *) - Check if it exists, open and create new

Рет қаралды 485

2 жыл бұрын

This tutorial is focused on VBA codes for Files and Folders. You will learn how to:
- Check if the file or folder exists
- Create a new file or folder
- Open a file
Also, especially when you download a file a from a system, you might not know the full name of the file. We will learn how to use the * to avoid this problem
Channel content: Excel, excel tutorial, Microsoft excel, learn excel, how to use excel, excel basics, basic excel, ms excel, office 365, excel for dummies, excel functions, learn excel basics, microsoft excel for beginners, excel course, Mr Excel, excel help, microsoft excel tutorial, excel tricks, excel tips, excel guide, how to in excel, tricks in excel, tips and tricks, pivots tables, excel formulas, advanced techniques for excel.
#Excel #MsExcel #ExcelMacro

Пікірлер: 8

@omarrahim673 Жыл бұрын

Thank you very much. I have a question. I want a code to transfer files from one file to another. The file name is according to textbox1. It also accepts copying in rewriting this number on the one hand, and on the one hand, using the if function in this method

@EXCELWIZARDINMINUTES Жыл бұрын

Hello Omar! If I understand correctly, you want to copy a file from 1 folder to the next. In that case, use: Sub test() Set myFile = _ CreateObject("Scripting.FileSystemObject") Call myFile.CopyFile("C:\Users\abouj\Desktop\Excel sheets\Adverbs.xlsx", _ "C:\Users\abouj\Desktop\Excel sheets\Test\Adverbs.xlsx", True) End Sub 'You will replace the strings with the start path and the end path. You can modify this if statements and so on. hope it helps :)

@omarrahim673 Жыл бұрын

@@EXCELWIZARDINMINUTES Honorable sir, I have inserted a code, which is fso= scripting object and fso=new scripting object, from which the path was called, and the code succeeded, but there is an error that was overridden by a function

@omarrahim673 Жыл бұрын

@@EXCELWIZARDINMINUTES Dear Sir, I want a code that inserts the date and time in the file name or image and is based on a button and not a macro. Thank you very much

@EXCELWIZARDINMINUTES Жыл бұрын

@@omarrahim673 that is a bit more complicates for me to answer here. u have to do some research and use a code that renames a file and perform actions based on cell values.

@omarrahim673 Жыл бұрын

@@EXCELWIZARDINMINUTES Yes, sir, I did not write the code based on the cells of the excel sheet, but I relied on writing it based on the value of the search, which is textbox No. 1, and we thank you again for your response to us, good luck and all respect