How would I convert the following three queires into one nested query
SELECT T1.ITEM
FROM TABLE1 T1
WHERE T1.NUMBER = 123
SELECT T2.VALUE
FROM TABLE2 T2
WHERE T2.ITEM = T1.ITEM
SELECT T3.LOCATION
FROM TABLE3 T3
WHERE T3.ITEM = T2.ITEM
Let's say I have a picture of myself in c:\my pics\me.jpg and I want to put it in B4. Can Anyone help.
I tried
shtEXCEL.Cells(2, 4) = LoadPicture("c:\my pics\me.jpg")
with no luck.
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.