Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
raj41977
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.misc
raj41977
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO YOU GET EXCEL TO ASK IF YOU WANT TO SAVE A FILE ON EXITING David Lambright Excel Discussion (Misc queries) 3 October 15th 05 07:46 AM
Save file in excel Rohan Setting up and Configuration of Excel 1 September 13th 05 04:35 PM
'document not saved' for 'save' or 'save as' an EXCEL file Judy Chuang Excel Discussion (Misc queries) 1 July 11th 05 10:12 PM
Excel prompts me to save a copy or overwrite file. Vinny Excel Worksheet Functions 0 May 20th 05 03:05 PM
Multiple people accessing an Excel file from a server at once. UABCSA Excel Discussion (Misc queries) 1 May 2nd 05 05:41 PM


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"