MsgBox Error

jreed5535

New Member
Joined
Jul 25, 2020
Messages
15
Office Version
  1. 365
Platform
  1. Windows
Hi Guys,

I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2.
1595988608802.png



The only difference is the MsgBox goes into capitals
1595988719903.png


1595988788418.png


any ideas why this is happening?

Cheers
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

jreed5535

New Member
Joined
Jul 25, 2020
Messages
15
Office Version
  1. 365
Platform
  1. Windows
Michael, do you know if it is possible have a macro to run a report on a website then download and save it?
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,392
Office Version
  1. 2013
Platform
  1. Windows
Yes it is....BUT we would need a lot more info, and I'd suggest starting a new thread on that subject
 

Watch MrExcel Video

Forum statistics

Threads
1,113,903
Messages
5,544,964
Members
410,645
Latest member
aroesch
Top