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 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Hide Buttons When a Cell is False24 Jan 2008 20:12 GMT2
Is there a way to hide and unhide buttons when a cell is true/false?  I use
this all the time for regular formulas within excel, but am not sure if it is
possible to hide actual buttons.  Any help would be greatly apreciated.
Thanks
Copy/Paste Charts; Define Destination of Charts in PowerPoint24 Jan 2008 20:04 GMT2
I found this snippet of code on the web (thanks JP):
Sub CopyChartsIntoPowerPoint()
''' COPY SELECTED EXCEL CHARTS INTO POWERPOINT
' Set a VBE reference to Microsoft PowerPoint Object Library
importing more than 65536 rows from .csv file24 Jan 2008 19:38 GMT1
Hi
I am trying import a .csv file which contains more than 65536 rows. I
created a macro to import and it is successfully importing with out a text
qualitfier.  can any one help me  how to import huge .CSV files to one excel
Calculation/Number Bug in .xls? Any ideas?24 Jan 2008 19:37 GMT4
I just stumbled across this problem - i can sort it out using a
rounding calculation but anyway i was wondering if anyone had a clue
why it's happening.
so, could you please let me know why this code fires "Not match"?
Check if workbook open (Not working)24 Jan 2008 19:23 GMT3
My program starts with a simple form to create a new workbook or open an
existing one. Once you do either, the form disappears and either opens or
starts an new workbook. Once you close either the newly created workbook or
the existing one, the form re-appears asking you the same ...
Copy IF condition exists24 Jan 2008 19:00 GMT6
Is it possiable to Copy and paste if  a specific condition exists?
Heres the problem in column "F" there is a number. If that number is less
then 61 i would like to move the entire row to another sheet. also the range
will change with the data. can this be done?
Delete Last 10 Rows in Worksheet24 Jan 2008 18:20 GMT8
I need a macro that can delete the last ten rows in the worksheet.  Column A
will always contain information on the last row, but has a lot of gaps in the
rest of the column.
Groups in Option buttons24 Jan 2008 18:09 GMT15
I would like to know how I can get the data from a group of option buttons.
I have a group of 8 optionbuttons with the names "e1" through to "e8", the
name of the group is "expenses"  I am not sure how to use or if I can use a
groupname vba. I am looking to have reason.text show ...
Handling Errors When Opening Word Docs From Excel VBA24 Jan 2008 17:55 GMT1
I have written some logic in Excel VBA which opens Word files and then
does some processing.
I am having trouble catching all the errors from opening the Word
files - my code is:
Help Fixing a Macro24 Jan 2008 17:51 GMT2
I'm hoping someone could help me fix a Macro that is giving us problems.
The Macro is probably badly written in parts (well the parts I have added
anyway) because my VBA knowledge is poor at best.
Basically the Macro imports a large csv file, converts the imported data to
Need to get value of last number in a column24 Jan 2008 17:46 GMT2
I submitted this an hour ago, but it was never posted -- and so I apologize
if it shows up twice.  I have a column(s) of portfolio values, updated daily
or weekly.  I want to find the last number entered in the column so that I
can compare it to the beginning of the year ...
VBA solution required?24 Jan 2008 17:37 GMT2
Hi;
> > > > > I would like to know if there is a way to total items from one column from
> > > > > different dept. numbers in another column.  I will try to give an example
> > > > > below:
List objects and Buttons24 Jan 2008 17:34 GMT4
I have a list object over a Button is there a way to keep the listo boject
from rolling over the button? I have tried the Object positioning settings
under format control with no luck. I need to have the button move down as the
list grows.
Selecting a dynamic name24 Jan 2008 17:21 GMT1
I'm looking for a relatively easy way to select dynamic named ranges.  I
know that you can type the name into the name box, but I don't always
remember exactly what the name is.  :-)
My thought was to build a form and populate a combo or list box with the
Using Variables in R1C1 formulas24 Jan 2008 17:09 GMT1
I am trying to create a formula in a cell to set the value of the cell equal
to another cell that is a varible number of cells away.
for example
Dim x As Integer
 
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.