prompts

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

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

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

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

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

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

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

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?

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.

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

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

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

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

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

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

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

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

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

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

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