dialog

Is it possible to create beautiful dialogs in Excel not the traditional ones? I want to achieve the following look. Only the look, I can functionalities myself. See the screenshot below from excel. It is a built in dialog. Can this be made in excel? (without making a seperate Addin) e.g.

hi all， May I know how to use vba to upload file in the internet? The website is internal and I need to open the dialog and select the file to upload. Thanks for any suggestions!

I have a VBA code to save as my file in other location but I need an improvement to save as my file without dialog prompt ActiveWorkbook.SaveAs Filename:="C:\Users\alex-cccp\Desktop" & ActiveWorkbook.Name, FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _...

Sub TryOpenFileOpenFolder() Dim FileNameRef1 As String, FileNameRef2 As String, myPath As String FileNameRef1 = Application.WorksheetFunction.Text(Range("A1"), "General") FileNameRef2 = Application.WorksheetFunction.Text(Range("J1"), "General") myPath =...

I hope it is okay to post a new thread since this post was answered already. https://www.mrexcel.com/forum/excel-questions/299193-edit-links-startup-prompt-dont-display-alert-update-links.html?highlight=update%2Blinks Edit Links - Startup Prompt - Don't display the alert and update links. My...

Hi guys I hope you can help as I have been scratching my head a bit! I have code which opens, updates, saves then closes two different work books. I already have used the below snip to stop the screen flicker but i also want to stop the saving file dialog from appearing. This is to prevent...

Instead of clicking Developer > macro to open macro dialog box (or pressing ALT F8), I made a command button to open it by just one click (using the vba below), Application.Dialogs(xlDialogRun).Show the dialog box did pop up BUT the macros are not working! what could be the problem? I am...

I have the following code for a Save As Dialog Boc I have set a value to Initialname and I have specified that InitialFileName:=Initialname which then is supposed to set a default Save As name in the dialog box Initialname = targetSheet.Range("BP37") & "-Imported" fileSaveName =...

I have a workbook which is 'read-only' attrib. I needed a saveas dialog box to appear everytime save, saveas, close or the [x] at the upper left of the worksheet is clicked. but instead of "copy of filename", I want it to be a filename I will recommend. I could not find solution in the net [I...

I haven't been able to find any reference to controlling the actions in the Consolidate dialog box. I know the basic Range.Consolidate Sources:= But what about the other actions in that dialog box such as adding/deleting range references?

I have an excel web query that grabs some data from the web and writes it to an external database. The query is set to refresh every 5 minutes. Works fine most of the time. Sometimes excel puts up an error dialog (unable to reach website...) and the query hangs up until this is acknowledged. I...

Hi, I need to add a signature block and I have the code below. However it brings up a dialog box where you have to press enter to make it go away and it will add the signature and details. I need to bypass the dialog box which it doesnt seem possible so instead I was thinking of using sendkeys...

I'm using Excel 2013 and the line of code I'm having trouble with is: If Application.Dialogs(xlDialogEditColor).Show(10, 0, 125, 125) = True Then The code is in an Addin and it works great if there's a regular workbook open but if there isn't one, I get the error: Run-time error '1004'...

Ok, you guys have been a big help, so here's a tough one. At least for me! Lol. I want to open a file dialog box in excel when clicking on say a button in cell A1, choose a series of files and have then automatically renamed with info from say cells, A2, A3, A4 and then resaved, with the new...

This is annoying, I have a local copy of a spreadsheet which has a VBA script to import data from an xlsm on a OneDrive directory. Even though OneDrive is already running and logged in, the Workbooks.Open line will result in a Microsoft sign-in dialog popping up (Type the email of the account...

Hi there, I have just joined the forum and I'm really thrilled to be an active team member..!! I was wondering how I could make my excel dialog boxes colorful (red, orange background)? It would look more appealing to the user, in my opinion. Looking forward to your valuable feedback :)

Hi, I am furious that this has to be so difficult. I am using Office 2016 x64 on Windows 7 I have CSV files that can potentially have multiple language characters in them. They are encoded in UTF-8 and separated by commas. I want to be able to double click on them to open them nicely and...

Hi! I am using the following code to show a SaveAs Dialog Box but I require a specific folder path to be set which will be a default whenever the user saves the file. How do I do this with the code below? Dim Ret strFileName = ProjID & "_" & TCG & "_" & Competitor '<~~ You can set Default...

The SaveAs Dialog Box works for me but it is the second part of the code which does not let me save the excel sheet as the filename I have set for it. It saves it as Book 18 etc. How do I get it to save with the filename I have specified? Dim Ret strFileName = ProjID & "_" & TCG '<~~ You...

Hi Guys, I don't think this is going to be possible, but there is always no harm in trying! Most Excel custom (in-built) dialog boxes are open as Modal. Is there a way to open these dialog boxes as Modeless? Many thanks