python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - office-automation

Watch entries disappear when using CreateObject for Excel.Application

I have some VBA code in an Access database which creates an object using CreateObject("Excel.Application"). I have added a watch on a string variable. When I try to step through the code, th...
test-img

T. Laza

vba

office365

office-automation

Votes: 0

Answers: 1

Latest Answer

Add a reference to the Excel object model on the COM references dialog of your VBA project. Than you may try to use Early binding instead. See Using early binding and late binding in Automation for mo...
test-img

Eugene Astafiev

Narrowing down / speeding up search in extracted outlook shcedule

I am trying to find a specific subject in a shared outlook calendar on a specific date. The subject, the date and the shared calendar is passed as arguments. The script below works (I simplified it a ...
test-img

Babul Miah

excel

vba

outlook

calendar

office-automation

Votes: 0

Answers: 2

Latest Answer

First of all, iterating over all items in the folder is not really a good idea. You need to use the Find/FindNext or Restrict methods of the Items class to get only items that correspond to your condi...
test-img

Eugene Astafiev

Excel VBA button to save workbook based on cell values and send email

I have been trying to create two buttons in my Excel sheet that will allow the user to select the file path to save the workbook (as a new workbook) and another button that will then create a new emai...
test-img

Joe

excel

vba

outlook

email-attachments

office-automation

Votes: 0

Answers: 1

Latest Answer

The Document.FullName property is not changed when you save a Word document to a new location. So, I'd suggest converting your sub into a function which returns a file path which points to the newly s...
test-img

Eugene Astafiev

HTML email body truncation while sending email from outlook using PowerShell

I have one HTML file which i want to send from PowerShell using outlook. I have used below code however it is truncating the email body after 603 chars, hence only upper half of the html page is going...
test-img

Rahul Richhariya

powershell

outlook

office-automation

Votes: 0

Answers: 2

Latest Answer

After spending hours, finally got the root cause of this issue. The html page which i was trying to sent as email body was the output of another powershell command using ConvertTo-Html. And the outpu...
test-img

Rahul Richhariya

Posts

Questions

Blogs

Jobs