I am trying to automate an office document. I would like to write some code that will paste everything in the office clipboard in VBA. I keep running into walls. Does anyone have an idea of how I can automate the pasteall function??
I am sorry but I did not see a working suggestion besides the questions about what I was trying to accomplish and you mentioned not to delete tables..but there was no alternatives offered besided Excel which will not work in my case..Thanks for your time
Exactly..the user will check the orders that apply to the case, and then the selections will be transferred to another word document for other usage
I thought if I could get the questions that do not apply to be removed it will be easy to get the remaining question that are left to another...
Or if there is anyway that once I have cleared the contents of the rows that do not apply for vba to just delete the tables that are blank is another way to go..
Help I am clueless
The reason I chose word is because these are court forms and that have to be filled out as forms. The questions that remain on form will then need to be transferred to another word document..etc
Believe me I already thought of excel but it will not work the way the users need to use this form...
The problem is the form will have about 30 questions and I will never know which checkboxes will be checked or not
so that means any random number of tables need to be deleted at once, depending on which check boxes are checked
so for example...If checkbox 1 is not selected it becomes deleted...
I am trying to create a word document, that if a user does not check a certain checkbox, the text in the table next to it will disappear, to remove data that does not need to appear on the document.
I have to do it in tables because some of the questions have drop down boxes..the table helps...
If CheckBox1.Value = True Then
CheckBox1.Width = 100
Else
Tables(1).Rows(1).Delete
End If
If CheckBox2.Value = True Then
CheckBox2.Width = 100
Else
Tables(2).Rows(1).Delete
End If
This code causes table 2 to become table 1 once the first table is deleted..I know my code sucks but I am...
Thanks for the response..but I am really a novice, so can you give me a more specifice example of how to loop at the end if you can.. Thanks. I am using a conditional if statement..i.e
If checkbox1.value = True Then
action
else
delete table row
end If
I have a word document with 9 tables
1 row each with checkboxes
When a checkbox value is false, I have written some to code to delete the corresponding row. The problem is once a row is deleted, it throws of the table number of the remaining tables. I can't find a way to work around this?? Any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.