Macro Correction

zyxw1234
Banned
Posts: 253
Joined: 22 Apr 2020, 17:24

Re: Macro Correction

Post by zyxw1234 »

http://www.excelfox.com/forum/showthrea ... Correction
Top
zyxw1234
Banned
Posts: 253
Joined: 22 Apr 2020, 17:24

Re: Macro Correction

Post by zyxw1234 »

Plz see the sample file
& Run the macro HansV Sir u will met with an error
You do not have the required permissions to view the files attached to this post.
Top
User avatar
HansV
Administrator
Posts: 78474
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Macro Correction

Post by HansV »

The code runs without error with these sample workbooks too.
Best wishes,
Hans
Top
zyxw1234
Banned
Posts: 253
Joined: 22 Apr 2020, 17:24

Re: Macro Correction

Post by zyxw1234 »

So HansV Sir plz suggest something
How to deal with this problem
Any suggestion any guess regarding that problem
Top
User avatar
HansV
Administrator
Posts: 78474
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Macro Correction

Post by HansV »

How can I suggest something if I don't see the problem?
Best wishes,
Hans
Top
zyxw1234
Banned
Posts: 253
Joined: 22 Apr 2020, 17:24

Re: Macro Correction

Post by zyxw1234 »

Ok Sir
Top
zyxw1234
Banned
Posts: 253
Joined: 22 Apr 2020, 17:24

Re: Macro Correction

Post by zyxw1234 »

Ok now i got it why i got errors
Actually i have 2 files named H2.xlsb so thats y I was getting error
I ran the macro & now it is working Perfect
Sorry for the trouble HansV Sir
Have a Great Day
Top
User avatar
HansV
Administrator
Posts: 78474
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Macro Correction

Post by HansV »

Sheesh...

Well, anyway it works now...
Best wishes,
Hans
Top
zyxw1234
Banned
Posts: 253
Joined: 22 Apr 2020, 17:24

Re: Macro Correction

Post by zyxw1234 »

Yes No Doubt in it HansV Sir
Top

Return to “VB/VBA/.Net/Office Scripting”