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 / September 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How to find the Day of week in a Month22 Sep 2007 08:38 GMT1
Good morning, How can i find the "Day of week in Month".
For example :
In this month if i enter the date as 01/09/2007 , is should reply - 1 (this
01/09/2007 consider as first week of this month)
How do I set up a progm that allows entry of daily tips.Waitress22 Sep 2007 08:28 GMT1
I am college graduate for computers.
I'm trying to figure out what program to use and how to use it.
I have a brand new laptop compaq presario notebook.  I want to be able to
log in my acual tips each day and be able to store them in a program.....
OpenText Method with "StartRow" as a variable22 Sep 2007 05:00 GMT2
I need to parse a text file and paste the result in the active
workbook.  I need "StartRow" to be the same row (a variable row
number) that contains the word "SALES" in the text file.  Is this
possible?
Displaying A custom menu as a popup menu22 Sep 2007 04:40 GMT5
I've created custom a custom menu with various macros, how can I display this
as a popup (shortcut) menu when a cell is right clicked?
Writing array data to range object always writes 0's on worksheet22 Sep 2007 03:54 GMT5
Hello Excelers!
I have a program that subtracts time values on a worksheet and is
SUPPOSED to write the diff
to a worksheet row (same column).
Automated Search and Replace; Sheet2 to Sheet122 Sep 2007 03:48 GMT3
I have a customer spreadsheet with over 5000 rows in it.   Each week I get
information that needs to be updated (100s of rows).  The new information
contains Customer Number and Paydate.   I manually search for the customer
number, located in column C, and then update the PayDate ...
Pivot Table Data format22 Sep 2007 03:17 GMT1
I have a Pivot Table and of course when I double Click one of the
totals it fires up a new worksheet with my data. I have a Macro that
formats the worksheet the way I want it to look for printing. Is the a
way to fire up the macro when I double click one of the totals.
Creating a toolbar that works in Excel 2000 and 200722 Sep 2007 03:01 GMT3
Could someone please point me to sample code that generates a toolbar that
will work in both 2000 and 2007? Until 2007 the following code worked well:
 With Application.CommandBars
   With .Add(mcstrToolbarName, , False, True)
adding multiple spreadsheets onto one to sum up values22 Sep 2007 01:01 GMT1
i need to find a way of copying 4 or 5 spreadsheets together to the the total
sum value of all spreadsheets any ideas??
Address Referencing21 Sep 2007 23:13 GMT1
When generating a formula for a given cell through VBA, I need to be able to
combine a relative reference (of form of R[x]C[y]) and an address retrieved
from a different sheet (of form Sheet1!A12).  When the VBA accomplishes this,
the cell reference is invariably returned as a ...
Pass array of sheet names to subroutine21 Sep 2007 22:48 GMT7
I want to insert a row in one or more adjacent sheets.  I have written a
subroutine:
Sub sbrInsertRow(ParamArray avarSheetSub() As Variant)
   With Worksheets(avarSheetSub())
Max Name Ranges Allowable in Excel 200321 Sep 2007 22:34 GMT1
Dear All:  Does anyone know the maximum number of name ranges that I can
create in Excel 2003.  Thanks!
Import Web Page21 Sep 2007 22:19 GMT1
This is what I am Using at the moment.
Sub Import_Web_Page()
 Dim strDriver, intCount, intLastrow
'Import Webpage with external data query
Copy and Past Macro21 Sep 2007 22:18 GMT3
I have a formula that looks for matching criteria (in cell I1 vs.
Column A) and copies the values to the right of it and pastes them in
E (starting with E1).
What I need to do is the same except the last part (starting with E1).
Clear print preview dotted lines?21 Sep 2007 22:00 GMT1
After I did a print preview, dotted lines appeared on my spreadsheet
indicating where the page breaks will be when I print. How can I clear them?
Thanks.
 
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.