Hello everybody! I have just started to learn VBA a few weeks ago. I can record some macros in Word and then add some code. I am an old COBOL programmer, the If statements are a little different.
I bought two books, Murach's Visual Basic 2015 & Mastering VBA for Microsoft Office 2016. These are the best I could find, comparing from books at the library.
I work for the USDA, only in Microsoft Word, not Excel.
Right now I am struggling to learn how the clipboard may be used. I have read that you must learn about Data Objects to manipulate the clipboard. I am learning.
At work, I open a document from another application, (Not Word), copy it, paste it to a document in Word and get dat from it. Trouble is, it pastes to Word as a Table and some cells have date in them and some do not.
Does anybody know how I can test to see if the cell has data in it? I find a certain spot on the document, then tab to the next spot where the data might be. If there is not data in it, I will do one thing, If there is data in that cell I will do something else.
Thanks, -Steve