prompt

This is a new behavior I can't explain. I have no macros (that I am aware of), no add-ons, and am using workbooks that I've had for months. I often test changes to data or formulas to see what might happen then close the file without saving so no permanent changes are made. Now, when I...

Hi, Im wanting to save values from: range B2:E20 With a space between each column value anf saved as txt (overwriting existing txt file without prompt) I think i need to use "saveasCopy" but not sure how to save just the range and to a specific location Any help appreciated

I have an add-in I created but I want the user to periodically update it by simply saving over it. The problem is, it appear Excel can't be open to save over the add-in (it will prompt for a different name). Any ideas how to accomplish? Thanks

Hi, I have a document that several users are going to use. I have a sheet called "Information" that I uses as a form of homepage. I have a commandbutton called "Help" in this sheet. Is it possible to prompt a message box that functions as seen on some homepages where the user is asked to...

Good morning. I need some help. I have to get some data parsed from a single excel sheet to many sheets, in the same workbook. This new number of sheets is dependent upon how many users are input from a prompt. The outcome would move data from the main sheet to n number of sheets based on...

Hi, The following code is run upon opening the workbook. is it possible to Prompt command button rather than running macro automatically. I tried my best. but could not success. command button should prompt to run macro. Sub Auto_open() MsgBox "Please select Source File" NewFN =...

Hi everyone, I have some VBA code that is used to export a specific cell range to a .PS1 file, which basically makes a PowerShell output file that I can run to do some scripts. I have the below VBA that designates the filename and the file location, but I would like to alter the script to prompt...

Hello, Would someone be able to let me know how I can edit this code to change the MyPath = "C:" to a prompt for folder location instead? Thanks FHPM1 Sub MergeAllWorkbooks() Dim MyPath As String, FilesInPath As String Dim MyFiles() As String Dim SourceRcount As Long, FNum As...

Greetings everyone, I'm currently trying to get my excel application to close whenever I close any userform using the red X in the right hand corner. Besides, I'd like the form to throw a prompt asking whether I want to save it or not. How do I get this done without having to code it into every...

When the code below is executed it prompts the user to choose the location they want to save on their computer (also inputs a default filename from values in the sheet) and prints the range to PDF. Worksheets("Sheet1").Activate filename =...

Hi Everyone, I'm writing some code to open files in a loop, run a macro and select "Yes" on the prompt box that opens iimmediately after the macro is ran. I'm having trouble automatically selecting yes to continue running the macro. Any ideas? Thanks All, Matt

Afternoon All The following code below fetches serveral files i link to, the only problem is that upon getting each file I get a prompt asking if i'm sure I want to open the file, is there a method of having the code to auto click ok and continue with all the files automatically, i did try...

Hi, I have recorded a macro to import a .txt file with a specific path, 'Macintosh HD:Users:Stephen.....' which contains some scientific information, and to format the text to only keep the data I want, and then to save it as a .xls spreadsheet. I want the macro to prompt me for a .txt file...

Hello - I currently have a macro set up that takes one very large Excel with about 200 tabs and separates it into multiple Excel's and saves them all out to a folder. I will be running this Macro each month and would like it to change the name of the document to include the month that it is...

First time poster. I have an excel sheet with a bunch of drop down menus. It is designed so that when you select a choice in box 2A it narrows your choices in box 2B, which narrows your choice in box 2C. That is however not important. I have designed this for use on a tablet in the field. For...

I attempted to copy the cells (which had formulas) from one workbook worksheet into another workbook worksheet. It didn't paste properly, so I deleted it and resolved to enter the formulas I needed manually one by one. The formulas reference values in other worksheets within the same workbook...

This may sound odd, but I was looking for ways to create a macro that would open a a dialog box that would prompt the user for a file that would then store that filepath to a cell, allowing the user to click on the cell to open it again. The excell sheet would serve as a checklist for many...

Hi, in my VBA code I save a workbook but leave it open. Once the code has completed and I then manually close the workbook, it asks me if I want to save the workbook, even though that is the last thing I did in my code. Any suggestions of how to avoid this?

Any one here know anything about macros in excel? Would really appreciate a heads up.

Is it possible to prompt the user for a specific row number to delete in a vba textbox? If yes, then the code would fire using a button. I have the worksheet protected and only want to unprotect through code to delete a specific row number, then protect it again.