Hello, I've a workbook "Inspections.xlsx" with worksheet named "Observations" saved in C:\Users\ABC\Documents\. Photos are also saved at the same folder. I've changed the code like this
Code:
StrWkBkNm = "C:\Users\ABC\Documents\Inspections.xlsx"
StrDocPath = ActiveDocument.Path
StrRpt = Right(StrDocPath, Len(StrDocPath) - InStrRev(StrDocPath, "\"))
StrWkSht = "Observations"
StrPicPath = "C:\Users\ABC\Documents\"
When I compile the code, I got a "Compile error: Method or data member not found", pointing to .Name of this line
Code:
If .Name = "TblPic" Then bFnd = False: Exit For
Please help.
