Excel worksheet not showing

[cic]

Hello all,

having an issue with the software when i try and log to excel and i get the popup where you select workbook and sheets the sheets column is blank. sometimes it work sometimes not. at the moment can't get it to show anything. Ideas.

Regards
Dan

[GaryRussell]

It's usually when an invisible instance of Excel is running in the background. Try opening the task manager (alt-ctrl-del), select the processes tab and end all processes named Excel.exe. You will probably find there were two instances: the instance you were trying to connect to and the invisible instance causing the problem.

[cic]

thanks for the reply Gary,

The problem is actually something else. If i have

Code: Select all

With ThisWorkbook.Sheets("win")
    If Range("D2").Value = TimeValue("00:00:30") Then
    Range("G15:K20").Select
    Selection.Copy
    Range("A15:F20").Select
    Selection.PasteSpecial Paste:=xlValues
 End If
 End With
 End Sub

It will not show the sheets. If it is not there i.e i cut it it does show the sheets. ok so i cut it and connect. then put it back in the feed stops cut it the clock ticks again. very strange because i was running exactly this on the same sheet 1/2 hour ago.

Regards
Dan

[GaryRussell]

Is there an error you are not aware of? In the code editor select "Compile VBA project" from the Debug menu. Does it produce an error message?

[privateb]

I have the same problem.

I select the excel file from my pc using the browse button, then nothing happens. I get no drop down box for the Work book name or work sheet name.

Any one know how I can get round this??

Cheers in advance.

[GaryRussell]

I have the same problem.

I select the excel file from my pc using the browse button, then nothing happens. I get no drop down box for the Work book name or work sheet name.

Any one know how I can get round this??

Cheers in advance.

It's not the same issue if you are using the browse button. If that doesn't work then communication between Betting Assistant and Excel is not working at all. What version of office are you using?

[privateb]

I have the same problem.

I select the excel file from my pc using the browse button, then nothing happens. I get no drop down box for the Work book name or work sheet name.

Any one know how I can get round this??

Cheers in advance.

It's not the same issue if you are using the browse button. If that doesn't work then communication between Betting Assistant and Excel is not working at all. What version of office are you using?

Hi It is Office 2010.

[GaryRussell]

I have the same problem.

I select the excel file from my pc using the browse button, then nothing happens. I get no drop down box for the Work book name or work sheet name.

Any one know how I can get round this??

Cheers in advance.

It's not the same issue if you are using the browse button. If that doesn't work then communication between Betting Assistant and Excel is not working at all. What version of office are you using?

Hi It is Office 2010.

You probably have the "click to run" version. See http://gruss-software.co.uk/forum/viewt ... l&start=15 for solution (read the last message)