Prefill Cells With Command Line Switches From A Browser
Jan 28, 2014
I'm looking to have an excell file shared on a windows network to a simple LAN (samba sharing), and then for a user to be able to click on a HTML link that will launch that excell pile, and to have it populate specific and predeterminined cells with information that will be handed to it by the HTML link from the website.
Think of a CRM web app that href is a link like: "LAN1Filesexcellbook01.xls?Mrs%20Wendy%20Jones?4%20Skin%20Street"
From something like that I would like to launch excell and have Mrs Jones' details populate into the predefined excell sheet. The HTML website can dynamically populate a HTML link depending on the customer being viewed.
So I'd like to know how two things
1) How to launch a network file in this way, while correctly handing it parameters or switched that it will be able to later:
2) Collect that information and distribute it into the cells I choose in VBA.
I'm familiar with Visual Basic .Net primarily, and have a small amount of VBA experience.
We would like to continue to use Google chrome if possible...
View 5 Replies
ADVERTISEMENT
Mar 7, 2006
Is there any way to run a command line from excel?
E.g. i want excel to call this command:
ping 10.100.100.100 and then return the result to a txt file?
View 9 Replies
View Related
Mar 27, 2008
How can I get at parameters passed on a command line to Excel 2007?
For example invoking Excel from Vista's Run command with:
"C:ProgramDataMicrosoftWindowsStart MenuProgramsMicrosoft OfficeMicrosoft Office Excel 2007" "C:GZNORPWeather StationParamTest1.xlsm" /e/abc/def
Should reveal the parameters "abc" and "def". But this does not happen!
Supposedly, the API function GetCommandLine does this, but I cannot seem to get it to work. Here's a sample of what I've been trying:
View 9 Replies
View Related
Feb 10, 2012
I've got an Excel file that uses 7-zip. It can execute a command line that will use 7-zip to go to a folder and zip each of the folder's files into its own zip file, placing the zips in a single, specified destination folder. I can specify whether to look in the source folder, or to also look in all of the source folder's subdirectories.
Question is, how do I tell 7-zip to just zip ONE file, and how do I tell 7-zip to zip a SPECIFIC LIST of files that I name (instead of looking through a whole folder)? how to use command line...
Code:
Sub a_zip_with_sub_directories()
Shell "cmd /c for /r ""C:Users aiDocumentsmonthly reportsFinal Copies of Monthly Reports"" %i in (*.*) do ""%ProgramFiles%7-Zip7za.exe"" a -tzip ""C:DATA aiipped\%~ni"" ""%i"""
End Sub
Sub a_zip_no_sub_directories()
Shell "cmd /c for %i in (""C:Users aiDocumentsmonthly reportsFinal Copies of Monthly Reports*.*"") do ""%ProgramFiles%7-Zip7za.exe"" a -tzip ""C:DATA aiipped\%~ni"" ""%i"""
End Sub
View 2 Replies
View Related
Dec 17, 2012
i have batch file that run from VBAexcel But the thing is i dont want to run batch file
i want everything on VBA . for example you use vba to cmd and then run this line of command
i have try but i just new to VBA and programing
how can i do it
here the code
this is from batch
Code:
@echo off
>summary.txt (
for %%F in (*chkpackage.log) do findstr /l %1 "%%F" nul||echo %%F:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A:N/A
)
and this is code in vba
Code:
FileSet = Sheet1.Range("C13")
txtFpath = Sheet1.Range("C7").Value
FilePath = txtFpath & "
es.bat"
[Code]...
i have to admit that i'm really not good in programing if you can add some explaination is a great thing for me to try to study
View 1 Replies
View Related
Mar 25, 2004
Is there a way to print an Excel Workbook from the command line? Is there a command line reference anywhere for Excel?
View 9 Replies
View Related
Oct 17, 2008
I found the following link that got me started [url], so now I have my code for reading/analyzing comand line parameters. Here is an example of the parm I'm passing in ....
View 9 Replies
View Related
Oct 8, 2012
I have a userform with a numerous textboxes, which I have labeled with similar text and a unique number at the end (num1_txt, num2_txt, num3_txt, etc.). I am trying to create a for loop that sequentially references the numbers of the text boxes and pulls the user-entered value in the text boxes into an Excel document.
Here is the code I have so far...
VB:
i = 1
For i = 1 To 18
Dim cyltrack As String
cyltrack = "Me.cyltrack" & i & "_txt.Text"
If Me.cyltrack.Value = "" Then
Cells((cellcount + i), 13).Value = "*"
Else
Cells((cellcount + i), 13).Value = cyltrack
End If
Next i
I am running into problems in trying to convert the string variable, cyltrack, into hard code that I could insert into Me.cyltrack.Value.
View 4 Replies
View Related
Feb 26, 2007
I have created an AddIn for a project I'm working on using the 'Open' command in Excel Vb. While this worked perfectly for the file I was testing it on (1,740,754 bytes) it doesn't work on a new file (121,445,125 bytes).
On testing the code, one line at a time, it gets stuck on
Line Input #1, DataLine
The files only contain one line so I suspect there is too much data for the command to handle.
Is there an alternative?
View 9 Replies
View Related
Jul 31, 2014
I've recently created a macro which takes a .csv file and scrubs the data and dresses it up for a report. I've finally got it running without any problems and have added it individually to 5 different user accounts on my network as an add-in, but need a way to share it across a computer network without allowing others to edit the file.
The report is generated multiple times a day by the different users, none of whom are very computer literate (not that I am much better, myself), and the macro over-writes the old file each time. I've read that it's possible to simply create a shortcut to the file that automatically opens the spreadsheet in read-only format, which would be perfect for what I'm trying to do, but I haven't been able to get it to work so far.
My current shortcut pathway is similar to this:
"C:Program FilesMicrosoft OfficeOffice15EXCEL.EXE" /R "C:UsersBenDocumentsOT Master.xlsx"
On my computer at work (Windows 7) the shortcut simply opens the spreadsheet so that anyone can edit it, instead of as a read-only file. On my computer at home (I'm trying to experiment) (windows 8.1) it won't even let me save the shortcut, saying I need to provide administrator permission & then cutting to a window that says "access denied".
I won't have the pathway for the actual file I'm trying to create a shortcut for until tomorrow when I get back to work, but I've formatted it essentially the same, directing to the excel.exe file, running the switch "/R", and then directing it to the actual file location.
The ultimate goal is to have multiple people be able to view the file without locking out those who need to update it.
View 1 Replies
View Related
Feb 23, 2013
I have the data to import / read in a pdf, in a doc, or in an Excel worksheet whichever is easier to use. I need to import the data, parse it into the correct cells for that row and then repeat the import until the end of the file. Not all the cells are in each group of data to import, so those cells will be null for that row. Some of the data for one cell may be in up to 14 lines in the data file. I have be concatenating these data rows into one cell. There are 48,000 lines in the file to import or I would do this manually. I am assuming that doing this in VBA would be the most efficient method.
View 11 Replies
View Related
Oct 9, 2009
How many switches? 4
The result should look like this:
interface range GigabitEthernet1/0/1 - 48,GigabitEthernet2/0/1 - 48,GigabitEthernet3/0/1 - 48,GigabitEthernet4/0/1 - 48
this is what I have so far:
=REPT("GigabitEthernet, ()/0/1 - 48,",D1)
I need the area in the parentheses to iterate to the number of switches
View 14 Replies
View Related
Aug 5, 2014
I'm trying to combine 2 cells that both have text on multiple lines separated by line breaks. I want to keep the formatting so that when both cells are combined, line one from cell 1 and line 1 from cell 2 are on the same line in the new combined cell. This is easy to do when there is only 1 line in each cell but how do you do this for cells with multiple lines? Here is an example of what I am trying to do:
A
B
C
1
First Name:
Last Name:
Address:
John
Smith
123 Harold Street
First Name: John
Last Name: Smith
Address: 123 Harold Street
View 7 Replies
View Related
Feb 4, 2014
Below is a VBA that sends an email with a range from Excel in the body of the email, and the entire book as an attachment from a temporary file. It works great, except that I need the entire file to close, and it will not because a message pops up that says "Do you want to save file before switching file status". This will not let Excel close. I need to bypass that pop up message. Display Alerts = False did not work. In the bottom of the code below, there is a spot that tries to kill the temporary file, but it does not work until "No" in the pop up message is pressed. Again, I need to bypass that pop up message.
View 2 Replies
View Related
Aug 7, 2013
I have a workbook with multiple sheets where the view for each sheet is the Normal view.
If I print the entire workbook, the active sheet changes to the Page Break Preview view after the printing finishes.
I have to then reset the view back to Normal.
I don't know why the active worksheet is changing. I don't want to annoy the people who will use this workbook by making them change back to normal view after each time they print.
View 3 Replies
View Related
May 29, 2014
I have a workbook that I'm using to tracking staffing patterns within a mental health agency. When the workbook opens the user is asked to pick a date range and an office location. I've placed code into the userform that pre-fills the "start date" with today's date and the "end date" 7 days from today's date. I would like the user to be able to enter a unique date range should they wish but I have yet to figure out the coding to accomplish my goal.
[Code] .....
Attached File : Staffing Report 1.90.xlsm
View 7 Replies
View Related
Mar 31, 2007
I have two sheets and two listbox's(ColumnCount8) and one command button.
lstInYard rowsource is set to sheet1
lstMilled rowsorce is set to sheet3
Iam trying to cut and paste the selections in lstInYard to lstMilled as well as the corrosponding row values in sheet1 to sheet3 by using cmdMoveSelected click event.
View 9 Replies
View Related
Aug 5, 2008
I need a macro that switches the Ribbon to the "Home" tab.
View 2 Replies
View Related
Feb 13, 2010
I have a file which extracts employee entries when you put the employee code. Have created a form to show the progress % and estimated time for search.
In this form i have added a animation .gif file and it runs fine on my PC but not on any other PC as the .gif file is store on my desktop.
I want to store this .gif file on the workbook and any way i can set a path for the program to pick up the .gif file from the same excel workbook.
View 9 Replies
View Related
Feb 11, 2006
I would like to embed a chart that updates from the web into my spreadsheet. This is it here:
[url]
View 9 Replies
View Related
Jan 11, 2009
Is there any way to treat the VBA Object Browser with code?
For example: Put on a UserForm.Lable.Caption data from the Object Browser:
All Classes in MSForms, and all Members of MSForms 'CheckBox' class.
View 9 Replies
View Related
Sep 26, 2006
Need a way to open a web page in VBA without using a function?
View 8 Replies
View Related
Dec 13, 2006
I am having problems refreshing my querytable.. I used the standard code that I found here in Ozgrid, it downloads the version, but when I changed it on the website, it still shows the old number. It does this until I refresh the website (via web browser). I thought the query table went to the site, and downloaded what was there, but I guess not? ...
View 5 Replies
View Related
Oct 29, 2008
i have a sheet that autogenerates a .csv file and uploads it into a webform. In order to do this I have to open an Internet Explorer window go to webpage and use the sendkye function, my code looks like this:
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate "http://uploadsite/upload.form"
'Check connection til web loop!
Do
If ie.ReadyState = 4 Then
ie.Visible = False
Exit Do
Else
DoEvents
End If
Loop
if I instead could EMBED the webbrowser into my sheet and then go to the upload site and upload the file directly from the sheet. I have some basic vba skills, but I have never worked with the embedded objects.
View 9 Replies
View Related
Nov 11, 2009
I wondered if it would be possible to copy the url from the active page from my browser into Excel using VBA (using a private sub). Something like:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim url As String
'url = the url from my active tab in my browser
If Target.Column = 1 And Not IsEmpty(Target) Then
Target.Offset(, 1).Value = url
End If
End Sub
where e.g. the active url in my browser is http://www.mrexcel.com/forum/forumdisplay.php?f=10.
View 9 Replies
View Related
Feb 11, 2005
This is probably quite trivial but I really need to know how to call up the standard folder browser from my VBA macro in Excel (and obviously return the selected path to a variable). I'm running windows XP by the way
View 5 Replies
View Related
Apr 14, 2006
I have a worksheet that is a graphical display of a call floor with its cubicles. I am able to pop up a box with many details about the workstation in the cubicle (see Display pop-up box when cell selected) for more details, and would now like to go further with this application.
Our practice is to use VNC to review the end users' screens when they call us for assistance; given that I know the machine name and IP address, how can I start a VNC browsing session for the target machine?
View 5 Replies
View Related
Sep 24, 2007
I'm relatively new to macro's. I have an excel workbook that draws information from an exported file from a website. When I do this I get an IE window open which is of variable name depending on the information I picked on the website. I am trying to create a macro that will close this new window on importing but leave the original website window where it is. The name is variable but has the same format e.g. "http://batch+report+info....." with the later address changing depending on the info selected. I tried using a an " If name.like" formula but am too new to macro's to know how to implement it.
View 3 Replies
View Related
Jul 22, 2013
I'm having a problem with copying numbers from web browser to excel.
For example I want to copy number 2013072210000117 but Excel displays it like this 2013072210000110. I tried to change Cell formatting but no success.
View 1 Replies
View Related
Sep 23, 2013
Is there a way to take a column of numbers, say UPC numbers, and break out each number separately to paste into a browser window for a web search?
Would this require a macro?
View 5 Replies
View Related
