Hi,
In VBA, is it possible to identify the name of the active shape on a spreadsheet (specifically, a form control button)? How?
Thanks!
-Michael
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23418952.ht...
Zones:
VB ScriptDate Answered: 05/21/2008 Grade: B Views: 38
Hi, In VBA using the file system object, I want to list all folders and files in a specified folder. I know the syntax to do this. I.e For Each File in Folder.Subfolder.files. However It only retu...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 06/26/2008 Grade: A Views: 95
i have excel 2007 , and i saw this link which explains about data-mining in excel 2007 via add-in.
does someone knows how can i get this add-in or what needed to do to install it?
this is th...
http://www.experts-exchange.com/Database/Data_Manipulation/Data_Mining/Q_23219376.html
Hi,
I'm trying to sort a range using the attached code. The range's first row will change during use. I don't want to name the range.
The variable ModuleSortRange returns: "N709:N712".
I ge...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23426179.ht...
I have a macro that creates a 'CommandBar' object. But when trying to add the 'OnAction' method to a 'CommandBarButton' I recieve following error:
Runtime Error -2147467259 (80004005)
Method 'OnA...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 06/13/2008 Grade: B Views: 61
Greetings,
I am using the following bit of code to display search results in a listbox. I cannot seem to wrap my head around creating a similar sub to display all the dates between a start and s...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 07/24/2008 Grade: A Views: 0
I hate writing code in vba, but this time I need to implement some additional functionality in Excel so I don't really have a choice
Here's my routine
Function BS_Near(dDist As Double, DistArray...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23583632.html
I have the following small sub that highlights numbers in the range if they are above or below the stated values. However, it also highlights my field headers, how do I alter this to execute only ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi,
In a spreadsheet cell, I have: 2,4,6,8,10.
Is it possible to fill 5 spots in a VBA array with these values without looping?
Right now, it sees them as a single string, so Array1(0) = 2,4,6,...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_23736436.ht...
I am at the planning stages of a project which will evetually be distributed to many users in my company (over 150). Without getting into too much detail about the project I need to know whether us...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23784709.html
