Search results for query: *

I have a VBA project in Excel 2003 and it has been running without any issues for more than an year. But suddenly this gives me a "Run-time error '1004': Document not saved." for the command ThisWorkbook.Save This VBA project is password protected. I am not able to save the workbook manually...

The FAQ you suggested was very helpful. I have one more question. Can i skip any unwanted pop up comes when i try to open up a desired page? Any clues? Thanks in advance.

Thank you very much for your valuable post. It was very helpful for me.

Can somebody tell how to open a password protected webpage in VBA, Currently I use the below code to open a webpage Sub openweb() strURI = "www.google.com" Set ie = CreateObject("internetexplorer.application") ie.Navigate strURI end sub

The code is Sub GetTextFromIe() Dim NPOFile$, myFile$ Dim ie As Object, objDoc As Object, f As Object, fs As Object Dim strURI As String strURI = "www.google.com" Set ie = CreateObject("internetexplorer.application") ie.Navigate strURI 'Wait for page to load! Do If ie.ReadyState = 4 Then...

Hi all, I am trying to extract the texts from a web page and write it to a text file. I am able to read the text by using internetexplorer.application but when I try to write it to the notepad sometimes it gives Runtime Error 5: Invalid procedure call or argument. Microsoft VB Help says that...

Hi, thank you for the response. But all I wanted is month in MON format. ie 06 as JUN.

Hi all, Is there any way to find the month of any date. The Date('Month') gives only the month of current date. I would like to get the month of any date (eg: 06/15/2009) in the MON format. Please help. -Arasi