I have written a program in VB 6 which take simple data and saves it to a text file. I have then written a macro in Excel to import the data and do various things with it. I want to use this over a
network, therefore need a multiuser function so more than 1 person can access the saved file at once. So I want to save the data directly to an Excel spreadsheet, but so each variable goes into a specific cell.
This is the problem I am having as I can get it to save to the spreadsheet, just not in seperate cells, it puts all the variables in the same cell.
Anyhelp would be great .