Hi there,
I am new to VBA programming nad dont know the concept of how to work with it. My scenerio is :
I want pass inputfile and outputfile arguments using command line with inputfile as excel sheet and outputfile as txt file. I want excel to somehow convert the inputfile into outputfile without actually opening excel I have no idea how this will work? Please help as this is urgent!
Thanks a lot for your help
Hello addictive_mate,
This can not be done from the Excel command line because the Save and SaveAs commands must be initiated from within the Excel application. It can be done in other ways. The urgency of your request and your desire to copy a file in a surreptitious manner does raise suspicion.So, I am a little hesitant to provide you with more information.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Posting Permissions
Reply With Quote
Bookmarks