I have some zipped files that I need to keep for future reference.
I wish to keep them in a folder on my pc & this is for my web site. I don’t wish to use google drive etc.
Can the folder be password protected ?
I found this great article (http://www.xl-central.com/list-the-files-in-a-folder-and-subfolders.html) and it is exactly what I needed.
I’ve tweaked it to reflect my circumstances, my issue is, I’m trying to pull certain cell Information rather than all the information about the file itself...
I have a program that generates between one to three reports for several different departments. It then is able to save the results as an excel workbook. I have written some VBA coding that I plan to use to formats these reports.
1) Is it possible for a script to “watch” a folder so that...
I have a load of models that are stored in a folder for each day. Last thing at night I create the next day's folder and copy all the files into it from that day. This is because we need to be able to track where and when changes were made. There might be hundreds of changes made in a day, too...
Can I please have your help to create a code that allows me to export image1 and image2 to a folder name that changes based on every new entry. The images will be loaded to the user form by click the image shape in the userform. I would like to export or save the images on the a folder...
I am trying to save information within a textbox, to a .txt file, to a spesific folder, without using dialog (this button shall basicly autosave the information within the textbox to a folder, with only saying something like "Submitted" when its done)
I have only used...
I need a VBA code to copy all files from a folder located at From Path to a folder located at To Path but only those files which are new or have a modification date other than the files which already exists in To Path.
CASE # 1
There are 25 files in the folder...
Hi is it possible I have seven wookbooks stored in numbered week folders each workbook is dated sun01.11.19 to sat07.11.19 . I need to be able to enter the folder name week 45 and each of the seven wookbooks within opened and sheet1 from each be combined into a new wookbook.
I have never attempted this before. But, is there a way to place your Access DB on SharePoint, but have it linked to where it saved in the folder its linked to? Also, multiple users should be able to open it correct?
So i'm trying to build a macro-updating document register.
So column A = the full URL of the file location (input via macro - see below)
Column B uses the following formula =LEFT(A2, FIND(CHAR(1), SUBSTITUTE(A2, "\", CHAR(1), LEN(A2)-LEN(SUBSTITUTE(A2, "\", ""))))-1) to find the...
I am looking for a code that allows to export an excel sheet as PDF that has name TARA-19-001 to an existing folder that was previously created with the same name in the following directory C:\Users\SSF1590\Desktop\TARA Project\Folders . The name of the file will change every time a new...
Is there a way to automatically change workbook name dependent on which folder its in?
If say the host folder is called "2019" and the workbook is called "test.xlsm". When "test.xlsm" workbook is placed into the "2019" folder the workbook then changes name to 2019.xlsm?
I have a macro to save a worksheet and protect it. It then also saves the new worksheet as a PDF. I want to save the PDF into a particular subfolder called "Invoices" The sub folder will always be in the main folder. I cant use a spefic path at the main folder needs to work on different...
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...
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)
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...
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...
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...