I want to capture a excel filename (blablabla.xls) to a variable name.but I want to search the file from browser like "Open file"give me a simple vb function and how to call it?
View 1 Replies
I'm working on a final project where I need to create a file for a recipe. I'm trying to take the name of the recipe as entered by the user in a specific text box and create a sequential access .txt file bearing the recipe's name.[code]...
View 1 RepliesI have written a macro that is pulling information from a "CapComm" file to a template file. This macro filters (based on a variable in the template file) different sheets in CapComm and pastes them in the appropriate places in the template file. I have no problems with that part of the code.
However, each time the macro is run the file is saved as a different filename. In the code there are several movements from one workbook to the other. Macros have been set up to select the appropriate CapComm file. But.... the template file itself will have a different name each time it is run.
For now, we are using the template file, running the macro and saving it as whatever the filename is to be. Then we open the template file again and repeat the process each time. I want to be able to get the templates current name and set that as a variable so we can use the template file, save it as whatever, use it again, save as whatever, etc instead of having to open the blank template each time.
I have tried declaring a variable and using both thisworkbook and activeworkbook, but when the macro moves to the CapComm file, this becomes the activeworkbook/thisworkbook and i end up with errors. Is there any way to get the name of the file at the start of the macro and keep this as until the macro ends or is run again?
I have written a macro that is pulling information from a "CapComm" file to a template file.This macro filters (based on a variable in the template file) different sheets in CapComm and pastes them in the appropriate places in the template file.I have no problems with that part of the code.However, each time the macro is run the file is saved as a different filename.In the code there are several movements from one workbook to the other.Macros have been set up to select the appropriate CapComm file.But.... the template file itself will have a different name each time it is run.For now, we are using the template file, running the macro and saving it as whatever the filename is to be.Then we open the template file again and repeat the process each time.
I want to be able to get the templates current name and set that as a variable so we can use the template file, save it as whatever, use it again, save as whatever, etc instead of having to open the blank template each time.I have tried declaring a variable and using both thisworkbook and activeworkbook, but when the macro moves to the CapComm file, this becomes the activeworkbook/thisworkbook and i end up with errors.Is there any way to get the name of the file at the start of the macro and keep this as until the macro ends or is run again?
[code]...
I want to create "FileName.xls" in "Excel 2007" with out changing the code I know that xlExcel.SaveAs("D:FileName",xlExcel8) code will Create "FileName.xls". Since I have more the 50 small application, in each application there are around 15 similar lines related to the above code (all are 6 to 7 Years old application).Is there any other methods (eg: Change in regedit ). so that output is "FileName.xls"
I use the followoing code to import an xlsx file into an Access 2007 table. It works fine when I enter the exact file name.However, part of the file name is a date which will change every week.The file location does not change,just the date in the file name.[code]I've tried using a wildcard but I get a Run-time error 3011.Db engine could not find the object. Make sure the object exists.
View 1 RepliesI have the following code to export a gridview to excel and the export works just fine. The issue is that no mater what I do it names the file the name of the webform .xls instead of the name I am providing in the code (Team.xls).
Protected Sub btnExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExcell.Click
Dim sw As New StringWriter()
Dim hw As New System.Web.UI.HtmlTextWriter(sw)
Dim frm As HtmlForm = New HtmlForm()
[code]....
I'm thinking about how best to accomplish the following and wanted to see what others suggest.I'd like to capture an Excelworksheetnd save the area that has been edited (vs. the area thatremains blank)s a PNG image. This would ideally be achieved through an Excel add-in.
View 1 RepliesQuick query...I'm trying to scan a long string and return any values that occur between the tags <FileName> and </FileName> I've got a bit of code here to use regular expressions to return the position of the occurunces of both substrings..Just wanted to find out if there is any way to scan for both substrings within one loop (as im currently doing 2, one for the first substring and one for the 2nd) so I can use something along these lines:
ringlist = Mid(XMLRESP, (startloc + 1), (endloc - 1))
MsgBox(ringlist)
to msg box the value between the substrings...either that or another approach to return the value between the 2 substrings (it can be of variable length)
Dim patternstart As String = "<FileName>"
Dim patternend As String = "</FileName>"
Dim matchesstart As MatchCollection = Regex.Matches(XMLRESP, patternstart)
[code].....
How would I do that? Sample code is below that demonstrated that the file I opened contained the full path and file name.
I want to extract just the path and serialize that to the user.config file as a UserSetting value. Then next time the user opens the dialog box, it uses that saved path string to go immediately to the location previously used.
If openFileDialog1.ShowDialog() = DialogResult.OK Then
Properties.Settings.Default.persistConnectionType = openFileDialog1.FileName
Properties.Settings.Default.Save();
[Code].....
I have a Listview on my form with different files. I can selet a file en open it with the proces start method. To open the file i use the OpenFileDialog method and select the filename. This work very good. With the code below.
My question is if there is a method to get the selected file without using the OpenFileDialog Box. So when i dubbelclick the selected file the proces will start with open the selected file. Something like:
proc.StartInfo.FileName = Me.SelectedCell.FileName
instead of proc.StartInfo.FileName = Me.OpenFileDialog1.FileName
PS) May be i can preduce the Filename using the OpenFileDialog method on the background.
Private Sub ListView1_MouseDoubleClick(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles ListView1.MouseDoubleClick
If Me.OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK Then
[Code]....
how do you transform an address like "file:///d:filename.ext" in "d:filename.ext"
without dirty string manipulation??
I am making an application in VB.Net. In which i am scanning some system folders and on the execution time it gives me the error;E.g,access to the path "C:any system file" is denied.Is there any code you people have that is edited in to the "form load" so when ever the application is executed, the denied error should be removed upon the form load?
the code is as follows
Imports System
Imports System.ComponentModel
[code]....
So I created a loop that collects data from the user that runs for a time dictated by the user. It then stores all the data in excel and outputs a graph.The problem I am having is that I cant seem to figure out a way to set the range of the graph for the points taken.since it runs on a loop i have i = i + 1.where the the output into the excel file sequentially writes to the next cell [code]which doesnt seem to work like I would have hoped.Also, there is one other thing that my program keeps doing that I cant seem to figure out.One of the outputs to the excel file is decimal number, it shows perfectly in the textbox, but when I export it to excel it rounds it to the nearest whole number.[code]
View 11 RepliesSo I am hacking together an app which listens to traffic using SharpPcap library, it reconstructs the packets from sessions using the code from TpcRcon.
Listening and reconstructing part work on their own . What I want is on each packet arrival main window gets an event so it can display the packet , and when session is reconstructed display a complete packet (I am interested in HTTP ones) . -That is where it breaks with weird symptoms: for example right now it does not stop on invoking stop listening method - the sharppcap library function hangs there forever waiting on this line of code : m_pcapThreadEvent.WaitOne();//wait for the 'stopped' signal from thread
I also had it not working and crashing in sharppcap function because I had omitted one parameter in form delegate- which makes no sense, because form delegate does not deal with packet capture at all and only reacts on "New Packet" event from my "Listener" class (which is only there to notify main form)
My app starts as module main instancing class "Listener". MainForm has it
registered as friend with event and handles even "New Packet"
Main Form:
Private Sub uiListenStart_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btListenStart.Click
aLogger.AddMessage("Started Listening")
[Code]....
I have a text box on a Powerpoint Slide. The text box contains text that I need to use in an Excel program. The Excel program will be run from a button on a toolbar within Powerpoint. I need to be able to pass the text box text, from Powerpoint to a variable in Excel, so I can use it in my Excel VBA code.
View 2 RepliesAs you can see below in the code the " & tblName & " will work fine but instead of using the BankName (which the user cannot change because it is in the code) I would like to do the same as I did with the Table name and use a variable that gets its name from an excel spreadsheet rather that an actual name hard coded in a VBA module. I would like the variable field name entered in the Excel Spreadsheet by the user just like the table name is filled in by the user. The problem is getting the ADO SQL string ( cmd.CommandText = "ALTER TABLE " & tblName & " Add Column BankName Char(25)" ) to recognize that the value in the Variable " & fldName & " is the field name to be used.
Sub AddFieldToAccess()
Dim cnn As ADODB.Connection
Dim cmd As ADODB.Command
[code]....
'If I do this I end up with a field named BankName what I need is the name in the variable " & fldName & "
cmd.CommandText = "ALTER TABLE " & tblName & " Add Column BankName Char(25)"
cmd.Execute , , adCmdText
Set cmd = Nothing
[code]....
I am getting the error:"Range variable 'sender' hides a variable in an enclosing block or a range variable previously defined in the query expression."for this
Imports System.Data.SqlClient
Imports System.Linq
Public Class Form1
[code]....
I can select any other item from the table without the error. "sender" has the same properties as "receiver" in the SQL table.
I have a text box on a Powerpoint Slide.The text box contains text that I need to use in an Excel program.The Excel program will berun from a button on a toolbar within Powerpoint.I need to be able to pass the text box text, from Powerpoint to a variable in Excel, so I can use it in my Excel VBA code.
View 1 Repliesi just got 1 question how do u create a (in excel ) variable table (database) inside a function which could be called for filling and reading through "for to next" loop module
View 2 RepliesI receive the error -
[Code]...
I need to access the current instance of MS Excel. To do that, I wrote the following code:
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Diagnostics
Private _ExcelApp As Excel.Application
[Code].....
The code runs nice, but it has a problem: After the user close the Excel application (click button X - note: no other instance of Excel exists), if you open the Windows's task manager, its possible to see the process Excel.exe.
If I open and close the Excel application, there is no process Excel.exe, but if I run my code with the Excel application openned, after the user close the Excel application, the process Excel.exe isn't finished.
i want to set a link in VB.net dynamically to a file. My url looks like that:
[Code]...
i use this:
Try
' Create an instance of StreamReader to read from a file.
Using sr As StreamReader = New StreamReader("musik.txt")
Dim line As String
[code]....
In the line line = sr.ReadLine I dont want the full path Maybe i have c:lalalalamin.mp3 And i just want to show min.mp3?
I'm trying to figure out how to get the file name of the application at run time, in case it gets renamed.Also, as a easter-egg. First post, I don't know what code to put but this is how I am so far, the {FN} is where I need the file name.
If({FN} = "easter.exe") Then
msgbox("You found a easteregg! :O")
end
I often use things like the crosshatch in filenames to group them together. Until recently this has not been a problem.
I am working modifing a WPF app which uses a Listbox to store images. I need the full path of the image to feed to a class to retrieve metadata.
The test image is named "# Canon-ixus.jpg".
Using Listbox.SelectedValue to return the filename I get "%23 Canon-ixus.jpg". There are not a whole lot of options to returning the name of the selected item from the Listbox.
Is there any simple way to get the name back to its original form?
Possible Duplicate: Way to get unique filename if specified filename already exists (.NET)Have a look at the following code:
Dim counter As Integer = 0
While System.IO.File.Exists("C:DesktopSample.xls")
counter = counter + 1
[code].....
I have a filename SBSA_UPLD_20101208 and I am interested in reading the Last date part which is 20101208. How can I do it?
View 1 RepliesI am having trouble getting a filename out of my SaveFileDialog. I am using Framework 4.0, it works fine in 3.5.
Private Sub cmdExportToPDF_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdExportToPDF.Click
Dim SaveFileDialog1 As New SaveFileDialog()
[Code].....
I am getting a filename in a String and need to get the name from this. An example:
Dim file As String = "Hello.png"
'I need to get "Hello". One way of doing it is:
Dim name As String = file.Split(ChrW(46)).First()
The problem with this method is; What happens if the filename contains a .?
[Code]....
