Help with - "Ambigious name detected" - mulitple codes on sheet.

**galvinpaddy** · 06-21-2012, 02:33 AM

Good morning happy campers.

I have the following codes set in a workbook.
This Workbook -

Please Login or Register  to view this content.

Module 1

Please Login or Register  to view this content.

Module 2

Please Login or Register  to view this content.

So far, when the work book is shared (allowing changes by more than one user) it appears to work fine, updating/refreshing the values every 30 seconds and then saving every 5 minutes.
The problem comes when closing the worksheet, i have the following error - "Complie Error: Ambigious name detected; ~"
Which highlights the following line in yellow -

Please Login or Register  to view this content.

If i simply close the debugger then excel asks me if i want to save, i click yes, it saves and closes, job done.
What i would like to know is is the error going to casue me an issue, and either way, how do i prevent it?
I cant post work book yet as i would need to strip all data out of it, but the data inside the sheet is all manual entry with very few formula's, basically the code doesnt modify anything inside the sheet apart from updating values.

Kind Regards.
galvinpaddy

**galvinpaddy** · 06-22-2012, 02:40 AM

Good morning happy campers,

Would really like some help in resolving this

regards, galvinpaddy

**rkey** · 06-22-2012, 03:05 AM

Hi Galvinpaddy,

Can you give it a try without these rows in module2?

Please Login or Register  to view this content.

Looks like some double public declarations

**galvinpaddy** · 06-22-2012, 03:20 AM

Hi, thanks for that!!!
BUT -
Whilst i no longer receive that error, Now, when the workbook is shared the changes dont update from another user.
I think i may have added a wrong sectiopn of code though -

Please Login or Register  to view this content.

should this be

Please Login or Register  to view this content.

??

**galvinpaddy** · 06-22-2012, 03:38 AM

hhhmmmm, i changed my code to read -

Please Login or Register  to view this content.

And now receive Run-time error '1004': Method of object '_Workbook' failed.
The sheet is not protected it is only shared.

**rkey** · 06-22-2012, 03:49 AM

Hi Galvinpaddy,

Check this tread: http://www.excelforum.com/excel-gene...-question.html

Regards,
Rkey

**galvinpaddy** · 06-22-2012, 03:49 AM

?? lol, no link in your post :D

**rkey** · 06-22-2012, 03:51 AM

Got fat fingers, hitted the enter :P

**galvinpaddy** · 06-22-2012, 04:01 AM

hehehe
ok, so from their i get

Please Login or Register  to view this content.

But how does this fit in with my code??

**rkey** · 06-22-2012, 04:13 AM

I'm on a curve here as well.
I read a lot of disregards towards sharing a book :P.
However, i just came across this one.
Can you try this?

Please Login or Register  to view this content.

**galvinpaddy** · 06-22-2012, 05:37 AM

lots of curves around shared books as far as i can see lol

That code does save the sheet but does not appear to update changes made by others

**royUK** · 06-22-2012, 07:55 AM

You are declaring your variables as Public, so you have identical variables because you repeat it in two modules.

**galvinpaddy** · 06-22-2012, 07:59 AM

Hi RoyUK,
Thanks for that, would you be kind enough to 'repair' my coding?

regards

**royUK** · 06-22-2012, 08:05 AM

attach the file

**jaslake** · 06-24-2012, 03:10 PM

Hi Richard
This is code I use for timer events. I don't know from shared workbooks...not certain what the code will do in that regard. Replace your code with this code. Let me know of issues.

In ThisWorkbook Module

Please Login or Register  to view this content.

In a General Module

Please Login or Register  to view this content.

**jaslake** · 06-24-2012, 04:28 PM

Hi Richard
Been playing with shared workbooks...change this code...it appears to perform as expected

Please Login or Register  to view this content.

**galvinpaddy** · 06-25-2012, 01:11 AM

Good morning John,

Having made the following changes:
THIS WORKBOOK

Please Login or Register  to view this content.

MODULE1

Please Login or Register  to view this content.

Once shared & saved, the following error comes up - "Run-time error '1004': Method 'RefreshAll' of object '_Workbook' failed. i cant debug (as its shared) to show you what is highlighted.

Please advise.
Kind Regards, galvinpaddy

**jaslake** · 06-25-2012, 07:06 AM

Hi Richard
Comment out this line of code

Please Login or Register  to view this content.

**galvinpaddy** · 06-25-2012, 08:32 AM

John, you sir are a legend yet again.

So many thanks indeed.

**jaslake** · 06-25-2012, 10:11 AM

You're welcome...glad I could help.

Help with - "Ambigious name detected" - mulitple codes on sheet.

LinkBack

Thread Tools

Rate This Thread

Display

Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Re: Help with - "Ambigious name detected" - mulitple codes on sheet.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions