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 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Conditional Format assistance?18 Apr 2008 16:19 GMT4
Condition formatting is getting the best of me at the moment.  I need
to set up a Conditional Format that has 3 rules.
1. if the number in the cell is >= 85% then the background of the cell
needs to be green
execute a make table query in an access database18 Apr 2008 16:07 GMT1
The basic idea:
I need to run an existing make table query in a database without the user's
intervention.  I have tried some code I have found online but none work (thus
far).
Multiple Conditional Formatting in VB18 Apr 2008 16:01 GMT7
I need to add a set of formats to a column but based on IF statements. For
example, I have column A (Date Raised) and column I (Date Acknowledged), I
want to be able to colour the cells based on what date was added to column I
e.g:
Show Image When File Opened18 Apr 2008 15:55 GMT1
How do I show a logo image for a few seconds each time a file is
opened?
Cheers
Tony
Problem with formating18 Apr 2008 15:35 GMT7
I have an array that contains string values.  When I put one of these values
into my spreadsheet it changes to Scientific.
Dim DataRow(12)
DataRow(9)="201E-13"    ' for this example
VBA code to run & wait for cmd line interface application18 Apr 2008 15:21 GMT1
I want to get started with the shell command to run my process below under 1
VBA subroutine. I've just started looking at methods to wait for the external
application to complete. Any pointers would be very welcome.
Thanks
Macro18 Apr 2008 15:19 GMT10
I receive, daily, a spreadsheet with a lot of data. In one column, all the
cells contain numbers and text and I want to change this to reflect the
numbers only (which must represent values). The text portion is always the
same in all of the cells. I have recorded a macro which ...
Range.Find gets slow18 Apr 2008 15:05 GMT19
After I use Range.Find method programmatically, the standard search on sheets
dramatically slows down. What could be the reason and how can this side
effect be taken out? Thanks!
After I use Range.Find method programmatically, star=ndard   it searches
enable macros without them running18 Apr 2008 14:49 GMT2
In excel 03 I just held down SHIFT while clicking ok on the enable macro
option, but I have upgraded to excel 07 and this doesnt seem to work.
I need to run macros while I am editting the workbook. How can I do this
with excel 07.
Variable not set18 Apr 2008 13:57 GMT4
I have this macro running from a commandbutton in sheet2, it gets a
concatenated string and look it up in sheet24 once found retrieves datum from
sheet24 and shows it in an userform
I'm getting the variable/block not set error for rFound, cFound is working
Shell or shellexecute18 Apr 2008 13:53 GMT1
I want to open A.dwg and B.dwg files in different moment from VBA
excel using Shell.
I use the following line and it works right:
RetVal = Shell(GstrPercorsoCad + " " + GstrFileAorB, vbMaximizedFocus)
MATCH function, with variable lookup_array18 Apr 2008 13:50 GMT12
Is there a way to select a variable lookup_array.
This is the situation.
Input:
Dia: 130 (e.g.)
Hyperlink Help18 Apr 2008 13:45 GMT1
I'm trying to create a hyperlink to open another workbook and so far i have
got this code:
Sub Hyperlink()
ActiveWorkbook.FollowHyperlink
Limit an GoTo Function command18 Apr 2008 13:44 GMT1
I am writing VB code in Excel to reformat a number of Excel spreadsheets.
There's a section of the code where I have inserted an "On error GoTo
Function" command to skip past a section of code if certain requirements are
not met. However, if my code errors at any other place than ...
OLEObjects: Adding jpg Object18 Apr 2008 13:44 GMT5
Is there a way to add a jpg object on a cell?
I'm using Paint.Picture but the image is in bmp.
We are trying to minimize the overall size of the excel file.
We have been using word document before, but we jpg is a much smaller file.
 
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.