file

  1. S

    [VBA HELP] Save file prompt to overwrite, save as or cancel

    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
  2. kelly mort

    ENC file problem- don't know how to open it

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

    ChDir path problem

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

    Send different emails to different email ID"s from Excel

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

    On Excel File Closing - Receive Out of Memory Warning and Closing of Application

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

    Project locked???

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

    Select, Copy, Paste one by one till last data to new format

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

    Auto Run "Import Database" upon open file

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

    Reverse Ctrl + Open bracket?

    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!
  10. H

    Open File If MAC Address Matches With That Mentioned In The Code

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

    Streamline Power Query for Excel

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

    save PDF file into sub-folder

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

    Data Importing Wizard - Terrible Data Set - delimiter issue

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

    Data Importing Wizard - Terrible Data Set - delimiter issue

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

    Sumif using a list of criteria

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

    Excel saving file as CSV with extra 2 commas at the end of the rows

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

    Present a user with drop-down menu of directories, to choose a file to open

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

    [VBA] Custom two-option user Popup

    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...
  19. Gerald Higgins

    VBA, make code move across from main file to extract file

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

    Graph help (Data Table)

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

Some videos you may like

This Week's Hot Topics

Top