Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Parse text to Excel Cell via parameter (Read 5678 times)
Tony Nilsson
YaBB Newbies
*




Posts: 9
Parse text to Excel Cell via parameter
15.02.10 at 16:18:35
 
Hi Gerrit-Jan,
 
I wonder if you have a sulotion for this :
 
I whould like to click on a link with a text like 'Change_xxxxx'.
This should open up Excel, a specific file and then paste the text into cell A1.
 
Is this possible?
 
Best Regards
Tony Nilsson
Back to top
 
« Last Edit: 17.02.10 at 10:39:11 by Gerrit-Jan Linker »  
  IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Parse text to Excel Cell via parameter
Reply #1 - 17.02.10 at 10:41:01
 
Please explain a bit more.
 
Where should this link appear? On a web page? Hosted on a web server or on your local file server? Are you the only person to access this link or others also?
 
I assume that xxxx will be a full reference to the cell: [workbook.xls]Sheet1!A1 for example.
 
Where is the text you want to add to the cell?
Back to top
 
« Last Edit: 17.02.10 at 10:41:32 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Tony Nilsson
YaBB Newbies
*




Posts: 9
Re: Parse text to Excel Cell via parameter
Reply #2 - 18.02.10 at 17:36:18
 
See attached file
 
Best regards
Tony
Back to top
 
  IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Parse text to Excel Cell via parameter
Reply #3 - 19.02.10 at 09:44:05
 
I have added a function CommandLine. This will almost do what you require. It displays the full starting command that was used to start Excel. If you would start Excel like this it would display the parameters that you have sent in:
 
excel /_ThisIsMyCommandLineParameter
 
To also open a file you can use
 
excel myfile.xls /_ThisIsMyCommandLineParameter
 
Note that you are not allowed to type spaces in the parameter we added. It is actually regarded as a commandline switch and not as its value. You can replace spaces in your data with an underscore.
 
In Excel just type =CommandLine and you see which command was used to open the file. A little text manipulation will allow you to extract the values you need.
 
I don't know whether you still have the requirement to automatically populate a cell, say B5 on Shee1, with the value. Just use the formula in B5.
 
The new CommandLine funtion will be released in litLIB 2.0.6
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1