myfile

Hello, I have a "Main" file where in "Data base" sheet I store location of a folder containing Excel files I would like to loop/open/copy data and paste back to "Main" file. When I try to Open the file from a folder, it opens but right after I receive Run-Time Error 424. Could you please help...

Hello All I am trying to write one macro to run on 3 files inside a folder. Code is written but it copies data and overwrites in the same range for next files. I want data from source file to go in target file range G5:G32 for 1 st file/E5:E32 for second file and F5:F32 for third file. Each...

hi! I'm working on a code that enables the user to choose a file and if that file happens to be a csv-file, make some modifications to it. Also the chosen file should be added to the end of the workbook. But as you can imagine my code does not work Dim wb As Workbook Dim myfile As Variant Set...

Hi Guys,<o:p></o:p> <o:p></o:p> I’m trying to open the latest .csv file from a folder using vba andthen to copy and paste some of the columns from the csv into a spreadsheet thatI have. The code that I ams using worksfine to open the lastest csv but once it copies ans pastes the data formatting...

I have a calendar in excel populated with a years worth of dates. I would like to be able to check for a file based off of the date in the cell and then change the color of the cell based on if that file exists or not. I was able to create the following code but i am not sure how to get it to...

Hi all, I'm fairly new to VBA and have been trying to muddle together a VBA macro to basically select a predefined folder, open any workbooks within that folder (ideally, i wouldn't even open the workbooks if possible but thought this would be far to complex for me starting out) and copy and...