Re: $$Excel-Macros$$ Re: Save a File From a Macro as a TXT file without an File Extension

2011-11-23 Thread tom rowe
Good morning Deepak. The files I'm trying to save are configuration files for a SIP/IP telephony call server. The server wants to see the file naming convention as just the MAC address of the IP phone, hence the need to drop the file extension. If I can save the file in my Excel/VBA macro after m

Re: $$Excel-Macros$$ Incrementing Row by 1 in a Variable

2011-11-22 Thread tom rowe
Asa, first off, thank you for your fast response. I think I understand your logic and it seems so simple :-) In you reference to my rookie mistake and selecting cells, are you suggesting that I do not need to call out the absolute cell reference (i.e., A1) but can use Cells(x.x).Select command?

Re: $$Excel-Macros$$ Incrementing Row by 1 in a Variable

2011-11-22 Thread tom rowe
Asa, just tried the code you provided. It works great! You ROCK! Thanks again, Tom On Tue, Nov 22, 2011 at 8:01 PM, Asa Rossoff wrote: > Hi TomR, > > ** ** > > You can use the same technique you use to increment the row selected at > the end of the loop to reference cells in the selected