JulienL Posted April 29, 2016 Posted April 29, 2016 Hello, I'm trying to ask Autoit to open an Excel file with the following code : #include <Excel.au3> $oExcel = _Excel_Open() $oFile = @ScriptDir & "D:\XXX\List.xlsx" _Excel_BookOpen($oExcel, $oFile) When I run the script, I have Excel opens but closes immediately without opening my file ... Am I missing something ? I'm using windows 10 and Excel 2013
BrewManNH Posted April 29, 2016 Posted April 29, 2016 You have $oFile set to the directory that the script is in plus the d: path, I am 100% sure that you wrote that line wrong. If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag GudeHow to ask questions the smart way! I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from. Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays. - ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script. - Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label. - _FileGetProperty - Retrieve the properties of a file - SciTE Toolbar - A toolbar demo for use with the SciTE editor - GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI. - Latin Square password generator
Jfish Posted April 29, 2016 Posted April 29, 2016 @BrewManNH beat me to it. Try seeing what you are attempting to open like this: MsgBox(0,'',@ScriptDir & "D:\XXX\List.xlsx") Build your own poker game with AutoIt: pokerlogic.au3 | Learn To Program Using FREE Tools with AutoIt
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now