Programming

Learning excel programming
Can anyone suggest me a good book / website on Excel Programming. I do not know programming of any kinds but am interested in learning how to use programs in Excel. Nikhil ... 19 Jul 2008 18:06

How to output a textfile format in such design
Hi all, I'm new for doing Excel programming. Can someone teach me how to output a text file which the output design should be like this: Fruit01072008 Apple classA;5000 classB;6000 classC;7000 Orange classA;1000 classB;3000 classC;5000 Strawberry ClassA;850 ClassB;1000 classC;1299 In the Excel ... 19 Jul 2008 09:54

Copy and Paste Problem
Below is some code I'm trying to get to copy a worksheet from one workbook and add it to the end of a worksheet in another workbook. The problem I'm having is in the paste. Windows or Office, not sure which, gets into a loop display a message saying it can do the paste because the system, or workbook is bu... 19 Jul 2008 23:13

Help Excel 2003 code failing in 2007
The code below ran in Windows Excel 2003 but stops in 2007 at the line starting with; Selection.Characters.Text = "Click to Run" & Chr(10) & "all macro's automatically." Could anyone point me as to why? I have recorded the operation in 2007 and the line records the same as 2003. Dim dWidth As Double Dim d... 25 Jul 2008 11:27

create exe file
how to create a stand alone exe file from an excel workbook that has macro in it.? ... 19 Jul 2008 05:49

File not found (error 1004)
I modified some VBA code to find an Excel Workbook file in a directory hierarchy and open it. When I attempt to open it, it says it cannot find the file. However, a message box just prior indicates that it can indeed find the file. I capture the filename in a string s: s = Dir$(currdir, vbDirecto... 19 Jul 2008 02:45

Error 1004 setting xValues repeatedly
Have bumped into a problem using VBA to set xValues in bubble charts in volume (Excel 2003 SP2 in WinXP). Have a query sheet attached to an Analysis Services cube. From that I generate 13 bubble charts with approx 10 data series in each. The user can rerun the query for different sets of data and regenerate the... 18 Jul 2008 20:38

Refreshing a listbox
I have been stumped with a listbox added to a worksheet using the control toolbox. I have been having problems refreshing the listbox when the data range is changed. I have been using the following code to refresh it: Sheets("name").OLEObjects("Listbox1").ListFillRange = Range("rng").address I have been get... 19 Jul 2008 07:51

Re-Post: Embedded Word File
I have an Excel File that has an embedded Word File in it. The embedded Word file contains a table with say 5 rows and 3 columns. Additionally, in this file I have a text box (Textbox1). I am trying to copy the contents of Textbox1 to Row 2, column 2 of the table within the embedded Word file. I have don... 20 Jul 2008 15:33

Finding empty cells
I have a workbook with 10 worksheets (tabs) each with a Header Row with the month of July dates across the top and a Header Column with other information running down the side. What macro would search all 10 sheets for the last date (column) that might have an entry from any of the rows, search back from there... 27 Jul 2008 14:32