Forum

I suggest changing the first code: Sub SaveAsRegularWorkbook() Dim wb As Workbook Dim Path As String Dim Name1 as string, Name2 as str...

Hi Ahmed, Each application needs a different search method. What are you using to open PDF files? Do you have Acrobat or the free reader only? A...

Hi Tanya, The reason for duplicates is a filter applied in the source file. That FilterDatabase needs to be removed before reading data from sheets...

Hi Mamie, If you can provide an example of the data you have, before any transformation and how it should look like after transformation (a manual ...

See file attached for an example.

Not tested, but should work: For i=wks.range("STMTRNG").cells(1).row to (wks.range("STMTRNG").cells(1).row + wks.range("STMTRNG").Rows.Count)

Hi Mamie, Looks like a survey monkey download, is that correct? In this case, you can try the SurveyMacros attached. Found it on a forum a while ag...

Hi Jose, You did not copied the complete code as posted above, the delete method and the procedure closing statement is missing: .Delete End ...

Nothing attached, you have to press the Start Upload button, after Select Files.

There is everything you need in that page, step by step instructions to get started, including a functional excel file for download, so there is a lot...

It's because you can't use internet explorer specific vba syntax to program another browser, it's like trying to put truck tires on a bicycle. Here...

Hi Gli, To create bins in DAX, you can use this formula in a new column of your Testenvironment table: = SWITCH( TRUE(), Testenvironm...

Hi Jose, Posting a sample file will always help you get a faster result, otherwise we will have to recreate your structure and that will always be ...

Ok, seems like it reads named ranges, you can right click the first table and add as a new query, same for second table, drill down until the result o...

You cannot connect to named ranges from external books. Why don't you add a new column in the source table you have, with the formula=NamedRangeNam...