Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / April 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Populate ListBox with Filtered Records28 Apr 2007 03:12 GMT2
Using Excel 2003.
I have a database worksheet named Projects, with three columns of
information: Id, Name, and Location.  The worksheet currently has over 200
records.
.Xla Password forgot....!28 Apr 2007 03:06 GMT1
I have forgot my .xla password.
Could some one talented from the group retrieve it...?
Thanks,
Thyag
Automatically create new sheets...28 Apr 2007 03:04 GMT1
I have a spreadsheet with Data that looks like the following...
      A                      B                                C
1 Sheet 1          Description1             Unit of Measure 1
2 Sheet 2          Description2             Unit of Measure 2
Sorting chart by name28 Apr 2007 02:42 GMT5
I have some 15 charts in a spreadsheet along with some data. I want to
reposition the charts in 3 rows and 5 col. I achieved this but the
issue, position of the charts get exchanged once i run the macro.
For example, after "Chart 4" is repositioned, macro selects
Protecting whole workbook28 Apr 2007 02:14 GMT5
Hi,
I have a workbook with approx 30 worksheets and have protected each
worksheet with the following macro's
Private Sub Protect_Workbook_Click()
Regex techniques28 Apr 2007 00:17 GMT5
I am still struggling with the use of the RegExp object in the VBScript_55
library, in Excel/VBA.
In my "old" regex processor, BKReplacem, I could use special characters such
as \n in the REPLACEMENT string, not just the search string.  But that does
Problem managing Enter Key behavior in a userform28 Apr 2007 00:11 GMT1
I have a userfrom that contains three combo box lists and 8 text boxes.
My user uses the comboboxes to select from lists of values. They then enter
data in to the text boxes.
Finally they select a save command button to save all the data to a row in a
Using Do Loops to copy data27 Apr 2007 23:52 GMT7
I need a bit of code that will search through each cell in a column and look
for “Agent Name:” then choose cell to its right and create a new sheet with
the value of the selected cell as the name.
Below I have added what I tried, which obviously did not work. Any help on
Macro to find a word and copy all rows with this word to diff ws27 Apr 2007 23:16 GMT3
I'm trying to create a macro to run a search based on info put into an input
box and copy all of the rows  from column A to column M containing this info
and paste to a specific worksheet.
The worksheet that the info will be found in will always be the same format,
Calendar Control - Years27 Apr 2007 23:01 GMT6
Hi I've used the tutorial at www.fontstuff.com/vba/vbatut07.htm to set up a
calendar for date selection in a cell.
I've used an earlier posting (12/5/2006 6:28 AM Calendar Control) by Tom
Ogilvy to pick up the Friday of the week for any date selected.
Referring to two different open worksheets in code27 Apr 2007 22:42 GMT8
I'm in a bit of a quandry and I'm sure someone here can help me out.
I have the following snippet of code:
With Application.FileDialog(msoFileDialogFilePicker)
   .AllowMultiSelect = False
Fun with SubTotals27 Apr 2007 22:40 GMT3
I am trying to run a subTotal function on two columns of data.
Column 2 has our Techs names and Column 3 has status info.
First I subtotal the Techs and then the status. Everything works well
in Excel 2007.
Left Right Mid27 Apr 2007 22:34 GMT6
I have data in cell A1 that looks like this. I want to be able to
seperate it with the left right mid functions into B1,C1, D1, E1, F1,
and get rid of the comma's. Any help would be greatly appreciated.
25632, 27865, 456456, 987456, 789456
clearcontents problem27 Apr 2007 22:32 GMT4
I am using a commandbutton_click sub on a specific worksheet to automate some
reset features on a timesheet I've built.  I want to be able to clear and
reset values on other worksheets in the same workbook at the same time.  
Inside the commandbutton1_click sub on "Sheet1" I use ...
Presetting options when opening Excel27 Apr 2007 22:28 GMT3
I want to open Excel and run a program that has some sensitive material. I do
not want the user to do anything without using buttons that I have developed.
I would like to make sure that all the toolbars are removed and most of the
menu items bars are not useable. I have to do ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.