how i use Selection.entirerow.insert on a windows form, excel07???
 

Hi peps!
I am afraid of asking, as no place seem to be the rigth place to post my
question... but there it goes: Once i made a simple survey application using
excel03, i made a macro that reads text (user input) from the controls and
then inserts them in the cells A4, B4, D4 etc. of a worksheet, and when other
user fills out the form, then i used Selection.entirerow.insert to displace
down the previous user, so the last information input was always on top, and
the other users were kept up on the list, keeping cell format; now, i made an
inventory app on visualbasic visualstudio08 that is a windows form
application, but surprise! when i tried this simple solution, the method was
not found... obviously. I have searched a lot, but found no replacement for
the function, or how to declare it... I used then Open XML Format (there are
snippets for it) to get to read and write into the cells and it works, just
for the range i declare initially, and then overwrites with every new user,
duh! but i really need to insert the row and keep format to make lists, and i
did like better the OXF so i will work without opening any books from now on;
if any one can give me some pointers on how to code it, i would appreciate it
so much, and further, i have to ask, using the open XML format, how can i
search into the document part for specific cell values??? (without knowing
the cell address)

Thank you all for the attention
--
VolksJagger

how i use Selection.entirerow.insert on a windows form, excel07???
 

in place of:
Selection.EntireRow.Insert
try:
ActiveCell.EntireRow.Insert
--
Gary''s Student - gsnu200829


"VolksJagger" wrote:

Hi peps!
I am afraid of asking, as no place seem to be the rigth place to post my
question... but there it goes: Once i made a simple survey application using
excel03, i made a macro that reads text (user input) from the controls and
then inserts them in the cells A4, B4, D4 etc. of a worksheet, and when other
user fills out the form, then i used Selection.entirerow.insert to displace
down the previous user, so the last information input was always on top, and
the other users were kept up on the list, keeping cell format; now, i made an
inventory app on visualbasic visualstudio08 that is a windows form
application, but surprise! when i tried this simple solution, the method was
not found... obviously. I have searched a lot, but found no replacement for
the function, or how to declare it... I used then Open XML Format (there are
snippets for it) to get to read and write into the cells and it works, just
for the range i declare initially, and then overwrites with every new user,
duh! but i really need to insert the row and keep format to make lists, and i
did like better the OXF so i will work without opening any books from now on;
if any one can give me some pointers on how to code it, i would appreciate it
so much, and further, i have to ask, using the open XML format, how can i
search into the document part for specific cell values??? (without knowing
the cell address)

Thank you all for the attention
--
VolksJagger