Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filepath variable
Using "filepath = Application.ThisWorkbook.Path" as a statement in a
commandbutton gets me the data I need. Is there any way to put this statement somewhere so that the data is available in every commandbutton in the workbook? So I could just use "filepath" everywhere without having to declare it in every button?\ Using "Public filepath as text" in each worksheet works, but I still have to make the "filepath=application..." statement in a worksheet.activate section in every worksheet. I tried putting it in the Workbook declarations section without success. Any suggestions? thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
filepath variable
Why use filepath ??
Simple use this in your code ThisWorkbook.Path & "/" & filenameVar & ".xls" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "videor" wrote in message . .. Using "filepath = Application.ThisWorkbook.Path" as a statement in a commandbutton gets me the data I need. Is there any way to put this statement somewhere so that the data is available in every commandbutton in the workbook? So I could just use "filepath" everywhere without having to declare it in every button?\ Using "Public filepath as text" in each worksheet works, but I still have to make the "filepath=application..." statement in a worksheet.activate section in every worksheet. I tried putting it in the Workbook declarations section without success. Any suggestions? thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
filepath variable
Try putting the variable in a VBA module.
Public strMyPath As String Public Sub get_path() strMyPath = ThisWorkbook.Path End Sub You can call the sub "get_path()" in the workbook_Open event or something. -- Hmm...they have the Internet on COMPUTERS now! "videor" wrote: Using "filepath = Application.ThisWorkbook.Path" as a statement in a commandbutton gets me the data I need. Is there any way to put this statement somewhere so that the data is available in every commandbutton in the workbook? So I could just use "filepath" everywhere without having to declare it in every button?\ Using "Public filepath as text" in each worksheet works, but I still have to make the "filepath=application..." statement in a worksheet.activate section in every worksheet. I tried putting it in the Workbook declarations section without success. Any suggestions? thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
filepath variable
why not just use thisworkbook.path whenever you need it, instead of putting
in a variable. But if you must: put this at the top of a normal module not a worksheet or thisworkbook: public filepath as string then set it wherever you like, e.g. in workbook_open and/or workbook_beforesave Chris "videor" wrote in message . .. Using "filepath = Application.ThisWorkbook.Path" as a statement in a commandbutton gets me the data I need. Is there any way to put this statement somewhere so that the data is available in every commandbutton in the workbook? So I could just use "filepath" everywhere without having to declare it in every button?\ Using "Public filepath as text" in each worksheet works, but I still have to make the "filepath=application..." statement in a worksheet.activate section in every worksheet. I tried putting it in the Workbook declarations section without success. Any suggestions? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is filepath valid? | Excel Programming | |||
Create filepath if it's not available | Excel Programming | |||
Filepath | Excel Discussion (Misc queries) | |||
Filepath | Excel Discussion (Misc queries) | |||
get filename and filepath | Excel Programming |