| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem to access sheet from add-in
use thisworkbook.
if you want to refer to addin worksheets. Nader wrote: Hello, I've createad an add-in (with a function called ratings) in which I get some value from a sheet that have to be created in order to use my add-in. It worked perfectly for a few days but now whenever I open my excel sheet and the use the function from my add-in I get an error because excel cannot find the sheet I use to make some calculation in my excel file. I think that my add-in is tryin to the sheet within my add-in ... Please someone help me ! Thanks in advance. I use the following code to make sure I can acces a specific sheet in my add-in: Dim wSheet As Worksheet On Error Resume Next Set wSheet = Sheets("ratings_sheet") if wSheet is Nothing then msgbox "i've got a serious problem" else msgbox "everything is cool" end if |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access to Excel problem | Excel Discussion (Misc queries) | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| Excel 97 problem with access | Excel Discussion (Misc queries) | |||
| Problem doing Query to Access with Excel sheet protected | Excel Programming | |||
| Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming | |||
Hybrid Mode
