Programming

Macro to delete rows
I'd appreciate some help in creating a macro to delete rows. Here's what I need: 1) Delete rows 1-13 2) Then find all rows that are highlited blue and delete them 3) Then find all rows that include the text "Distr" and delete them Suggestions? Thanks in advance. ... 18 Mar 2010 11:43

Set certain cells to print and others not to print
I am working on a form in XL2007. The form consumes one 8.5 by 11 page. I would like to set certain cells to be visible on screen, but not print their contents. This would need to be done almost on a cell by cell basis. Is something like this possible? Thanks! ... 17 Mar 2010 18:43

Excel automation fails from PowerShell when PIa are installed.
Below Script to automate Excel runs fine if PIA are not installed. $xl=new-object -comObject Excel.Application $file="D:\test\test.csv" $xl.visible = $true $wbk = $xl.Workbooks.Open("$file") $wks = $wbk.worksheets.item(1) $r1=$wks.Range("A1:D1") $r2=$wks.Range("A2:D2") $xl.Union($r1, $r2) If PIa are ... 17 Mar 2010 10:14

Need Help with a cell?
I am trying to get all the cells to change on 45 tabs when I type something in the cell on the main page... P.S. I got the date to do it but when it comes to text I can't find the right code to use any help would be great... ... 17 Mar 2010 14:47

List of tables in SQL server database
Hi, How do I list all user tables in a SQL Server database? Once done I have to passon some commends also to all the listed tabled. I already have connection strings and also able to extract records as pe the criteria from one defined table but do not know how to loop thru the tables or table properties. Any... 27 Mar 2010 12:00

change date in a sql statement from a cell
Hello, I am using Excel 2007 I have a pivot table that gets refresh everyday. The data from the pivot table is based on a sql statement, which the data is connected to a AS/400 table. Here is my problem every morning I go in the connection properties and change the SQLstatement (date) in the command text. ... 22 Mar 2010 14:16

Matching Data between 2 Tabs on Same Workbook - then calculating
I am a total newbie with this stuff so I am hoping someone has the patience to assist me. I have a workbook with 2 tabs: Tab 1 is called Historical. Historical has 2 columns. Column A1 is "Date" and Column B1 is "ZAR to USD." Historical has a Date (MM/DD/YY) in cell A2 and a number value in B2. The data from bot... 18 Mar 2010 00:31

Determine number of rows with data
Hi I am using the macro below to pull some data from an external workbook. The 2 issues I need to sort are: 1. The number of rows in the external workbook can vary. How do I amend this code to pull all of the rows with data? 2. The number of rows in the autofill also may vary. How do I autofill only the number ... 18 Mar 2010 16:39

Self Signed Digital Certificates.
I would like to move the self signed certificate that I created on my work computer, over to my home computer. So that I can sign the macros that I write on eaither computer. ... 17 Mar 2010 13:39

Remove Focus from Form
I have a form that pops up on a spreadsheet whenever certain cells are selected. It is strickly informational, and I show it modeless. After it displays, I can still click back on the spreadsheet and enter information, but I would like for the focus to remain on the cell on the spreadsheet rather than go to t... 16 Mar 2010 18:37