response

Hello all, I had an issue trying to connect to my first API call from Excel and John_w really helped. Thank you John. I now have the need to connect to a free API travel website https://iatacodes.org/. I am getting an error in parsing the xml. All help is appreciated. Regards, Marc Sub...

Hi All, I'm trying to figure out a way for a button click to lock a specified range of cells Then to Copy other specified cells. I'm working with the following: Dim response As VbMsgBoxResult response = MsgBox("ONCE YOU SELECT THIS BUTTON...

Good Afternoon, I need some assistance from the group, please... I need to generate a formula that will concatenate the left two characters in cell A2 with the first three characters in B2. Then take those results and compare them to a predetermined group of values and return a text response...

Hi, I have two identical tables in Sheet 1 as given below: <tbody> Sr. No. Header 0 Header 1 Header 2 Header 3 Response 1 Parameter 1 Data A Response 1 Parameter 2 Response 1 Parameter 3 Row with some other data Row with some other data Row with some other data Row...

We utilize an excel based questionnaire to gather information. We have main questions and then sub questions, The sub questions may become inapplicable based on the response to the main question. All responses are yes or or and responded to from a drop list. For Example 1. Do you own a...

How van i show the content of dropdown list when triggered?.thanks for the response

Hi All i have a project that is outside of my current skill set. I'm not asking for someone to do it for me. sorry if this makes no sense. just want to make sure 1. if my idea is even viable 2. suggestions on possible area's issues may arise. 3. am i using the correct terminology. 4. people to...

Hopefully somebody can help/guide me in the right place with two of my Macros.. Firstly I have a check to ensure a cell has valid data. So far it only checks if its zero. I need this to also check if its blank or = "" Sub Start() If ActiveSheet.Range("E3").Value = "0" Then MsgBox ("Cell E3...

Hi, I have reports that span from Column A up to AQ in excel. On these reports I need to average based off the group name and response time but the column the response time is located on changes from report to report. Group name is always in the same column so is there a way I can fix the...

After a successful match I get the row number and move to the else statement, but somehow I'm getting an error 20. My search indicates I have a resume outside an error handling routine. I just don't see it. Your insight is appreciated. On Error Resume Next...

I have some experience with VBA but I am new to applying it to outlook. I am curious how I would go about having a daily reminder that also pop up a message box with a yes, no response and then record that response on a excel document. I am not entirely sure about what sub I should be using...

Hey everyone, I'm trying to create a table for response times by department and month. All the data is coming from a different sheet where it's all stored. I did a tiny version below to attempt best explain what I've been doing. I'm basically a little better than a beginner with excel, but...

I have created the below code.. Sub VATCHECK() Dim sURL As String Dim sEnv As String Dim xmlhttp As New MSXML2.xmlhttp Dim xmlDoc As New MSXML2.DOMDocument 'DOMDocument sURL = "http://ec.europa.eu/taxation_customs/vies/services/checkVatService" sEnv = "<?xml...

I don't know why this isn't working and I've tried a bunch of different combinations, but basically i'd just like to exit the sub if the user clicks the cancel button. I've tried the variations of code below: Anyone see where the issue is? I keep getting type mismatch errors. Resp =...

Hi there, I am using Excel macros to provide some data to other application (SAP R3 window) using SendKeys and AppActivate funcionality. I have two questions according to this : 1. How can I receive the names/titles of all currently opened windows/programs (bring them to the cells of excel...

I have two values that I want to paste into a template after I've pasted the template into a new worksheet. Let me try and explain clearly... In the macro I have now it opens a specific workbook and copies a template, then pastes it into the new workbook that I am working on. I would like...