PDA

View Full Version : Save sheet as csv to specific network folder



vavs
08-07-2013, 07:02 AM
First and most important, I am doing all of this with Excel 2011 for Mac. I have a macro that was originally written to parse a report provided by a client into a usable Excel worksheet. The code allows the user to select a file from the finder window and then parses the data into a spreadsheet. The new step that they would like me to do is to take the completed worksheet and filter it based on a data range that they would put into a user form. I would then replace the date field with a text field indicating a stage. That is all very easy. Here is the hard part, I need to now save the worksheet as a csv that I can import into a SQL database. I am taking all of the information and reporting back to the client based on a months worth of data that will most likely reach 100K rows of data. What I would like to do is after the processing is complete, save the file to a specific network folder where I can pick it up and load it into SQL. The file that is saved will need to be saved so that the user can recall it if necessary. My question is how to identify the network drive within VBA when I save the file. I have done this on Windows but have never done it on a Mac, I have always used MacScript to call the finder.

Any help would be greatly appreciated.

SamT
08-07-2013, 08:53 AM
http://www.westwind.com/reference/OS-X/paths.html

https://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/macfile.mspx?mfr=true

https://en.wikipedia.org/wiki/Path_%28computing%29