mytable

Hi, How to refer Application.WorksheetFunction to the variable which represents column of table? This macro works perfect: Public MyTable as Object Sub test () Set MyTable = ThisWorkbook.Worksheets("Sheet1").ListObjects("MyTable_table") Msgbox...

Hello All, Hoping someone can help me. I have created, with the help of experts on this site, a macro which takes some ranges in the Excel and then creates a Word document where the ranges are pasted as tables. I am running into a problem and in searching I find that the problem is not...

I got the below macro from a old thread. I have the lines on the html page files saved on c drive, which are supposed to be in a table format but they are not and there is no separator between each column data except some undefined spaces as shown in below image, so how can i import it as a...

Is there a way to reference an excel table via an OLEDB connection. For instance if I have a workbook with a single worksheet named Sheet1 and on that worksheet I have created an excel table named MyTable, how do I Select,Insert, etc to MyTable via OLEDB. Once I make my connection I know I can...