#vba #excel

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