I'm using this code to insert various file types as an object in Excel. Is there a way to stop the file from trying to run any autorun macros?
[VBA]
ActiveSheet.OLEObjects.Add(Filename:=FName).Select
With Selection
.ShapeRange.Left = [D1].Left
.ShapeRange.Top = Cells(ActiveWindow.ScrollRow + 1, 4).Top
.ShapeRange.Width = 400
End With
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
You might have to duplicate the manual method of holding down Shift while opening the file or something....if it can be done manually...it can be done in code is usually the thought process I take.
I am unfamiliar with the exact steps needed to "stop" and AUto_Open macro...
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Hi Malcolm,
Wouldn't Application.EnableEvents = False do what you want?
John
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Hi John,
If you think I would miss something as simple as that, you're absolutely right!
I'll check it out tomorrow.
Regards
Malcolm
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
LOL, I assumed you had tried that already and it didn't work!
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Events are disabled in Excel, but not disabled in the application to be opened. Ideally, the macro warnings should not appear either. All I really want is a "snapshot" of the document, or whatever.
The query relates to this posting
http://vbaexpress.com/forum/showpost...1&postcount=15
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
You can use the excel viewer if it is for excel 2003 maybe, but maybe you bypass it with a pop up asking if they want to preview the file before any action is taken?
If you have posted the same question at multiple forums, please read this IMPORTANT INFO.
Please use the thread tools to mark your thread Solved
Please review the Knowledge Base
for samples and solutions , or to submit your own!
Posting Permissions
Reply With Quote
