Search results

This worked, but not when when objxl.window(1) was False. With this code, you don't see any of the windows. Dim XLapp As New Excel.Application Dim ObjXL As Excel.Workbook Set ObjXL = XLapp.Workbooks.Open("C:\...\Settlements.xlsx") ObjXL.Application.Visible = False...

I have an excel spreadsheet that uses a data connection to a website to download text. I have the data connection properties to refresh upon opening the file. If i double click the file from windows, it updates. Although using the code below doesn't work. When i've added the code ObjXL.Save...

Below is the code that i'm going to be using to send info to all our clients. When I have a few email address in the recipients.add part, the email shows all the addresses. Now I have a group of 100 addresses and the email appears at the end of the code with the word bids in the bcc, not the...