baghenamoth Posted June 4, 2006 Share Posted June 4, 2006 Can someone help me to simply run excel macro please? I tried with excelcom but I don't understand how to use this function (becasue there is no sheet or value, but just the name of the sub and eventually the module and the workbook): _XLmacroRun($sFilePath,$Sheet,$ExcelValue) I'd like a nice solution, I don't want to : 1- open excel 2 - go to macro menu 3 - click on my macro to run If someone can do that it will be very nice thanks in advance P.S. : my excuses for my aproximatif English Link to comment Share on other sites More sharing options...
randallc Posted June 4, 2006 Share Posted June 4, 2006 Hi,See this thread for an example.Best, Randall_XLmacroRun($FilePath,1,"persoNAL.XLS!ImportCSV") ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
baghenamoth Posted June 4, 2006 Author Share Posted June 4, 2006 _XLmacroRun($FilePath,1,"persoNAL.XLS!ImportCSV")Excelent, it works great ! !Thank you very much for your help Link to comment Share on other sites More sharing options...
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