file

I created a file with VBA included. A buddy copied it to use on his network. He needed some fixes so I opened the file and the VBA developer but could not edit the code, it said that the project was locked and unviewable. I've never encountered this before...any idea what would cause this...

Hi Excel Experts, Myself Srini, new to this forum. I need your help to provide a macro code for the below Input & Output file image links are as below Input File Image-->https://ibb.co/xLQ6dLD Output File Image--> https://ibb.co/f0VMv9c In Input, Rows & Columns can be n numbers. Need to...

I need some help here as still learning Excel Macros I have few sets of code within an excel file. 1) clear "results" data if "input" criteria has any change 2) Export "results" as a separated file in values only - button 3) Import "Database"- button So far, I tested them separately, all are...

Hi all, Weird question, but i love the ctrl + open bracket trick to take you to where the formula is happening, but is there a way to get back to the original cell? It can get tedious to have to trudge through several sheets or rows, especially if you are working with large file. Thanks so much!

Hello Friends, Is it possible to Open a file only for specific computers. A VBA code for let’s say 3 MAC Addresses is linked with Workbook Open Event & the file should open for those 3 computers who’s MAC Addresses are there in the code - otherwise a msg box should prompt saying that you are...

I am just discovering the power or Power Query for Excel I need to run merge queries to populate data on my daily file from the same master file every day and am trying to streamline the process. My current process Open my daily file Get & Transform From Table/Range In power query editor.. New...

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

Hello, I have a wonky .txt file. I have to import the data into excel and I use data import wizard. Column B and C have data in there that should be split out into different fields (ie, anothercolumnthing, trans id, anothercolumn, event-time). However, I cannot get the data to be delimited...

Hello, I have a wonky .txt file. I have to import the data into excel and I use data import wizard. Column B and C have data in there that should be split out into different fields (ie, anothercolumnthing, trans id, anothercolumn, event-time). However, I cannot get the data to be delimited...

I was wondering if there was a formula that I could use to sum a data file using the below columns as the lookup, I would also like to use another criteria in addition to this. I.e If any of the numbers in column A appears in raw data file, sum the respective number in another column...

I am working on a file with about 30K rows and has to be saved as a CSV file. When saved and opened up in NOTEPAD, the file has rows (starting with H) that have double commas (,,) at the end of the line while the others (start with D) are fine. The H rows are 2 columns less than the D rows...

Dear Learned people, the following code is meant to present a user with the opportunity to be able to select a file that is in the folder "01_ElementLists". currently the code only takes the user to the list of files residing on the desktop, and the user must then know what the path to the file...

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

Thanks in advance for any help ! So I’m still learning VBA, using a combination of the macro recorder, this website, trial and error, and so on. I have a file, let’s call it “FILE A”, which has a number of worksheets. The file includes some code that pulls in data from a number of other...

Hello experts, I am having difficultly graphing the attached. The original file in excel is a a data table (What If Analysis). link to file is below. <tbody> Price per Chair 500 750 1000 1250 Cost per Chair $200 $15000 52500 90000 127500 $175 $2500 33750 65000 96250 $150...

Hi everyone, I am very new to Marco, it would be glad to get some help here :) Here is my trial: DD = Day(Date) MMM = Month(Date) YY = Year(Date) WBK = "S:\Project" & Format(Now, "DD MMM YY") & ".xlsx" Windows("Destination File.xlsx").Activate...

Hello I've created a dependant drop down list in Excel to aid user entry but the size of the file is worrying. Empty it is 300KB, when I add my data in (around 6,000 rows) it goes up to 600KB. I could get around 100 responses (via email) that I would then need to attach to the relevant record...

I have an excel file (File #1 ) in which I would like the VBA code to open a file which is saved on my OneDrive (File #2 ). This excel file (File #1 ) many people will use, so when the VBA code runs I want it to be able to access my OneDrive file (File #2 ) and open it in the background within...

Hello, I want to create a command button in my excel find to find necessary values in an external excel file. as in many programs, I would like to click on the open file option and select the target file with the windows search interface. as an example I installed a page of a simple windows...

Hi I want to open a sort of Back-End-file (.xlsm-file) stored in MS Teams, edit some data and close the file with av macro from a Excel “master file”. But I can’t find out how to do it. Everything I do will open the BE-file as “read only”. Please help! I think it is the same if stored in...