Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 ferha_jafri
		
			ferha_jafri
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello all ,
I want to show the path as Home > Group > Parameters > P&L
and Home > Group > Parameters > BS in this parameter is a button and P&L AND BS are the sheets.
Thanks in advance
Ferha Jafri
 
					
				
		
 ariel_klien
		
			ariel_klien
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi
Try GetActiveSheetId()
BR
Ariel
 
					
				
		
 israrkhan
		
			israrkhan
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Use filepath() function...
Example:
Load *, filepath( ) as X from
C:\UserFiles\abc.txt
Will return 'C:\UserFiles\abc.txt' in field X in each record read. then you can concatenate sheetid or sheet name with.
OR
you can try GetFolderPath() as well...
Hope it helps.
 ferha_jafri
		
			ferha_jafri
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		sorry but i am not able to use this function as i am not able to find this function in help as well,plz suggest what should i do.
 ferha_jafri
		
			ferha_jafri
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Please suggest me what should i do on this as i want to show the path as the path show the sheet name as we move from one sheet to other.
plz check the qvw,in this i want to show the path at the top of each sheet as we move from one sheet to other as:Home > Group > Parameters > P&L
 kaushiknsolanki
		
			kaushiknsolanki
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hi,
Purdon me, I couldnt able to understand what you actually want to do.
Kindly explain with example.
If possible upload the same qvw file for reference.
Regards,
Kaushik Solanki
 ferha_jafri
		
			ferha_jafri
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello Kaushik,
I attached my document ,i hope you got my issue plz if you the answer then let me know as i am not able to get the answer to the question.
Thank you
Ferha Jafri
 ferha_jafri
		
			ferha_jafri
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello All,
Please reply if anyone know how to show the path..
