folder

The challenge gets tougher and I have to call on Tech support:) When I click on a command button, I want to access the open dialogue box where I select an image file from a folder - this could be anywhere on the computer. Then I rename that image with the content in textbox1 (for example)...

In Excel, the following VBA code does not work properly. dlgAnswer = Application.Dialogs(xlDialogOpen).Show("day*.xls") It opens the Dialog Box but shows all files in the folder (including day*.xls). I was expecting it to show only the files starting with filename as day* . I tried Fileopen...

I have a routine which prompts the user to choose a folder to save an embedded Word document as PDF; FilePath = Application.GetSaveAsFilename(InitialFileName:=File121, FileFilter:="PDF Files (*.pdf), *.pdf", Title:="Select Folder to save") It works fine, except if the user clicks cancel in...

Can someone help me please. I am trying map out my hard drive – which files are in which folder, folder sizes etc.. This requires that I access folders. The problem is that if the folder attribute is not normal i.e. folder.attribute is not =0 then when the procedure runs I get: Run-time error...

I need a macro to combine a bunch of excel files into one file. i want something that when i am ready to combine the file it prompts me to pick a folder and whatever is in that folder gets placed into one combined excel sheet Thanks in advance

Hello, It is the first time I use VBA and I am struggling aquite q bit with a task. Here is the issue: I have some 120 workbooks in a folder, and all have the same structure (same number of sheets, same names, and same order). If a user changes a sheet in one of these workbooks (by adding...

Hello, We have a number of CSV files which are created daily by our modelling software. I would like to import the most recent csv data into their respective excel sheets. Each csv file is saved in a single folder generated by the model. An example of the saved csv file are saved like this...

Dear All, I have this vba which will extract the outlook messages to excel however I am not sure how can extract the attachment information along with this. Requesting your help please Sub GetFromOutlook() Dim OutlookApp As Outlook.Application Dim OutlookNamespace As Namespace Dim Folder As...

I have a macro that creates a folder for every new client we engage with a specific folder structure. It copies a template folder to the desired location, then renames the folder based on the input in the excel workbook I run that macro from. Sometimes when I open the template, it has an...

All of a sudden I'm running into a real weird problem. When I save a spreadsheet to one folder, it works fine, but when I save it to another folder (where I really want to save it to, I get this error, "The item couldn’t be saved because the file name is invalid." Does anyone know why this is...

Hi Guys, I am using Excel 2016. I have the following input fields : <colgroup><col><col></colgroup><tbody> Sales Person Jack Customer Apple Inc Project Glass </tbody> I am trying to setup a macro that will save my excel file to a specific folder name base on the sales person name. So if...

Hi, i really need some help. I had many folder to move :) I want to move all inside files inside folder a to folder b *No overwrite of file with same filename as whole *delete empty folder <tbody> From Folder (Col A) Move to Folder (Col B) \\abc\folder1\ \\abc\Main1\ \\abc\folder2\...

<colgroup><col><col></colgroup><tbody> Hi, I want to move left blue colored files to rightly mentioned red colored folder in all below cases. File name Folder name C:\Users\LENOVO\Desktop\New folder C:\Users\LENOVO\Desktop\New folder\CSC21251 CSC212512016120120161231.emd CSC21251...

i don't know possibly if anyone will understand me and how possible it is 1) i need a code that, whenever i drag a file from explorer into a listbox, it should add the file name and path to the listbox items. 2) having a listbox populated with files and their paths, is there a code that when...

Hello, I have different excel workbooks in the multiple locations and would like to open them and copy into a new excel. Example, This is the standard location - C:\IT\Test Project\2019 Further the 2019 is divided into 12 monthly folders named 1-2019, 2-2019, 3-2019 etc. Each of the monthly...

Hi all, I have been searching for a code to print files from a company server (shared folder) but I can't get any working. On the userform I would like to have two comboboxes and a listbox. The first combobox would be populated by subfolders within a folder named "Projects" (which is saved on...

Hi all, Basically I want to automate the importation of a Text/CSV file into my Excel. The problem that I am having is that the pathway and file name of my source changes on monthly basis. For example: For the month of January, a January folder is created where all the data in dumped in. So...

Please, what's the fastest code that can resave (perhaps through loop) all the files in a folder and its subfolders and it will maintain the folder and subfolders structure in their destination?

I'm using this code for list some folder i need in my spreadsheet <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console"...

Good evening, Is there a way using macro to create a month folder with a time stamp? The folder name will be the month name in cell B3 of sheet1 and can the time stamp be HH:MM:SS? Lastly can the macro create 4 additional folders within the newly created folder, if that is possible. The four...