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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Recover Password29 Jan 2007 21:30 GMT1
Is there an easy way to recover/remove passwords for sheet protection?
A list of software in Excel to show as header29 Jan 2007 21:21 GMT1
I have a spreadsheet look as the following:
Name         Title     Dept      Software
Annie Hall   Clerk    ACCT     Adobe 7.0
                                        Office 2003
transfer data from word userform to excel29 Jan 2007 21:15 GMT1
Does anyone know the proper method to transfer data directly from a
word userform to an excel spreadsheet.
I have the code below but am having no success...any feedback to
point
Read values from an Excel Table?29 Jan 2007 21:03 GMT3
I currently have a module that I created that reads a text file, parses it,
saves it as a temporary workbook, processes it and then saves a final
version.  Works great.
However, there are four codes that I need to look for in my processing.  
Looping with incremental variable/object names29 Jan 2007 20:14 GMT3
right now I have code similar to below:
Variable1 = Form1.TextboxWidth1 * Form1.TextboxLength1
Variable2 = Form1.TextboxWidth2 * Form1.TextboxLength2
Variable3 = Form1.TextboxWidth3 * Form1.TextboxLength3
Emailing Help29 Jan 2007 20:08 GMT1
Hello,  
I was wondering if anyone could help me.  I am trying to get a code to copy
a worksheet (command button on one sheet [named home], the sheet I'm trying
to copy is hidden[named hidden]), paste special to a new worksheet with
Emailing a worksheet29 Jan 2007 20:08 GMT1
Hello,  
I was wondering if anyone could help me.  I am trying to get a code to copy
a worksheet (command button on one sheet [named home], the sheet I'm trying
to copy is hidden[named hidden]), paste special to a new worksheet with
Wrap text doesn't work when sheet is protected29 Jan 2007 19:58 GMT2
I have been working on a employee review form that has unlocked merged cells.
I have the following event code that fires when there is no sheet
protection.  However, as soon as I protect the sheet, the code doesn't fire.  
If I unprotect after the text has been entered, then it ...
page break location in VBA29 Jan 2007 19:47 GMT1
How do I find the row number of where a horizontal page break is located for
a given page number on a worksheet.
ive been stuck for 2 days29 Jan 2007 19:08 GMT9
i have a single page worksheet with various information that
automaticly changes and sorts based on another worksheet. whith that
said here is my issue
i need a script that checks wether there is information in colum (A).
Problem programming .SeriesCollection().XValues and .Values29 Jan 2007 19:01 GMT7
Hi everyone.  I am having a difficult time programmatically assigning a named
range using the method SeriesCollection().XValue and SeriesCollection().Value.
I keep getting the following error message, "Run time error '1004' Unable to
set the Values property of the Series class.  I ...
VBA code to open and copy a file29 Jan 2007 18:38 GMT3
Is there a way to take the date entered by the user in cell C6 and write code
to:
1) go find the file name that contains that date
2) open that file
Userform: Display Scrolling View of Columns A:C29 Jan 2007 18:37 GMT1
Is it possible to have a Userform display ONLY Columns A:C, with a scroll bar to view values ?
(Like a small window to another sheet)
Generate Random Groupings from List29 Jan 2007 18:21 GMT10
This may be hard to do and a deck of cards may be my only answer
In Column A I have a list of names - potentially up to 32 (never any more)
What I need to be able to do is go thru that list and generate 4 even
groups, so for example if there were 20 names in the list it would ...
Opening excel29 Jan 2007 18:04 GMT4
does excel all ways want to open on sheet (1) is there a way to change it.
Know I cna copy all data to another sheet. That means I have a lot of
references to change also. This is reason to change opening page.
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.