#vba #excel

Dear MrExcel, I want to inquire about merging the input box and printing using VBA Codes. I have a template in printing. 1. I used the Input Box to a certain range to the page will update by using String. 2. If the page I want to print is updated, I need to print the area. 3. Then, I want a...

Hi guys, I need help with VBA for button to export .xml table by selection. I tried to copy and combine some example code but with no luck. It creates .xml but not for selection or fixed range (never mind) but the data is wrong as I don't know how to code it properly... The code is: Private...

First off I'd like to let everyone here know that I have very limited knowledge with VBA and learning, most of which I learn from reading threads. However, I am having problems with my last bit with just trying to hide columns after all the data has been captured from the rest of my macro...

First time poster, long time creeper. Using Excel 2010 on a W7 PC I have an Excel sheet that is downloaded off of a SSRS portal. The SSRS report is formatted to be one page. When I print from there, each tab is printed on a single page. But when the report is downloaded into Excel, it...

I need help to consolidate some massive data files. i will be really greatful to anyone who can give me a working VBA code. have spent almost 2 days trying, powerqueries,match etc etc. i am now convinced a well written VBA code is my only way out.. please help.. Here is the different datasets...

Hi All, I have a code in which solver is used to perform data envelopment analysis (some kind of operations method) for multiple decision making units (ranging from 1 to 22). However, in between solving for each dmu, I would like to copy the outcome generated by solver for each decision making...

Hi All, I'm trying to create a macro in order to load data from other excel files into a file. However, I get the error 438 'object doesn't support this property or...' Unfortunately I cant figure out what Im doing wrong because im not a vba expert. I used the following code. I underlined the...

hi, i have a user form with 5 textboxes, txtbox3 & txtbox4 is coded to do vlookups / index & match based on txtbox1 value txtbox1, 2 & 5 values can be typed or imported from another file. when i type in the details in the form, the lookups work perfectly but when I import the data, lookups...

Is there a way through vba I can hit OK or press enter in an external app? Sub GetBOData() Dim BOApp As Object On Error Resume Next Set BOApp = CreateObject("BusinessObjects.application") With BOApp .Visible = True .LoginAs "aaaaa", "Xxxxx" .Documents.Open...

Hi all. Can someone explain me the code i provided. I got this code from somewhere. Unfortunately, i'm still new in VBA and this code does not have comment. Thanks Sub EF1022331() Dim wsData As Worksheet Dim wsTarg As Worksheet Dim lngRC As Long Dim var...