folder

Hi All, Hoping someone can help me out? I'm trying to download all attachments from an open Outlook email to a zip file, name of my choice, to a local folder. There's no record function on outlook and i cant compile from scratch. I can only find stuff about downloading all attachments in an...

Hi all, Hope you're having a good day. I want to create a popup for a user to choose between three options Select a file, Select a folder, Cancel I made a userform to handle this. If they choose to select the first option, I want to use Application.FileDialog(msoFileDialogFilePicker) to...

Hi, I m new to VBA coding - I am looking for some guidance to the following: I would like to use a workbook to search for a folder in explorer, open the desired workbook in that folder, then slect a range of data from the selected workbook and store it in a new work book. I need something that...

Hello. I'm publishing some reports as .htm files, and I faced issue with relative/absolute path of output .htm files. Let's say, workbook is located in folder "Publish" at desktop. I want to publish .htm files in that same folder where workbook is located. Attached is layout of dialog for...

Hi My code checks to see if a folder exists and creates one if it doesn't before going on to produced a dynamic number of PDF documents and save them in the folder. The Code works, but I decided to try and be clever and give the user the opportunity of opening the folder once all the PDFs had...

Hello, I am trying to create a code that allows me to create a folder in an specific directory with folder name on textbox1 and if this folder is already created in that directory, it does not allow to create another with the same name. As I am very new to Excel VBA, can you please help me...

I've been asked to create a tracking template to track every step of the process for formal inquiries that go into a Outlook inbox. The plan right now is to create a system folder for all inquiries, and then in that folder create a subfolder for each day an inquiry comes in, and from who...

Hi all How to copy and paste 2 wbs from 2 locations into one then run macro 1 then auto save the combine wb into the same folder with wb1 , same name as wb1 but add specific text1 and time stamp at the end & (.csv ) After that, the macro will automatically redo copy and paste 2 wbs above...

I have a code that creates a pdf and saves it in the folder where the workbook is saved. I have a sub folder PDF FILES. Is there a way to save to the PDF folder without using a full patch like c:\user\workbook\pdf files? Below is the code I have so far. Any help would be greatly appreciated...

Hi, I have a large macro that asks the user to save the file vbYes/vbNo File name is coming from combo of cells in the file I want the user to select a folder on the network. It should ask to overwrite if file exist. It must save as XLSM. I've been trying to get ActiveWorkbook.SaveAs going...

Hi, I'm struggling with an alternative here. Cells A3:A50 has a list of workbook names in a specific location (this auto updates when a workbook is added or removed) which is where i want to pull my data from - from sheet 2 column B. Each workbook is of the same layout, which makes it a little...

Hi I've built a code that searches through a list (rngWB) of excel workbooks and produces them as PDFs. The code works well, but insists on saving the individual PDFs to my Documents folder. I want them to be save to a folder in my documents, but that is further named by the contents of a...

Hi, I've searched the forums a bit and haven't found exactly what i'm looking for, so i'm wondering if anyone here can point me in the right direction. Background:Each quarter, members of my team need to print financial reports for different companies. Each company's files are located in a...

Hello, just curious if anyone else is having issues with VBA on a Mac that saves files in a box folder? I have a file that defines the file location and saves down copies of some sheets within that workbook to a folder titled "Output" in the same folder location. Currently the code looks like...

Hi, I was wondering if you would have any advice when it comes to save a new version of your workings. Lately, i have found myself saving a version after another making my folder looks very untidy. What would you advice to keep your versions nice and tidy? When do you decide a new version is...

Hello Team, we have requirement, where in i have the excel files in the folder, where i need to move in to one workbook with sheets names as workbooks names in the folder.

Hello Team, i have all the files names(.xlsx) that is in the folder and currently i have to sum Column B from "sheet1" of each cell. NOTE: All the file will be closed, except the master with all the xlsx file names in the folder & in the same sheet i have the formula.

Hello, Still new to excel and needing a little help. I have a workbook that i need to have the user save weekly into their archive folder located within the same folder the workbook is held, however the file path changes depending on the user. I know i had it close as i can get it to save into...

Hello Friends, I am using the below code to open folder 1 Sub OpenFolder()Dim str_folder As String str_folder = "C:\Users\i ' M\Desktop\Folder 1" Call Shell("explorer.exe " & str_folder, vbNormalFocus) Copy End Sub I want to open folder 1 > copy all files from this folder to folder 2...

Hi. I got this code (below), that users submitt some text and values, then it saves the file as a .pdf. This works perfect, but, at the line ***foldername = .SelectedItems(1)*** it opens filebox and lets users select a folder to save the pdf file at, but is there a way to show the existing...