prompts

  1. A

    Copy and paste visible data between 2 selected files

    Hello, VBA beginner here. I have just started to learn VBA. I found the following piece of code posted at: Macro prompts User to choose source workbook from folder and paste to destination workbook template Sub copyFromPlanillaReservas() Application.ScreenUpdating = False Dim cTr As...
  2. D

    Outlook OFT Template Forms

    Hey guys, Hopefully this is okay to post in a primarily Excel-based message forum. I just have a question about an oft template that my company has available. When double-clicked, it opens in Outlook. Basically, it is saved as an .oft and there is just a bunch of text in the message body...
  3. U

    VBA Change Footer Logo

    Hello Guys, Could you possibly help me simplify below codes? Basically, I recorded a macro changing the left footer logo. Also, is it possible to loop the codes as I need to do the same thing for all the excel files saved in one folder. After running, can I have a prompt of how much files...
  4. T

    Excel prompt clicker vba

    Anyone know's any vba code that can automatically select answer from which an excel workbook prompts? Thank you xx
  5. C

    Save Workbook Sheet As without Prompts

    Hello Hope someone can help me with the below please. I am new to this forum so I apologize in advance if I am unclear. I have a work book in .xlsx format that I wish to save as to another file in .txt format. I need to do this without prompts every half an hour, overwriting .txt file each...
  6. L

    VBA to continue automatically when opening files

    Our code (I copied it and tweaked it from another vba forum) goes out to @ 200 files in a folder and copies a single row into 1 sheet - works great But Rather than putting in code to tell it to Don't UpdateLinks or Don't Ask and then getting a second prompt, is there code to tell it to Don't...
  7. M

    Native DB Query Prompt - when sharing workbook

    Hi There I have a workbook which uses Power Query. I have tried the various suggestions I have found online for disabling the Native DB Query security prompts which seem to work when I refresh the workbook on my machine. However when the workbook is shared with other users it seems to ignore...
  8. A

    sharepoint login popup

    I have a process where it loops and opens thousands of excel files and then copies each tab to a blank spreadsheet. At some point when it opens the file, it prompts for a sharepoint login. How can i disable it so that it does not prompt me for that info?
  9. R

    VB formula that prompts a worksheet (as a pdf) to be sent in Outlook

    Looking for the VB formula that prompts a worksheet (as a pdf) to be sent in Outlook that opens outlook and I type in the recipient.
  10. R

    VB formula that prompts a worksheet to be sent in Outlook

    Looking for the VB formula that prompts a worksheet to be sent in Outlook that opens outlook and I type in the recipient.
  11. S

    Use VBA to close Excel File without Prompt (without saving)

    Hi everyone, I try to use VBA to close an excel file without saving and without prompt. I've tried many methods below (pasted below) but still cannot do it without the prompt. I figured it was probably because I am in TM1 Perspectives. Can anyone please help me find a solution? Thanks a...
  12. C

    VBA Macro Help!

    HI, I am having a hard time putting something together. What I need is to be able to copy cells a3 - to I23, copy them into a new excel file, then without prompts save the file as c:\newFiles.csv and overwrite (even if the file exists with no prompts) I have the first portion, however can't...
  13. S

    Remove prompts from automated mail merge

    I'm using Excel vba to automate an existing Word mail merge from an Excel spreadsheet. Everything is working fine except that it prompts me to confirm the mail merge. I want to get rid of these prompts as they lock the process until they are answered. If calling Word from Excel vba, is...
  14. T

    Macro comparison, why is one not working??

    I have 2 search forms, one is working just fine, I used it as a template to build the second but something is different and Im not seeing it. Both forms are using an Apply filter macro on a "search" command that references 3 test boxes Working Marco - Apply Filter - Where ([SEARCH_MTR]![MTR]...
  15. D

    Bypass prompts in loop code

    Hi, I've got really good code from AlphaFrog below. Every file this tries to loop through gives me the same two prompts each time: 1. This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest date. Otherwise, you...
  16. C

    Hide everything other than the userform while macro is running

    So I have created a macro to import data from another file when a document is opened. In an attempt to occupy the user I have created a user form to display while this runs and hidden the Excel file itself whilst this is the case. The only problem I now have, is that when the source file is...
  17. P

    How to access VBA in Word Document from Excel VBA

    Hi, I have a Word macro enabled document with ActiveX controls in it. A user can basically select multiple check boxes or select options in combo boxes on the Word Form. There are certain fields that I want to make sure the user fills before closing the word document. Below piece of code...
  18. L

    Tricky macro split data and insert lines then formulas

    Hello, I have an issue with a macro I was given. It's basically crap/unusable so I'd like to start fresh. Considering that others will have to use this macro as well I need to add some prompts to ensure that they don't mess up. Here's what the data looks like 1-01-01+ 1-01-02/03+ 1-01-04-...
  19. D

    automate windows prompt responses

    Ok so my below code basically opens another macro enabled workbook takes out a sheet (with a specific name) and pastes it into my active worksheet, Unfortunately when opening the file (to be copied from) i have to respond whether to enable macros or not. As this is within my code by opening...
  20. T

    Macro WIP - Issue with user prompts

    Hello, I have written the following code: Sub The_Prompts_Nightmare() On Error Resume Next Dim q1 As String Dim q2 As String Dim q3 As String Dim q4 As String q1 = InputBox("Do option 1? (y)", "Q1", "y") q2 = InputBox("Do option 2 on entire workbook? (y)" & vbNewLine & vbNewLine & _...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top