Search results

Hi Guys, Getting frustrated now :( I've set up a progress bar activex oject within a form called frmProgressBar. The Progress bar object is called ProgressBar0 and there are two labels (Label1 and Label2) along with a button called cmdClose. As part of another routine, I am calling the...

Hi Bob, Here the whole procedure (less a huge amount of repetitive cell and text formatting). The purpose of the proedure is to export a selected record and sub-record set to an excel template in a specific format template (More4Apps Oracle Receipts Wizard). The data is stored as a header and...

Think I've solved it. I've replaced Set xlapp = CreateObject("Excel.Application") With On Error Resume Next Set xlapp = GetObject(, "Excel.Application") On Error GoTo 0 If xlapp Is Nothing Then Set xlapp = CreateObject("Excel.Application") End If and it seems to be...

Hi, When I run the code below first time, it works fine but everytime I re-run it, it generates an "Object variable or With block variable not set error". Keep trying to find the problem but running out of patience.:banghead: Private Sub cmdExpMore4Apps_Click() Dim xlapp As Excel.Application...

Hi, Just a quick note to say hi, I'm a sporadic programmer creating small utilities to assist the company I work for in making manual processes more efficient. Just occasionally I come across something I can't fathom out and then it's "D'OH, of course. Why didn't I think of that?", when...