My Assistant
Site Message
(Message will auto close in 2 seconds)
 Concatenating File Name In Export Macro, Office 2010
|
|
 Mar 2 2012, 05:59 AM
Post
#1
|
|
|
UtterAccess Member Posts: 23  |
Dear All
I Have a system running and I would like each user to export and import data via the import/export excel macro. Currently the code is C:\SUBMIT FOLDER\SUBMITFILE.xls I need to replace it with some code and a variable containg the user name. I have seen on the web like ="\\Network_Path\& even a date & "File name.xls" I could not get it to work. HELP please. Blessings. |
 |
 
|
Posts in this topic
kobus-dippenaar Concatenating File Name In Export Macro Mar 2 2012, 05:59 AM
arnelgp You must have a write right on the shared network ... Mar 2 2012, 07:30 AM kobus-dippenaar Thanks. Get the user is not the problem. It is to ... Mar 2 2012, 07:45 AM
kobus-dippenaar Yahooooo! Hallelujah!!!
I have so... Mar 3 2012, 01:46 AM |
  |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 21st May 2013 - 11:34 PM |