User control-> Out of control!

  • Thread starter Thread starter BBFB
  • Start date Start date
B

BBFB

Hi!


I have a question. And no answer for it yet, to my dismay... :)

/********************************************************/

1- I have:

1.2 - Excel 2003.
1.2 - A workbook with a spreadsheet.
1.3 - A button called ParseIt! on the spreadsheet.
1.4 - A User Form with a TextBox control on it.

/********************************************************/

2- The user does this:

2.1 - Copy (CRTL-A) the content of a Web Page (order details).
2.2 - Press in the spreadsheet the ParseIt! button.
2.3 - Paste it in the User Form ( popin up from the button_click
TextBox control.
2.4 - Press the User Form button OK.

/********************************************************/

3- The User Form has to do this:

3.1 - Create a temporary spreadsheet.
3.2 - Paste the TextBox content into a bunch of Cells of the tem
spreadsheet.
3.3 - Then it parses it to the final spreadsheet.

/********************************************************/

My Question is:

3.2 :: How do I get the User Form to paste the content of its TextBo
control into a bunch of Cells of the temporary spreadsheet (that wil
allow me to write a parser based on the content of those Cells) ?



The Excel program I an trying to do will allow our sales rep to trac
their orders efficiently by having them copy pasting the order from th
web and pressing a single button.


Thank you for your help, Kindly, :)

Antoine Dubuc
Best Buy For Business, DRC Channel, Montreal.
(e-mail address removed)
 
HI, Antoine. I am not the best expert on this, but I wonder if a UserForm
TextBox is the way to go. Personally, if I were going to try something like
this, I would look into pasting into Word first, possibly as RTF or
Unformatted Text, but the HTML version may work also. If you've got an
order form, it's probably in some sort of table format, and Word is good at
going through tables. You can then take the info from the cells in the Word
table and direct them to cell in your Excel file.

Ed
 
Back
Top