| Thread | Last Post | Replies |
|
| am in need of an excel professional vba programmer | 26 Sep 2006 05:29 GMT | 1 |
If any of you out there are excel vba programmers or general programmers familiar with copy protection programming, I am interested in communicating with you. I have one excel file with 6 or so worksheets therein. I am interested in
|
| Modification in the CODE to HIDE rows and columns that start with ZERO (code given) | 26 Sep 2006 04:15 GMT | 4 |
I have been trying to manipulate the code given below to hide the rows and columns that begin with the number ZERO. But, I am landing into some sort of error. I know that the code given below works perfectly to hides any empty row
|
| Disable print not working | 26 Sep 2006 04:14 GMT | 2 |
I am trying to disable printing via the menu or tool bar and I see this response in a number of other posts. However it is not working for me. Any thoughts? Thanks. Alan
|
| Selection | 26 Sep 2006 04:14 GMT | 6 |
I want to select columnes from C to unknown. Thus, I want to define it like following: Range("C1").Select Range(Selection, Selection.End(xlToRight)).Select
|
| Importing TEXT file from web | 26 Sep 2006 03:51 GMT | 1 |
I have setup a list in MS Excel file as below Column B http://www.somewebsite.com/text1.txt http://www.somewebsite.com/text2.txt
|
| spawning Excel and giving it a Print Command | 26 Sep 2006 03:44 GMT | 3 |
Can you spawn Excel from an outside program (or command line) and pass it a filename as a parameter and ask that file be printed without opening Excel? I don't want any operator intervanetion. I want to be able to call Excel from an outside program (c#, .NET Application) and give ...
|
| Add PivitField to PivotCache | 26 Sep 2006 02:51 GMT | 1 |
Can I programatically add new PivotFields to a PivotCache. Where the PivotCache is linked to an external database? I would want to then add PivotItems to the new PivotField.
|
| Is there ADO "Help"? | 26 Sep 2006 02:37 GMT | 2 |
I program in VBA - and there's dynamic help, etc. But it doesn't extend to ADO. Is there any sort of "help" - web based or other?
|
| Creating #codes | 26 Sep 2006 02:32 GMT | 2 |
I am trying to turn email addresses into #Code strings, in order to stop bots from harvesting them.... To this end I have created the following UDF but the Excel function "Code() is not accepted. Placing "Application." in front of the word
|
| Loop thru woorksheets | 26 Sep 2006 02:28 GMT | 1 |
I need to loop thru each worksheet in a workbook and clear the contents except for the header row. Can anyone suggest a good way to do this in VBA? Thank You
|
| Can Excel pass variable from a spreadsheet to IE | 26 Sep 2006 02:14 GMT | 2 |
Is it possible to pass a cell value plus a "tab" character to IE to fill in a form online?? If yes, how? Thanks, Don
|
| Macro compatibility with Excel 97 | 26 Sep 2006 00:51 GMT | 6 |
Can someone help me. I created excel macros in Excel 2000, however when the macro is opened with Excel 97 some errors occur. These are some of them: 1.The following command gives RunTime error '1004'
|
| Changing Cell Color with macro | 26 Sep 2006 00:47 GMT | 4 |
Does anyone know how to change the cell color with macro in Excel 97. The following code only works in Excel 2000 Sheet13.Cells(1,2).Interior.Color = RGB(126, 255, 126) 'Grey In Excel 97, it gives the following error:
|
| Writing VBA code in Excel to Print Power point slides, and a PDF r | 26 Sep 2006 00:30 GMT | 6 |
Creating a print control file and printing reports from excel, power point acrobat was wondering if there was a way to priting the non excel reports using vba written in excel
|
| minimum value | 26 Sep 2006 00:12 GMT | 2 |
I want to save the minimum value of column B at "d" So i define. ============== Dim d As Long
|