Hello, trying to help complete a project for a friend. We're trying to create a time clock to payroll time sheet program in excel 2003. The input data is a .csv file though. It seams that the code we've been using doesn't populate the data properly so there are missing hours on the time sheets even though the info is there according to the .csv file generated by the swipe clock. After trying all sorts of options, basically the problem is that the code says open the csv rather than opening it using the import data, using the import external data feature in the data menu. the existing code uses "applications.getopen" in the code What's the vb code for importing external data instead? Thanks All!
What is your delimeter in the CSV files? I've found that time fields can have odd delimeters such as colons which sometimes mess up the placement in the spreadsheet What language are you coding in? There are plenty of modules/classes out there for dealing with excel for PHP and Perl especially...
i'm just using the vb editor in excel 2003. the delimiter is set to comma no php or pearl involved. this is not web based, just an excel .xls
hmm, so what happens when you take the same data and import it manually using excel's 'text to data' button? Sorry, not a VB or Excel person
problem resolved, there was a date format error in the code, import not needed. "application.getopenfile" works fine... thanks for the help though!