Search results for query: *

I was afraid that was going to be the answer. Thanks for your response!!

I have a word document that I manipulate what displays based on input from a userform. Once the code has generated the correct version of the document based on the inputs, I convert the word document to a PDF (also with code). Works fine. But, is there code that would create a fillable PDF...

Thanks for your replies on this. I don't have an "On Error Resume Next" anywhere. I have the following code at the beginning. Public Sub OpenWord() Dim wdApp As Object Dim wdDoc As Object Set wdApp = CreateObject("Word.application") wdApp.Visible = True I'm going to pursue a different route...

I have an excel VBA project and as part of that I launch a word doc and fill in information that was input on a userform in the excel doc(to prevent double-entry of data). The word doc has to be protected so that users can't alter the info. I have the word doc protected to start with...

Hi, I tried your suggestion of just Delete instead of DeleteShape. I received the following error message: Run-time error '5'. Invalid procedure call or argument.

Thanks. My issue with that is that I have information underneath of it so just making it invisible will make it look like a gap in the document. Any other suggestions?

I have VBA code in excel and as part of that I launch a document in Word and populate ActiveX textboxes with information that was populated in the Excel userform. However, in some instances, I want the code to delete the ActiveX textbox instead of populating it. Can anyone tell me how to...

PHV, Thank you! Both of your options worked. I liked option 2 better because it forced the decimal places to display in the word doc. I really appreciate your help.

Andy, Your suggestion of "wdDoc.txtJandSamt.Text = Val(frmRLRP.txtBenefitAmt.Text) / 2" did the trick. Thank you very much. I'd like to ask another question though. Since I am dealing with dollar figures, I need it to round the result to 2 decimal places. Currently, if txtBenefitAmt...

Hi, I have a userform in excel with a field called txtBenefitAmt. As part of my code, I have excel launch a word document and populate information given to me in the excel userform. The word document does not have a userform but I have txt boxes on the doc itself. However, in certain...

Thanks for the tip. I posted it in 707 and already have a resolution to my issue.

Thanks PH. I appreciate your quick response! Tested it out and your code works perfectly! I have also received a tip of the following: Private Sub Workbook_NewSheet(ByVal Sh As Object) MsgBox "New tabs are not allowed in the Plan Profile!", vbOKOnly, "New tabs not allowed"...

I need to prevent users from adding new tabs to an Excel worksheet that I have. I have added the following code to "ThisWorkbook". Private Sub Workbook_NewSheet(ByVal Sh As Object) MsgBox "New tabs are not allowed in the Plan Profile!", vbOKOnly, "New tabs not allowed"...

I need to prevent users from adding new tabs to an Excel worksheet that I have. I have added the following code to "ThisWorkbook". Private Sub Workbook_NewSheet(ByVal Sh As Object) MsgBox "New tabs are not allowed in the Plan Profile!", vbOKOnly, "New tabs not allowed"...

Worked beautifully! Thank you very much!

It is currently set to Move but don't size with cells. Do I need to change that to the option you indicated?

Hi, Yes, the height of the picture is bigger than the height of the row. Thanks for your help.

In Excel, I am using code to hide rows in certain situations. The issue is that a picture I have in one of the rows isn't hiding like the text. I think I need to add code specifically for the picture, but not sure what syntax should be used. The Sheet is called "T404 Full". The...