Hi, I've got a total of 3 files I'm working and I want to save one of them in the current folder.
For starters, I am brand new to writing VBA so I'm sure this is all wrong.
My process starts with copying a master file called "template" into a customer's folder, the customer's excel file will...
Hi Everyone, this is my very first post. I am try to automate my school work a little quicker. I want to pull the first and second string from a folder name, usually the first and last names of people, and then put this into an excel worksheet with column A being the first name and column B...
I'm trying to rename all files in a folder based on values in the file and then save them in a user selected folder.
Below is what I have so far. It is able to rename and save the file but I have to select the save folder through each loop.
Is there a way to select the destination...
I currently have a data overview that draws data through power query from a folder in my windows computer:
However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following:
I am looking for your help with a project of mine.
This is what the end state of my idea is.
When I place a number that is associated with a folder inside the orange box it will rename that folder "Folder" without a number. When there is nothing or a 0 inside the orange box all...
I need a macro that I have no idea how to even start making.
I have multiple images in multiple subfolders. The file structure looks like this:
I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query.
I want to import data into this pivot table (not using power query below):
I have the source data saved here:
So questionnaire data file 1 is week...
I'm hoping you can help.
I receive a weekly report which I move into a folder, the name for the report will be different each time. What I'm aiming to achieve is to auto populate the data from the most up to date report into a master spreadsheet.
I was wondering if the lookup per...
in a spreadsheet, I have a list of files (different file extensions) with only two columns “Filename & Created”
2020_verVabt23_34.doc 10/03/2020 17:25
2012_verVabt23_34.xls 02/11/2013 09:15
Here, my questions:
Is any Formula or VBA to synchronize “Filename &...
I want a button in Excel that allows user to choose an image in their personal drive, through browsing the file location. Once they select the photo, it should create and save a copy of this photo into a shared folder, then put the new file path of the image into a cell. (This new...
I have code that currently loops through a list of hyperlinks in Excel and batch downloads these links as PDFs. I am having trouble controlling where these downloads ave. Sometimes they save to my desktop, documents, or another file path. Ideally, I would like them to be saved into a...
I am using the Ron de Bruin macro to send automatic emails to various users and that is working perfectly.
'Working in Excel 2000-2016
'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
Dim OutApp As Object
Dim OutMail As Object
I am new in the VBA excel. I would like to ask to everyone.
I have a list of document with .pdf extension (in column A1:A20). I want to copy all documents from source folder (in my disk C:) to destination folder (in disk D:). The destination folder is a new folder that named by cell...
I have below code for creating a folder in the same directory as the active workbook.
The folder name should be the content of the selected cells when I run the macro.
However, I get an error "Bad file name or number (Error 52)" on this code line when debugging:
In the below workbook A, with file name starting MarkList_12_4_2020.xlsx and sheet name as file name in stored folder (C:/Desktop/Mark)
In the another Workbook B, is the fixed Existing report...
Hello, I'm trying to do a macro that let's the user select a folder with more folders inside, this folders could have images .jpg or .png. What I want is that the macro adds only the image files in the excel, any image file. What it does right now is that adds the images but only if they have...
I've got some code that is supposed to expand some folders in Outlook. It works fine for the first level folders, but won't expand the subfolders (in this case the xx Progressions folder).
The code doesn't bug out: the subfolder simply does not expand.
Could anybody tell me what I've...
I NEED MACRO TO MOVE PDF INVOICES INTO DIVISION MULTIPLE JOB#'s SUB-FOLDERS
Everyone I’m new to EXCEL VBA I want to one VBA EXCEL MACRO that can move my
PDF INVOICES (19361-11599-113) Files FROM
SOURCE FOLDER (Y:\)
SHARED DESTINATION FOLDER