Programming

Excel 2007 Chart in VB6 Program
I have another thread in the VB group and was told to post to these two groups so sorryfor the multi-post. Ill post there again just in case folks want to follow the thread. So I've had a Visual Basic 6 app (as an EXE) that has worked great for the last 9 years or so. Up until Excel 2003 I have had to make minimi... 19 Jul 2008 11:57

txt-file is in ANSI format or OEM Character format.
Hi NG. Is it possibel, in VBA, to know if a txt-file is in ANSI format or OEM Character format. Is this possible to save a txt-file (ANSI format) to OEM Character format. -- Best regards from Joergen Bondesen ... 21 Jul 2008 16:10

linking external data
hello, how can I link external data (from Access tables) without referring the DataSource to a fixed path, but to the Workbook path by VBA code? Now I refer to a fixed path (e.g. C:\P1) containing the workbook and the mdb files and the workbook refreshes the data external links at the opening, but if the wo... 20 Jul 2008 06:20

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