excel.workbook

  1. J

    dataformat error power query when doing Excel.Workbook

    I have 5 files that have the same structure. (Num of columns, data tape etc...) I'm trying to load them from folder with Excel.Workbook ,in 3 of them the table extructed fine and in 2 I get error and I couldn't find what is the problem
  2. N

    Subscript out range

    I am getting a subscript out range error on the line Set wsLr = Workbooks(wsName).Worksheets("F17-F18 Releases") in the following code can any one help Public wbSrc As Excel.Workbook Dim wsSrc As Worksheet Dim wsLr As Worksheet Public wsName As String Private Sub Filter() 'Dim...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    • Started by PabloFer
    • Replies: 32
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    • Started by Sleeplol
    • Replies: 24
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    • Started by johnsonk
    • Replies: 22
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    • Started by Dellboy
    • Replies: 26
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    • Started by ipbr21054
    • Replies: 22
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    • Started by Ramballah
    • Replies: 22
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top