Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selection.EntireRow - Filtered | Excel Programming | |||
Selection.EntireRow.AutoFit | Excel Programming | |||
Selection EntireRow Insert | Excel Programming | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Excel hangs on 'shtA.Cells(person_row, 1).EntireRow.Insert' comman | Excel Programming |