Hi all
i have 3 questions.
I want that excel will open a file (invisibly) and run a macro (then quit).
all this using command line arguments. is it posibble?
I use the SaveAs method to save the file
in another name but i dont want it to save the file
with the macro.how can i do that
I want to lock my template in a way that the macro will be able
add or delete rows to the template but no one can modify the first 3 rows
and other things related to the template such as header and footer.
thanx.
Last edited by briana banks; 11-30-2008 at 02:27 AM.
Hello briana banks,
You can't start Excel invisibly using command line switched. You would need to create a script file with a .VBS file extension that contained the code necessary to start Excel invisibly, load your file, and run the macro. The VBS extension will run from the command line. What I am referring to is a VB Script file and not a VBA macro.
Sincerely,
Leith Ross
Hi and thanks for replying
Ok.then i'll write the vbs to open the excel file.
however the macro within the excel file i'm opening contains the macro.
i dont want that this macro will be transferred along with the new (SavedAs)
file and will be available for editing for excel users.
how can i do that?
Stick to one question per thread, you will get better responses
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks