Recent content by MacroManII

Is there any way to access objects inside the web page. Specifically, I am trying to automate submission process to a web site. I would like to automatically fill in fields and press the 'SUBMIT' button.

Thanks, but I already tried this ... still getting the message. Anyone ?

I am trying to set up some macros in Outlook 2003 But I am getting this error "The macros in this project are disabled". How do I get around this ?

Tracy, The first bat file calls a program, which when it runs it prompts for a parameter. I do not see how having two bat files will help the situation Regards Still need help ...

Hi, I have a program that when it runs it runs a .bat file which needs a parameter passed to it. I am using send keys to do this very successfully, except when the Windows Security is activated and my system is locked. The program is on a schedule and activates at 7am, but when I come to work...

This is how to open an existing Brio Query Set bqDoc = bqApp.Documents.Open("C:\ExistingQuery.bqy") Regards MacroManII

Hi, Does anyone have a simple example in VB of how I could open a web page, and download a table from it. Regards MacroManII

This is how to connect to an OCE in Brio within VB Dim bqApp As BrioQry.Application Dim bqDoc As BrioQry.Document Dim bqSec As BrioQry.Section Dim bqCon As BrioQry.Connection Dim strOCE As String strOCE = "C:\Program Files\Brio\BrioQuery\Program\Open Catalog...

I am using the following code to run a simple Brio Query from VB. I would like to set up and run a a Brio Query that needs to connect using a DataBase Connection File (.oce), and supply a username and password to gain access. Does anyone know how to do this ? MacroManToo Option Explicit...

Using VBA, insert the following code into ThisWorkbook under Microsoft Excel Objects Private Sub Workbook_BeforePrint(Cancel As Boolean) Cancel = True End Sub

Does anyone know how to change the excel backgroung from the standard grey. Note not on a sheet but the excel space after all workbooks have been minimised.

You can loop through all the open workbooks and apply your filter and copy the rows to one new file ... something like this Sub FindBlanks() Dim Wb As Workbook Dim sNewBook As String sNewBook = "Exceptions.XLS" 'This is book to paste to For Each Wb In...

Hi, You could autofilter and select all the blank cells in this particular column. Then cut and paste to a new sheet. MacroManII

Hi, I have set up a worksheet to be used by many different people, it contains formulae and so I want to protect the sheet so formulas cannot be deleted etc., unfortunately I also used grouping or rows and so when I protect the sheet I cannot use the grouping buttons. Can anyone help me here...

How can I redimension the size of nQty, in the following user defined array Type UsageRecord sPart As String * 5 bIsKIT As Boolean sDesc As String * 30 nQTY(20) As Long nDaysBooked As Integer nTotal As Long nMean As Double nStdDev As Double nShelfStock As...