|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 14th, 2008, 03:20 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Access
Is there a way to include a value from a text box on a form as part of the
path name when using transferspread in a macro. C:\documents\DeptScrapbyArea (insert deptNo from form text box).xls 
|
|
#2
November 14th, 2008, 04:58 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Access
Yes. Use:
"C:\documents\DeptScrapbyArea" & Me.txtWhatever & ".xls" -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "dsnyderwoo" wrote in message ... Is there a way to include a value from a text box on a form as part of the path name when using transferspread in a macro. C:\documents\DeptScrapbyArea (insert deptNo from form text box).xls
|
|
#3
November 15th, 2008, 12:43 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Access
"Arvin Meyer [MVP]" wrote: Yes. Use: "C:\documents\DeptScrapbyArea" & Me.txtWhatever & ".xls" -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "dsnyderwoo" wrote in message ... Is there a way to include a value from a text box on a form as part of the path name when using transferspread in a macro. C:\documents\DeptScrapbyArea (insert deptNo from form text box).xls Arvin Thank you for the reply I tryed your suggestion as the following string and Access did not export the excel file using transferspreadsheet from the macro. Do you see any mistake that I made setting up the path? C:\Documents and settings\Dave Lecon\My Documents\DeptScrapbyArea_BadPieces"Me.txt[forms]![DeptScrapbyArea]![DeptNo]&".xls
|
|
#4
November 15th, 2008, 05:00 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Access
Yes 2 mistakes. It should look like this without newsreader line wrapping:
"C:\Documents and settings\Dave Lecon\My Documents\DeptScrapbyArea_BadPieces" & Me.txt[forms]![DeptScrapbyArea]![DeptNo] & ".xls" Make sure you get all the spaces, quotes, and ampersands correct. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "dsnyderwoo" wrote in message ... "Arvin Meyer [MVP]" wrote: Yes. Use: "C:\documents\DeptScrapbyArea" & Me.txtWhatever & ".xls" -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "dsnyderwoo" wrote in message ... Is there a way to include a value from a text box on a form as part of the path name when using transferspread in a macro. C:\documents\DeptScrapbyArea (insert deptNo from form text box).xls Arvin Thank you for the reply I tryed your suggestion as the following string and Access did not export the excel file using transferspreadsheet from the macro. Do you see any mistake that I made setting up the path? C:\Documents and settings\Dave Lecon\My Documents\DeptScrapbyArea_BadPieces"Me.txt[forms]![DeptScrapbyArea]![DeptNo]&".xls
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
