Script to save Excel file to the server.
 

Hi..

I have a excel sheet that contains employee details.I now want to save
this file to a remote server as a "TAB DELIMITTED FILE"so that it gets
updated to a database.

I prefer this to be a automated process.

Is there any script for doing this.Could anyone help me on this.

Thanking You,
cooldude


--
raj41977
------------------------------------------------------------------------
raj41977's Profile: http://www.excelforum.com/member.php...o&userid=29427
View this thread: http://www.excelforum.com/showthread...hreadid=491360

Script to save Excel file to the server.
 

Try recording a macro when you do it manually. You'll almost be done.

If you need help tweaking your code, post back with the snippet of code that
needs help and your new question.

raj41977 wrote:

Hi..

I have a excel sheet that contains employee details.I now want to save
this file to a remote server as a "TAB DELIMITTED FILE"so that it gets
updated to a database.

I prefer this to be a automated process.

Is there any script for doing this.Could anyone help me on this.

Thanking You,
cooldude

--
raj41977
------------------------------------------------------------------------
raj41977's Profile: http://www.excelforum.com/member.php...o&userid=29427
View this thread: http://www.excelforum.com/showthread...hreadid=491360

--

Dave Peterson

Script to save Excel file to the server.
 

Thank you very much..

But i am not able to get the code for this,I am very much new to
excel.

I would be greatful if you could please help with some web links that
gives me some examples.

Thanks,
cooldude.


--
raj41977
------------------------------------------------------------------------
raj41977's Profile: http://www.excelforum.com/member.php...o&userid=29427
View this thread: http://www.excelforum.com/showthread...hreadid=491360

Script to save Excel file to the server.
 

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

And Tushar Mehta has some notes at:
http://www.tushar-mehta.com/excel/vb...acro_recorder/

raj41977 wrote:

Thank you very much..

But i am not able to get the code for this,I am very much new to
excel.

I would be greatful if you could please help with some web links that
gives me some examples.

Thanks,
cooldude.

--
raj41977
------------------------------------------------------------------------
raj41977's Profile: http://www.excelforum.com/member.php...o&userid=29427
View this thread: http://www.excelforum.com/showthread...hreadid=491360

--

Dave Peterson