Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default Enter data from excel sheet to another excel workbook.

Hi,

I have an excel spreadsheet which is to function as a standard company
timesheet.

The problem I have is that the VBA behind it was previously used to enter
data and connect to Access.db at the click of a command button.

There is alot of VB data validation behind it - my question is how can I
find and replace all aspects of Access coding and convert all VB to re-direct
all data to a new excel spreadsheet?

Thanks
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
enter data on 1 sheet and make it enter on next avail row on 2nd s Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM
How do I import data from 1 workbook excel sheet into another? LJHolland New Users to Excel 1 June 2nd 05 02:59 PM
Excel VBA - How to enter a reference to another sheet? deko[_3_] Excel Programming 8 April 17th 05 10:07 PM
EXCEL: Find data in worksheet and create a new sheet in same workbook Peacce Dog Excel Programming 3 November 18th 04 08:05 PM
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet arunjoshi[_5_] Excel Programming 1 May 2nd 04 03:50 PM


All times are GMT +1. The time now is 06:27 AM.

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

About Us

"It's about Microsoft Excel"