LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Selection.EntireRow - Filtered Bam Excel Programming 7 October 11th 08 05:24 AM
Selection.EntireRow.AutoFit Al Excel Programming 2 April 17th 08 01:55 PM
Selection EntireRow Insert Rob Excel Programming 4 March 24th 08 08:32 PM
How do I fill a cell in a user form from a selection on same form? Terry Tipsy Excel Discussion (Misc queries) 4 June 11th 07 02:59 PM
Excel hangs on 'shtA.Cells(person_row, 1).EntireRow.Insert' comman Gordon[_2_] Excel Programming 1 July 14th 06 08:00 AM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"