file

As you can probably tell by looking at the code below, I simply run the code when I have a xlsm file open and it saves it as a xls. A problem Im having is if i accidentally run the code on a xls I will get error at the Kill Filename. Is there something that could be added at the beginning where...

Dear All, My name is Dusan and this is my first post in the forum. I have been using it for quite some time now, and the reason I am boring you with this question is because I have not been able to find the answer anywhere... Here it goes: I have 50.000 lines in the .txt file (50.000 different...

Hi, I cobbled together some code from multiple sources that will process text files. Since we have multiple files in a folder that need to be read, I built the process to read all of the filenames in a folder into an array (DirectoryListArray()) that I use as a master list of files, then...

Hi - I have a problem with power query not updating all data from my source file. My query was created from file / from folder, and I currently only have a single file in that folder at the minute. I have imported that data into power query with no issues currently, however if I change some...

Hi All, Hoping someone can help me with this. I have some code that will open another Workbook, add data, save/close. I’m trying to create a loop that will check if the file is opened read only, if the file is opened read only, if like it to close the file and try to open it again, after 5...

The following macro is designed to split several tabs within a sheet into individual files. What I would like to do is get this part of the macro: Format(Date, " BOB mm-yyyy" to prompt a dialog box once at the beginning of the macro to ask what is the additional name tag the files should use...

Hello, I'm trying to save a newly created file in csv format. I am copying results from one open file, and pasting in a new workbook, and then trying to save the new workbook as a csv file. My code is below. See the "Save File as CSV" section below. Thanks! Sub Monthly_Device_Volume_Map()...

Hi good evening I am working on a file which have lot of data, I daily update that file, now my question if I enter a date in date cell that row go automatically on top of the blank cell Thanks

hello all! i am learning to code, and have 7 books but still have such a hard time understanding loops. i'm desperate for help. My boss wants me to loop through a years worth of files and pull data. I tried for days, and am just not retaining the rules behind the action. I hope someone will just...

Hi I saved a file as read only (save-->tools-->others--> checked [] read only). Now even for me, it open as read only. If I want to save it, it will create a copy of it and save the copy but original one is still read only. How can I undo Read only or that is not possible? Thank you. Thanks

Hi All, I am using below code to save the current file in another location and also want a pop up message if user want to save a copy of file or not ? but every time I am closing the workbook the message box pop up twice. Can anybody help me out what mistake I am doing ? Private Sub...

I have some code that works fine on my machine, but when my coworker runs it, the subject line comes through as Chinese characters. The email still sends with the file attached, but the subject line has the Chinese characters. Has anyone seen this before or have any ideas as to why this is...

Hello, 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...

<tbody> Hi I am having an issue performing a mass update on url addresses within excel. I have a macro embedded spreadsheet that contains a list of url links to file folders. The purpose of the macro is to select each folder individually and email out to the relevant person. The root file...

Ok Something happened to my excel over the weekend while I was not at home. If I just double click any excel file the menus are missing but if I open Excel first and choose the file all the menus are there. I cannot figure out how to add the pictures I took of the screen so I can show you...

Hello, I need help on VBA for the following requirement. Pop up message with 3 button of choices 1. Overwrite file 2. Save as different file name 3. Cancel operation. Thank you so much for your help. Cheers..... Sasils

A friend sent me a file to open for him. The file extension has now become like this: Book1.docx.nakw From his end, he inserted a flash drive into his system and all his files got the new strange file extensions. I have come across such situations, mostly when I send an unzipped workbook...

I have been using a macro successfully for sometime now, but I have just bought a new machine and I am running W10 and 365 E3 and now the macro will not see the path of the file The files are all stored in the cloud (Office 365, OneDrive for Business) but are also synced with File Explorer When...

Hi everyone, I know how to send emails to several emails ID's at a time using VBA... But, I am looking to send different emails to each email ID/ID's at once. Like we do in a mail merge. Currently I am using mail merge whereas, some sections of the email are fixed and are taken from an word...

I have a reasonably large file with VBA code and Userforms. Frequently, upon closing this file I receive the error "Microsoft Visual Basic for Applications - Out of memory". Once I have closed the error message the entire Excel application and all open workbooks are shutdown and Excel restarts...