Jump to content
Macro Express Forums

mtomas

Members
  • Posts

    10
  • Joined

  • Last visited

Everything posted by mtomas

  1. I see....that works, even allows customized text. thank you for the replies!!
  2. thanks , but are you saying that everytime i want to change the number of pages i want to print (loops to perform) i need to open the macro up and adjust the variables number? each day the number of pages i want to print will change, so having an input box ask how many pages then using that number as the #loops to perform would be easiest. please let me know if I missed the command that always me to accomplish this.. thanks
  3. I have read through the help for the dialog boxes available. I did not see anything on a inputbox where the input (variable) can then be used in a loop. Does anyone know whats the best way to accomplish this? Basically i am running a self print macro that advances the webpage via a arrow key and presses a print icon on the screen to print, the number of pages to print (loop) will be determined by the input i choose that day. so inputbox "How many pages do you want to print today? ___ (that number would go to the loop function) thanks if you can point me to past topics or send a sample macro.
  4. Win7 and Excel 2007 (file ext is .xlsx not .xls) i moved the activation from desktop to documents folder and it seems to trigger the macro fine. I took your original macro and just created the launch program c:\users\mts\documents\indeedjobs.xlsx If Not File Exists: "C:\Users\MTS\Documents\IndeedJobs.xlsx" Macro Stop Else Program Launch: "indeedjobs.xlsx" (Maximized) Parameters: End If the problem is that is continues to loop the macro when i close the excel file, when i close the indeedjobs.xlxs file it reopens again, which is correct: if file exists, program launch... any suggestions on how to correct this action?
  5. thanks for the input... i have tested this several ways.. ----------------- activation: directory modification, points to desktop c:\users\mts\desktop MACRO: if not file :\users\mts\desktop\indeedjobs.xls macro stop else run my macro ----------------------- when i run my extraction SW and it saves this indeedjobs.xls file onto my desktop, nothing happens, ME does not run the macro BUT...when i double click this file, the ME macro runs, the problem is that is continues to run, so if i try to close down indeedjobs.xls & dont save changes, it just runs the macro again and opens the file again. If i save it with another name, it runs the macro again as well, (the original file name still exists on the desktop) so i have no other option but to disable this macro...i have Win7 and Excel 2007. is the issue the desktop "folder", there seems not to be an activation event, BUT the macros If NOT file causes the macro to loop... see attached JPG
  6. I stand corrected, i assumed you needed to add both parameters; program to launch and file location\name. which basically does what its told... as terry pointed out you can just place the location\filename into the Program to Launch criteria which WILL launch the file and not the program (if already opened) sorry to jumping to my second conclusion and thank you for the replies! MTS
  7. Thank you for all the responses.. again, when i double-click the file and i have excel already open then it just opens the file and NOT another instance of the program. So it is not excel itself that chooses to open another application when someone opens a file to be open. the issue is that ME doesnt open a file, it launches an application again... Excel is doing exactly what is being asked, "launch program: excel.exe with parameters c:\myfilename.xls", a ME should be able to handle a simple "open file" function and not use the "launch program" function.
  8. I run an extraction software that extracts data from websites and places all the data in a grid then saves the grid(spreadsheet) as an excel file on my desktop automatically with the same name everytime.. (i eventually rename this file once i process it myself in excel) i am trying to run a macro and have this event (when this file.xls is saved onto my desktop) activate my macro. I have toyed with the directory modification but that doesnt seem to trigger the macro... Has anyone tried this activation trigger ? basically once this file.xls appears saved on my desktop, that should trigger my macro to run. any help would be appreciated. thanks
  9. thank you for the code, it does work.... I am running Excel 2007. When I have Excel opened and I double click the file, it opens the file and not another instance of Excel.. ME does not have a open file function (kinda of hard to believe, computers are file systems)... So the only option is to launch a program, which is exactly what ME does to open a file...launches another instance of a program, very inefficient on many levels... if someone has another option of opening a file, please let me know. Though the code above works i dont like that it relies on keystrokes to handle this task thanks for the replies JR
  10. i have been using the Program Launch function to open an Excel File on an event. The problem is that the options are activate window (if available) or launch the program (with file location/name as a parameter). This does open the file BUT it causes another instance of Excel to open, so I have 2 instances of Excel running or however many if I continue to use this method... This is not only inefficient but it also evokes an error message for Excels personal.xls folder. What is the best way to open a file without needing to launch another instance of a program? thank you! JonR
×
×
  • Create New...