|
The answer is at Return Value From Excel Macro to VB.net Application.[^]
It reads:
Quote: I've seen this fail when the macro is in ThisWorkbook. Also, I read a post on another forum from someone who had the same problem. The macro ran OK but returned Nothing, although it should have returned a Boolean. The fix (provided by the other guy, whose name I forget) was to put the macro in a module.
I'm assuming it was closed due to it being not an answer and more of a comment.
cheers
Chris Maunder
|
|
|
|
|
Maybe, but trying to follow the instructions in the original answer cost me an hour, because they don't work in the case I described.
However, it doesn't really matter to me anymore. I thought (and think) that my comment might save someone else the time and frustration I went through, but if you're happy with the existing answer, then so am I.
|
|
|
|
|
|
Tried to Rollback with no success. This has been discussed too many times. It would be nice to have reopen button available to 'some' of the Members.
Programmer : A machine that converts coffee into code !
|
|
|
|
|
What happens if you edit and save?
|
|
|
|
|
I tried it. It gets updated but status remains 'Deleted'.
Programmer : A machine that converts coffee into code !
|
|
|
|
|
|
Using my Super-Hamster powers, I've undeleted the question.
|
|
|
|
|
Thank you, Hamstertron. 
|
|
|
|
|
I am new member number 11754090 --- User Name 11719662 --- Email {removed /ja}. I joined "CodeProject" yesterday (June 9, 2015) not knowing what your organization was all about. I have a Parcing problem with some PDF data and thought you folks might be able to help me solve my problem.
I think I should not continue to be a member of CodeProject I am 88 years old and not a person who can be a good member of your group. I am just too old for you. Please remove me from
CodeProject membership.
Good luck In your work. Sounds interesting.
Sorry - I couldn't see any other way to cancel my membership.
-- modified 11-Jun-15 0:49am.
|
|
|
|
|
Removed email from post, to not attract spam.
|
|
|
|
|
Hi,
i want my subscription to be cancelled. I understood from a previous question that only Chris or site admins can do that?
Thanx in advance
|
|
|
|
|
If you mean a subscription to a newsletter, you can unsubscribe via Settings > Newsletters & Emails > Save my Settings.
If you mean to close your account, you can to this via Settings > Account > Close my account (checkbox on the right) > Save my Settings.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
Ah, thanx. I completely overlooked that checkmark box.
|
|
|
|
|
Hi,
I am not receiving emails when comments are posted to any of my Articles.
Requesting you to check the earlies
Sukesh Marla
We provide all kind of trainings
corporate, online , classroom and video based trainings
Find my profile here
@Twitter
@Facebook
|
|
|
|
|
I just wondered if we could get the possibility to remove our own reports ourselves?
|
|
|
|
|
That would be a really useful feature to have.
Having previously reported someone in error, and have had 2nd thoughts after I've clicked on some members 
It would be nice to be able to undo these reports.
|
|
|
|
|
|
Phew I'm back 
"There are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies, and the other way is to make it so complicated that there are no obvious deficiencies. The first method is far more difficult." - C.A.R. Hoare
Home | LinkedIn | Google+ | Twitter
|
|
|
|
|
Sorry about that. 
|
|
|
|
|
No worries. I saw that you responded as quickly as you could to remedy the error, and that's as much as anyone can do 
We all make mistakes as we're all human.
"There are two ways of constructing a software design: One way is to make it so simple that there are obviously no deficiencies, and the other way is to make it so complicated that there are no obvious deficiencies. The first method is far more difficult." - C.A.R. Hoare
Home | LinkedIn | Google+ | Twitter
|
|
|
|
|
|
|
The email service stopped without auto-restarting. Kicked.
cheers
Chris Maunder
|
|
|
|
|
I turned off forum email notifications some time ago. Until earlier today, the settings were saved every time I posted a new message.
Now, every time I post a message, I have to remember to un-tick both "E-mail me if someone replies to this message" and "Allow private email replies to this message".
Can we have the old behaviour back please!
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
