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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Programmatically calculating formulas for new entries30 May 2007 18:42 GMT1
I have a series of data that is imported into specific rows/columns.  There
are a number of calculated columns, that for now, i have to copy and paste
down to each new row.
Question:  is there a way to have the calculations done with out having to
copying sheets30 May 2007 18:37 GMT3
Can I copy Sheet1 from one workbook to Sheet1 in a new workbook?  Thank you.
Signature

Kevin C. Brown
Developer

Count30 May 2007 18:05 GMT2
Hi Experts, I have a question.
if column A has letters A, B, C or D multiple and column B has numbers 1, 2
or 3.
Column A    Column B
disabel print preview30 May 2007 17:58 GMT5
Hi ....
please help me wi this problem........ in Microsoft Office Excel 2003 i need
to disabled the print botton that it appears available when is selectec to
the option of print preview. I am developing shared add-in in visual studio
modifying code troubles30 May 2007 17:58 GMT1
Hello again,
I  got some partial help, but I am not sure how to apply the advise.
I use the following code to import the values contained in a specific file
called 'Copreco Daily Reading Submission'
Type mismatch when copy empty cell to Access database30 May 2007 17:51 GMT1
I got a code to write data from Excel to Access database, but got a "Type
mismatch" when copy cell B2 to "Dispatch_date" field in database, if B2 is
empty. The setting of "dispatch_date" in database requires no input. Please
help.
Open a menu30 May 2007 17:49 GMT2
I am wondering the code to open up the menu option of insert a picture from
scanner or camera.
Thanks
Greg
shared document: protection issues30 May 2007 17:39 GMT1
I am writing a little VBA program that should enable two users to fill in
data on a shared wkb. I am a fan of shielding the actual data on the
worksheet(s) from direct access by the users by an interface (userforms).
Thus, the worksheets are protected, and the data are submitted ...
Check for a shape - then change or delete it if it exists30 May 2007 17:37 GMT2
I have a spreadsheet which contains lines that have been drawn using vba.  
During the drawing the process they are named like this myLine.Name = "Arrow"
& CStr(PasteRow).  The variables "myline" (shape object) and "pasterow" (long
number)have been declared and defined.  When ...
Buttons Embedded in a Worksheet30 May 2007 16:53 GMT3
OK - I know - This is probably a basic questions for you experts, but I would
like to know how to add buttons to a worksheet that hide and unhide specific
colums, and how these commands/buttons are created.
I have inherited a workbook that someone else created, and now I need to ...
Font of Check Box (from Form Toolbar)30 May 2007 16:20 GMT3
Am I going mad? (don't answer that)
I'm trying to change the font of a check box applied to a worksheet from the
Forms Toolbar.  Can It be done, either with VBA or using the font menu...  If
so, how.
Help with Find function30 May 2007 16:14 GMT3
I really need some help here. I am trying to find a "(" within a text string
in a column, but I get a #VALUE! error when I use it.
=FIND("(",A2,1)
How can I find the ( if it thinks it's part of the formula boundries? Please
another querytable.add question30 May 2007 15:17 GMT2
nobody was able to answer my last one, maybe i'll have better luck with this
one:
when importing data from a dbf file, how can i limit the records imported to the
value in one of the fields?
VBA replaces formula but adds row in multiplier30 May 2007 15:06 GMT6
The formula in cell V2 is:  
=IF(BB2="SURG",(IF(H2<13,"No Outlier",(H2-13)*5128)),"Go to Med")
The VBA below, copies the formula down into other cells but it replaces the
multiplier of 5128 by inserting the row number into it.  For example if
copy the range names while coping cells30 May 2007 15:00 GMT1
i need to copy an area from one workbook to another. that area in cludes
cells that have range names.i need a way to copy the range names as well. not
only the formating and the data.
do you know how i could do that?
 
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.