listobjects

Hi, I have some code that will go through a table and delete the fields that I have deselected on a different tab. The part where I am having difficulty is the ListObject.ListColumns(#).Delete part. The problem is that the # changes, but I haven't put it in my code correctly to dynamically...

I've tried to import data with following code With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array("DSN=db_name; UID=user_name; PWD=pw;"), Destination:=Range("$A$1")).QueryTable .CommandType = xlCmdSql .CommandText = Array("SELECT * FROM table") End With...

I try to delete all the rows in my table. I would be preferable not to delete the entire row, but only the in the table, but I guess it's not possible. When I use the code below it does what it should but ends with an error "Run-time error '1004': Application-defined or object-defined error"...

How can I fill an Excel table with data from my Access database? I know how to connect to the database and defining my recordset, but don't know how to handle the tables. Can I do something like ListObjects("Table1").Cells.objRecordset.GetRows()?

Hello, I've looked for a solution to a problem I'm experiencing in a variety of places and just can't quite seem to get the one I'm looking for. I feel like it should be pretty simple. I have a series of nearly identical sheets that each have multiple Tables (ListObjects) - they all have a...

Folks: How do I use this formula in excel vba...: ActiveSheet.ListObjects("Table_Dyna_1").Unlist ...If I don't know the name of the table, or the table name will change? Like maybe today the table name is "Table_Dyna_1" but later it could be "Table_Dyna_1_1" or "Table_Dyna_2" (probably...

Dear Experts, I have little experience with VBA and believe I am stuck on a basic level. I like to read a set of columns in a row and add the read data to a specific table. The value in one of the columns decides to which table the data should be added. I manage to create a table but I am...

I like the functionality of tables (ListObjects) but haven't found much documentation to unlock the power of them in VBA. I declare each table as a ListObject but can't figure out how to use the [[]:[]] technique, so I resort to hardcoding column offests. The issue at hand is I need to clear...

I have a workbook which contains one report. Each day I copy and paste this report in a new sheet. I've been updating this workbook and here's my problem. I use a table, and have some auto sorting taking place. Whenever i create a new sheet, My table name is static at "Table1". Can i use VBA to...

Hi. I've got a workbook, with a sheet 'tblPrices', which has a listobject named 'Prices'. I'm having problems with a code that I'be simplified as follows: ... With ThisWorkbook.Worksheets("tblPrices") .Activate With .ListObjects("Prices") .Range.Select Debug.Print...

Hi all, I am troubleshooting badly with the following code and I can't figure out why? The last line gives run-time error 1004; problem with the sort key. I am using excel 2003. The code is in a private sub on a different worksheet than where the List is at, thx in advance guys!

Hi All, Here's the short question: the SharePointURL property of ListObject is ReadOnly. I wanna change it! The long version: I have a SharePoint site where many months ago I did the "Export to Spreadsheet" command. I've since done lots of work on this file, including code that lets the user...