LinkBack URL
About LinkBacks
Hi,
My VBA is supposed to put " '! " into come cells but I get a compile error "expected end of statement".
Can you please help me to express the ' and ! in the vba languauge?
Br
Kris
Hi,
My VBA is supposed to put " '! " into come cells but I get a compile error "expected end of statement".
Can you please help me to express the ' and ! in the vba languauge?
Br
Kris
Shishek,
Can we see your macro code?
If posting VBA code, please use Code Tags - like this:
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Stanley,
This is what I have problems with: '!
Help would be much appreciated!
Please Login or Register to view this content.
Assuming FileName is a variable I think it should be like this.
Please Login or Register to view this content.
Last edited by Norie; 02-23-2013 at 05:20 PM.
If posting code please use code tags, see here.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
As I wrote: I don't know how to express the apostrophe " '! " in the below code:
Please Login or Register to view this content.
The apostrophe isn't the problem, you have that in the right place.
What's wrong is a missing double quote ater 'Data\[' and before the &.
Right! Thanks a lot to you all!
Shishek,
You are very welcome. Glad we could help.
Come back anytime.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks