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?
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 RepliesI 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 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 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 receive the error -
[Code]...
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]....
I have a directory with more then 350.000 files in. I need to process every single file and move them to an other folder. When I use the dir() method it takes a few seconds before if it returns the first file found.
dim foundfile as string = dir("d:")
In the documentation there is this:
"The My.Computer.FileSystem Object gives you greater productivity and performance in file I/O operations than the Dir function. See My.Computer.FileSystem.GetDirectoryInfo Method for more information."
But I can't find any method that is faster then dir, and gives the same result. I can't use this method below because it takes for ever to load......
For Each foundFile As String In My.Computer.FileSystem.GetFiles("D:")
Next
It just does not work fast...
When I use the Dir() method it takes like 5 sec, and it uses 100% cpu... it is just not a option. How do I get the same function as the dir method but better performance? (I use visual basic 2008).
This question was resolved in C#, and I don't know how to do it in VB net. I want to search through a directory of files and see if my string is contained within any of the filenames. Then I just need a bolean answer if it exists or not. I know how to use the file.exists...this is not what I need. The link below is to the C# response. How to check if filename contains substring in C#
[Code]...
In the XP SaveFileDialog, the user is allowed to set the SaveFileDialog.FileName.
I'm using Vista operating system and am using the VistaBridgeLibrary.dll so that I can get the Vista version of the Dialog Boxes. With the CommonSaveFileDialog (for Vista dialog), I'm unable to set the FileName property since it's read only.
Is there a way to populate the FileName so that when the DialogBox displays the filename in use is displayed?
There is no editor available for '<filename>'.Make sure the application for the file type (.vb) is installed.I got this message after I updated a VB08 project to VB10. I tried to open a form when this message was shown. It happens to every form in the group (but not standard classes).
View 1 RepliesI have a Form that load the contents of a txt type file into a textbox1. How can I use the filename to fill in a label?For example, when I open the file Name1.txt, the textBox2 need to display Name1 only as a type of header.
Alternatively, is there a code that make the first line of a Multiline Textbox to display a different font or size ?
I am trying to capitlize the first letter of a filename, but I am getting an error that the file already exists.
Dim folder2 As String = ComboBox2.SelectedItem
'rename the hap file
Dim source As String = System.Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments)
[code]....
Process.Start("C:/wamp/bin/mysql/mysql5.5.16/bin/mysqldump.exe", "-uroot coop usertrails -r """ & FolderBrowserDialog1.SelectedPath & "ackup.sql""")
how can i make the filename of the mysqldump use current time and date?
i know i can use now.date. how will i add it on my current code?
I'm looping trhough some files in a folder, is there any way to arrange them by filename alphabetically?[code]
View 6 RepliesI have an app that opens MS word. I then open Word's File open dialog and have it pointing to a specific directory to find a file for the user to open. What i cannot do is retrieve the file name the user selected to open. In a Window's fileopen dialog i can read the .fileopen property, however there doesn't seem to be a corresponding property to read in Word's dialog. Is this even possible? if so how do i do it?
View 4 RepliesI've got some debugging code that looks like this[code]...
The purpose of this code is to output the name of the calling method. Now, I would like to output the FILENAME where the calling method resides. Is this information available?
i want to detect currently opened swf file name here is my code
Private Const GW_HWNDNEXT = 2 Private Declare Function GetWindow Lib "user32" (ByVal hWnd As Long, ByVal wCmd As Long) As Long
Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
[Code]....
this code is working fine to detect .doc,.xls files name but not working on *.swf files