on a computer running windows xp, I'm trying to do the FOLLOWING:
have Excel open workbook1 and run a macro in the personal workbook. workbook1 will be a different file each time (the macro only formats it). I can use a batch file to rename the workbook to have a generic name, and to open it in excel, but I can't get it to run the macro. I tried using sendkeys in access and again could open the file but not run the macro. I really don't know VB, but I had found a code for VB which would open the excel file and run a macro, but I could only get it to work if the macro was inside the workbook, it would SAY it couldn't FIND it if i had it in the personal workbook). I'm open to trying any combination now in order to automate a process of formatting the new workbooks each week (only one worksheet in the workbook).
p.s. I hope I have the right forum, as I wasn't sure whether applications, or dos, or programming would be the right forum and knew better than to post it in all of the forums.
Thanks.I may not be able to provide any real help to you on this but I THINK we need to know what version of Excel you are using.