opens

I have been working on a new quoting tool for my organization and I guess I did such a great job( in large part to this forum! Thank you to everyone!:):):):)) that the Engineers are worried that the sales people will create quotes without engineering overview and create some serious issues...

Hiya again folks. I have a HYPERLINK mailto link which Opens outlook and populates the various fields. Is it possible that when the link is clicked and outlook opens, it copies and pastes the text in cell H4 and pastes is as a value into the body of the email window? Many Thanks

Hello, I am having some issues with data scraping a website table I am interested in. The reason is because one of the links I click on in the process opens a new IE tab. How do I follow the link to the new window via VBA? Current code I have is below. Sub Button1_Click() Dim ie As Object...

I created a workbook that has macros for companies that we email. Each company is listed on one row on first sheet. There are buttons for each type of macro next to each company and the interface is getting crowded. How can I ask the user to select the company when the sheet opens? This will...

Hey there, I have one macro that creates and opens a new workbook. I also have another macro that when you click on a cell within a certain column, it finds and opens a specific file (using the file name that is listed in that particular cell). Is it possible to somehow use this second macro...

Hey there, I have one macro that creates and opens a new workbook. I also have another macro that when you click on a cell within a certain column, it finds and opens a specific file (using the file name that is listed in that particular cell). Is it possible to somehow use this second macro...

For the past decade plus, the way Excel worked for me anyway, every time you double clicked to open an Excel doc in windows explorer, if you already had another Excel doc open, it would load the new one you clicked on in the same process. Now there seems to be little rhyme or reason. Sometimes...

Morning all, I have the working code supplied below. How it works is i make a selection from the combobox & that person in question has its row highlighted & the cell in column A which is customers name is then selected. What i would like to do now at this point is when i hit enter the...

Hi, I have a userform which opens when I double click a cell Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Not Application.Intersect(Target, Range("G2:G501")) Is Nothing Then Cancel = True UserForm1.Show End If End Sub My problem...

A simple 3-line macro I made. I assigned a hotkey to it and put it on the ribbon (Excel 2013). When I run it (via hotkey or icon on the ribbon), it opens an older version of the workbook in another folder on my hard drive. How do I find out why it is doing this? I've searched for the filename...

Hi. I have a long macro that executes automatically every day. In order to reduce the execution time, I've seen that I can use Application.ScreenUpdating, since I don't need to see what the macro is doing. My question is: what does application refer to? I ask this because the macro runs from...

I recently upgraded to Windows 10 and the installation overwrote my old personal.xlsb file erasing all the macros I had stored there. Additionally, when I start Excel now the personal.xlsb file does not open. When I go to the XLSTART folder, the file is there. I open it from the XLSTART...

Hi, I have a sheet with about 600 shapes. One of them (just one) is assigned to a macro that opens a simple userform. When i click on it, it takes too much time to open the userform. When I delete all other shapes, it opens faster. I would really appreciate your help to solve this problem. Thank...

Hi All, How do I write in code the following verbal: Many thanks in advance! R/ Pinaceous

I am working with a script that will save a SHEET from my workbook to a location on my computer but it opens it up also. SO I am trying to get that NOT to open or at the least we I can get that file to close. Here is where I am at now: Application.DisplayAlerts = False ActiveSheet.Select...

Found this code here on the forum and need help with modification : Private Sub CommandButton2_Click() 'This macro opens the SaveAs option with the defult file path "you have to set this file path below" coverts the whole sheet into .pdf file format 'And opens the .pdf to view <-- you can...

Hello, Got an issue which I can't seem to resolve. I have a Workbook Connection from Workbook A (.xlsb) to another Excel Workbook B (.xlsm) on the network. The data is updated with the following code: Private Sub Workbook_Open() Call HideAllSheets ActiveWorkbook.RefreshAll...

Hi Excel Gurus :smile: I have googled this, but I can't seem to find what I am looking for. I want a VBA macro that takes all the xlsx files in a directory, opens, copies and pastes the content as values and closes again. Any ideas? Thank you in advance

I have a workbook (workbook1.xlsm) that has a VB script that runs as soon as it opens. This VB script opens another workbook (workbook2.xlsm). As soon as workbook2.xlsm is opened, it copies everything from sheet1 and then goes back to workbook1.xlsm and pastes everything into sheet1. The final...

Hi Excel Gurus :) I have googled this, but I can't seem to find what I am looking for. I want a VBA macro that takes all the xlsx files in a directory, opens, copies and pastes the content as values and closes again. Any ideas? Thank you in advance