Programming

Macro to change pivot field with latest value
Hi there and thank you advance for any help. I have written a macro that changes (hides / shows) fields on a pivot table. On of these changes the field used for the page fields section of the pivot table. However, when i add a field to this section, it defaults to All. How can have this field default to the la... 19 Feb 2010 04:23

Getting the name & path of a hidden WB
Hi, Is there any way to get the name of a hidden WB in which the code is written? Ofcourse using "Activeworkbook.Name" will give me the name of the active wb and since the wb I'm trying to get is hidden, it's not really active. I also tried "Windows(1).caption" but whenever I open another workbook the inde... 19 Feb 2010 06:33

Excel Files not opened
Hi, It seems that after running the codes below in excel 2007, no files are detected and opened from "J" path. In fact there are 4 excel files in "J" folder that need to be opened Does the code below miss out anything ? Sub OpenFiles() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Set ... 22 Feb 2010 04:10

finding matching text in different sheet
I am using excel 2007. I have to sheets... the column A on both sheets is filled with text. I want to loop throught each cell on sheet one.. and find the text on sheet2 and highlight or something. Last time I made it a hyperlink on sheet one and it would take me to sheet 2 if the value was there.... but I los... 19 Feb 2010 02:13

Change Number to Text , Case error when cell is String and format is General
Hi All How to check the cell is text or number ? When Cell is string, Case Excel close and recoveing. Sub FormatNum2str() '~~ 2010/02/18 Dim iRows As Long Dim iCols As Long Dim ir, ic As Long Dim iNum As Long Dim strVal As String If Application.Selection Is Nothing Then MsgBox "No Open Worksheet", vb... 19 Feb 2010 00:03

Populate combobox with folder names
I had found this code to show folder names that displays in a msgbox, is it possible to get the list of folder names into a combobox? --------------------------------------- Sub ListFolders() Dim fs, f, f1, fc, s Dim folderspec folderspec = "C:\Excel\" Set fs = CreateObject("Scripting.FileSys... 20 Feb 2010 09:07

Better protection for VBA project?
On Jan 17, 5:50 pm, Jan Karel Pieterse <jkpiete...(a)netscape.net> wrote: Hi Ron, Is there a better more secure way toprotectaVBAproject? Yes there is (misplaced the link to this one): .... 10. Go to Tools > Share Workbook .... 14. Press Ok to accept that "macros cannot be accessed" Regards, ... 22 Feb 2010 10:45

Macro that can sort out a variabel name among others in a row and
Hi I do hope that someone could help me with programming a macro in Excel 2003, witch would be able to lookup or sortout a name in a row among other names; Januray, February, Martz and so on. The macro has to lookup the numbers in four different sheets (but the same coordinates) Afterwards the macro has to ... 18 Feb 2010 17:23

How to start excel in "safe mode" programmatically
Is there a way to start excel in "safe mode" programmatically. I am creating an excel application instance as mentioned below:- Excel.Application excelApp = new Excel.Application (); I do not want to load add-ins and it's my understanding that the "safe mode" suppresses all add-ins. Also, I do not want t... 19 Feb 2010 20:00

A1-B1-C1=D1 BU FORMÜLÜ İSTİYORUM
A1= 500 olsun B1= 100 olsun C1=200 olsun D1 e otamatik olarak 200 sonucunu veren çıkarma işleminin formülünü bulmak istiyorum. bana yardımcı olurmusunuz? ... 18 Feb 2010 20:45