The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 Excel in Origin (Disable makros message)		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Mulvenna

Germany
46 Posts
Posted - 01/22/2014 :  04:14:53 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver: 8.6.0
Operating System: Windows 7

Hi,

I am trying to add some code to my project that opens an excel file, adds one line of information, saves and finally closes again.

These are all no problem, I can open using the "doc -a" command, save using the "Save -i" command and close using "Win -c".

The problem is when Origin tries to open the file it asks every time if I want to enable or disable makros!! This script file is automated and will not always have a user operating Origin while it is running. This means that this message will stop the script until something is selected.

Is there any way to set a default choice or bypass this message all together?? Any help would be much appreciated!

Thanks,
Mulvenna

greg

USA
1379 Posts
Posted - 01/22/2014 :  10:02:37 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
The message is coming from Excel so it's something you should address in your Excel.
Go to Top of Page

Mulvenna

Germany
46 Posts
Posted - 01/31/2014 :  09:27:22 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Just incase anyone else has the same problem, the message can be disabled in excel under the "trust centre" settings.

Thanks for the help.
Go to Top of Page

Conexclack

USA
2 Posts
Posted - 02/01/2014 :  11:38:01 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
thanks - was looking for a fix for this
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000