I have followed the steps to insert a picture into an email to no avail. I have selected Rich Text (HTML) and Send Pictures with Message. When I click to insert a picture, I get the pop up window to browse for my picture file. I browse for a picture, enter 1 for border thickness, and click...
I have programmed an Excel VBA macro which creates an Internet Explorer object (objInternetExplorer) and then navigates to a webpage which contains frames. I want to grab text from inside one of the frames. I've tried:
strText = objInternetExplorer.Document.Body.InnerText
and all I get is an...
I need to elaborate on my last post.
To get the last day of the current month, you can use a formula in an Excel spreadsheet such as:
=DATE(YEAR(NOW()),MONTH(NOW())+1,0)
or in VB code you could use:
EOM=DateSerial(Year(Now),Month(Now)+1,0)
Again, the 0 in each example gives the last day of...
Or even simpler:
EOM=Date(Year(Now()),Month(Now())+1,0)
I discovered this by accident. The zero-th day of a month is the last day of the previous month. Negative numbers go further back in the previous month.
Harvey
I recently upgraded my CPU chip from an old AMD to a Pentium 166. Now the power management setting which turns off my monitor after five minutes of inactivity does not work after starting the computer. If I bring up control panel, power management, and click OK, then the monitor power...
I recently upgraded my CPU chip from an old AMD to a Pentium-S 166. Now the power management setting which turns off my monitor after five minutes of inactivity does not work after starting the computer. If I bring up control panel, power management, and click OK, then the monitor power...
I need to populate various cells in my Excel spreadsheet with historical mutual fund quotes and dividends from the web. I have about 100 mutual fund symbols in column 1, and 13 columns each for historical months. The first two columns for each historical month are for monthly closing prices...
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.