I received a PDF from an outside source and it keeps typing in Chinese (or other Asian language). I tried to create a fill in form using the PDF and all the fields type one character in English and then by the second character get hijacked by some kind of Korean typing overlay.
I went back to...
jjefferson,
Thanks for the reply! After a lot of research, I finally came to the same result. I put the CASE sequence in my WHERE clause of the data query. Because I wanted to use "Status" as a parameter, I also had to add it to the SELECT clause of my parameter query. I used DISTINCT in...
I have a table column called status. Its values can only be "O" or "C." In my report, I would like it to show as "open" or "closed." How do I update my query to do this?
I am trying to create a VBA Macro in Outlook to open a custom form I've created that is currently saved in the Personal Forms Library. I am hoping to eventually move it to the Organizational Forms library on the Exchange Server (the system engineer does that for me).
I understand that there is...
I could probably clean up the code for the table borders, and I know that I could clean up the code for the shapes. I just have to be careful with the shapes that I don't accidentally delete something that I need.
And, yes, I think this QAT issue is separate from the code, since the code is...
Hi Fumei!
Here's the code:
Sub Envelope()
'
' Envelope Macro -- Keystroke shortcut = Alt+E
' Creates 8.5 x 11 inch foldable envelope insert
' with company return address and highlighted text as addressee
'
'Copies highlighted text
Selection.Copy
'Opens a new blank document...
The macro works just fine from the macro button on the developer tab (Word 2007), but when I put the macro on the QAT and try to run it from there I get an error message. The error message has no text, just a big red circle with a white "x". ????
Can't find anything in google or tek-tips...
Fumei,
Your original advice about setting the cell and then using it before the command actually helped me fix a lot of the problem code:
Dim aCell As Cell
Set aCell = ActiveDocument.Tables(3).Cell(2,2)
' insert text
aCell.Range.Text = "yadda"
This little snippet of code was brilliant, and...
Hi Fumei,
Thank you for being so responsive! It kind of is a template, but I do want it to be a macro. I guess I could create a template...
At work, we use a double-windowed envelope for mailings. The secretaries print out a sheet with our return address and the mailing address. The firm...
Hi Fumei,
Thank you for being so responsive! It kind of is a template, but I do want it to be a macro. I guess I could create a template...
At work, we use a double-windowed envelope for mailings. The secretaries print out a sheet with our return address and the mailing address. The firm...
Thanks PHV. I started the whole thing by recording it, and I've been debugging it ever since. I had no trouble whatsoever creating a new blank document, setting the margins, creating the table, setting the vertical alignment for the rows and creating, coloring and placing two drawing shapes in...
Please help! How do you set horizontal alignment, insert text and insert paragraph returns inside a specific table cell. I can get all of this to work outside of a table, but I can not get this to work in the table.
TIA!!!
--from a beginner VBA programmer
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.