Customize Ribbon with excel interop0770 (11/17/2009 9:31:01 AM) UtfHi everyone,
I am developing a c# application, which is created from an excel workbook.
In the VBA code of the workbook, my assembly (a class library project) is
created, a class instance is created and ...
how to loop through shapes in powerpoint vba14782 (11/17/2009 8:17:52 AM) vickyhey i have a slide which contains different shapes . i need to loop
through all the shapes and check if any shape contains text. if a
shape contains text then i need grab the value of the text in a
find text and copy selected rows from text and loop41489 (11/16/2009 9:27:01 AM) UtfHi
I'm need your expert help. In a worksheet I need to find the word
"Filename" in column B, then cut rows until the next "Filename" word. I need
this looping to start from the 2nd "Filename" word.
Changing name from Arabic to English02108 (11/17/2009 8:08:02 AM) UtfI, m registering all new recruitment employees so always I'm writing the
employee name by Arabic and English. So there is any code to change
automatically the person name for Arabic to English
Timer recalculation11589 (11/17/2009 5:34:16 AM) UtfIs there a way to have the cells in a particular worksheet recalculate
periodically. I used to do something similar with Access using OnTimer IIRC.
Excel crashing during macro (but very odd)1804 (11/17/2009 6:16:42 AM) UtfHello there, I have an automatic printing macro that can be set to print to a
normal printer or print to PDF as required. I have included the relevant part
of the macro below (with comments).
In PDF mode...
Deleting duplicated rows based on data in two columns5759 (11/17/2009 6:21:04 AM) UtfI have a range of data in cells A1:K1000 and some of the row data in that
range has been partially duplicated. What I would like to do is to delete
the duplicated row if the cell values in column A are the...
user form start field3649 (11/17/2009 6:08:06 AM) UtfI have a user form with several text boxes but when I start executing the
form the cursor starts in the wrong text box... how do I change to the place
I want it to start....?
It start on textbox2 but I n...
Userform question - 682361759 (11/17/2009 6:21:02 AM) UtfWhat do I need to do if I want to access a cell in my worksheet if I have a
userform open? (I have to close the userform in order to access the cell)
Thank you in advance
Conversion from text to excel2892 (11/16/2009 8:10:43 AM) AyobamiHi guys, I need help, i have a code to convert text files into excel,
however the problem is that the text files are many and can vary in
number. The code i have is repetitive and it contains a code to
user form parameters1929 (11/17/2009 5:52:32 AM) UtfWhere can I learn how to set up the user form parameters
I have a user form with three text boxes but when I click tab I do not know
how to control the next text box to go.
Then I have a commandbuttom w...
Syntax Error Writing in MDB table51108 (11/16/2009 11:11:02 AM) UtfI have an excel sheet that uses Access tables in the background to store
information... The file has been functioning, but for various reasons, I
needed to change the name of the Access file from "PDAv1_be....
reset combobox to blank6680 (11/16/2009 4:31:32 PM) Susanthis is in a worksheet_open sub. the combobox is the only activex
control on the worksheet. what am i doing wrong? i tried "value" but
that didn't work. but neither is listindex. i originally had it all
Copying Data from One sheet to another6968 (11/16/2009 5:10:01 PM) UtfHi all
I am trying to copy cells from one sheet and paste in another using the
below. The theory is that there is a new row in both sheet 1 and 2 each day
and each day I want it to find the last row in s...
UNDO become impossible after modifying SheeChange handler3446 (11/16/2009 4:31:03 PM) UtfHi all,
I'm developing a c# excel addin and in order to make it work I have added a
new handler for the SheetChange event.
This handler modifies some global (addin scope) variables in order to
Combobox strange behaviour0673 (11/17/2009 6:16:02 AM) UtfHello there, I have a userform (that is quite complex). On one of the pages I
have various Comboboxes with varying listrows lenghts (from 3 to 16).
When the form is loaded there are three different things ...
Data in a Calender layout view0964 (11/17/2009 5:59:04 AM) UtfI'm being asked to take a block of data and summarize it by orders and by
ship date and then put that summarized data into a calender view. Basically
each day on the calender needs to show the order #'s th...