 |  |  |  |  |  |  |  |
excel VBA macro to generate .rtf file
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Hi
I don't know if this is the best place to post my question, but
here is what I have and what I need to do:
- I have 100 questions. Every question is in a cell (from B1 to B100). In cells A1..A100 I can say "yes" or "no" wether I want to use that question or not in a questionare. I have one command button.
- to generate the questionare, first I choose 10 questions (by marking the cells from column A with "yes"). Then I want to press the command button and to generate a .rtf file with those 10 questions. I want to be able to set some formatting of the text (bold, colored, size, etc).
Can you tell me how to do it? So far I was only able to create a .txt file but I can not set any properties of the text (it's only plain text).
10x a lot
EXTRA: if I have a picture in the excel, can I "copy" it also to the .rtf file?
I don't know if this is the best place to post my question, but
here is what I have and what I need to do:
- I have 100 questions. Every question is in a cell (from B1 to B100). In cells A1..A100 I can say "yes" or "no" wether I want to use that question or not in a questionare. I have one command button.
- to generate the questionare, first I choose 10 questions (by marking the cells from column A with "yes"). Then I want to press the command button and to generate a .rtf file with those 10 questions. I want to be able to set some formatting of the text (bold, colored, size, etc).
Can you tell me how to do it? So far I was only able to create a .txt file but I can not set any properties of the text (it's only plain text).
10x a lot
EXTRA: if I have a picture in the excel, can I "copy" it also to the .rtf file?
|
Similar Threads
- Excel Macro Save as with date in file name (Visual Basic 4 / 5 / 6)
- Excel vba 6.0 copy date cells date format (Visual Basic 4 / 5 / 6)
- VBA source code (Visual Basic 4 / 5 / 6)
- Excel Macro VBA Help (Visual Basic 4 / 5 / 6)
- How to generate pdf file automatically at background? (HTML and CSS)
- Compiling Excel VBA-code? (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: blinking textboxes and buttons
- Next Thread: The "Change Solution" Help Needed
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
