Search:
Type: Posts; User: Sean04
Search:
Search took 0.05 seconds.
-
Thanks guys
Works great paul!
-
Hey thanks! Works great! How would I just get the filename rather then the entire directory? :p
-
Hey,
How would I get the full name of a file(s) and put them all into a drop down list. Essentially what i'm trying to do is have a list of temples that are in a folder and a user can pick which...
-
Yeah I see what you mean. I'm not to sure how to write it but obviously your going to need a loop that goes through the rows each time you click the submit button.
You should just use a list box...
-
why dont you make it so that all textboxs have to be filled in before data gets exported to the excel sheet?
and each update it just reopens that specific sheet?
-
So what exactly are you trying to do?
You can do something like this if you want textbox values to go to different cells:
xlApp.Range("A1").Value = TextBox1.Text
xlApp.Range("A2").Value =...
-
Oh I just noticed you said "from a textbox" :p
In that case you can simply use:
Dim xlApp As Excel.Application = DirectCast(CreateObject("Excel.Application"), Excel.Application)
...
-
Post your code, all you should have to do is replace the textbox.text with the variable name. Let me take a look.
And by the way, myRandomNumVariable should be replaced with YOUR variable name.
-
I'm sure you got this correct? Just use what I gave you here and instead of the TextBox1.Text, just put your variable.
http://www.vbforums.com/showthread.php?t=607821
Imports...
-
Good glad it worked out! :)
-
Sorry that I didn't get back to you on time.
I'm glad you found everything and glad everything is working :)
-
Hmm.. its the strangest thing.. but yeah take a look for the dll.. if still no luck come back and post here, i'm sure someone will give you a hand! And I'll try and check it out as well. The weird...
-
Try this..
Dim xlApp As Excel.Application = DirectCast(CreateObject("Excel.Application"), Excel.Application)
Dim xlAppWorkbook As Excel.Workbook =...
-
Start by adding the Microsoft.Office.Interop.Excel reference. You can do this by going to Project > Add Reference > (under the .NET Tab add) Microsoft.Office.Interop.Excel
Add a button and a...
-
Try something like this..
Dim xlApp As Excel.Application = DirectCast(CreateObject("Excel.Application"), Excel.Application)
Dim xlAppWorkbook As Excel.Workbook =...
-
I'm pretty sure anything thats under the .NET Tab comes with the .NET framework... maybe download the .NET 3.5 Framework? If that doesn't work then try and look for the .dll file. Besides that I'm...
-
hmm.. maybe add the Microsoft Office 12.0 Object Library then take a look in the .NET tab?
-
Is there anything under the .NET tab that has outlook in it?
-
Before the class even starts. You might have to go to Project > Add Reference > (and under the .NET Tab add) Microsoft.Office.Interop.Outlook
-
You might have to use this instead of your code. This works:
Dim ListBoxValues As String = Nothing
For Each ItemInListBox As Object In ListBox1.SelectedItems
...
-
No problem!
Yeah I was checking that out. I thought something like this would work as it seems to give the line break in the messagebox but not in the body of the message:
Dim...
-
Oh right sorry..
Dim ListBoxValues As String = Nothing
For Each ItemInListBox As Object In ListBox1.SelectedItems
ListBoxValues = ListBoxValues + ItemInListBox &...
-
This will get all the selected values in the listbox:
For Each ItemInListBox As Object In ListBox1.SelectedItems
MessageBox.Show(ItemInListBox)
Next
-
Try this..
Dataset1.Tables.Columns("column").DataType
-
Thanks westconn,
I was looking around and thats exactly what I found
Application.OnTime TimeValue("13:00:00"), "Macro"
This doesn't seem to work for me.. either that or I'm not putting it...
-
Thanks for the reply LaVolpe, I managed to get rid of the security warnings with your suggestion.
As for auto running a macro, I'm aware of the load event that will run a macro on start up but I...
-
Hey,
So I have an Access Application and I'm using a Scheduled Task to run it everyday at say.. 5:00 pm. How would I run a macro at a specific time (lets say 5:01 pm).
And I know this isn't an...
-
Thank you koolsid! Works perfectly! :)
Sean
-
hmm... mine doesn't seem to work and yes I have implemented your edit. Could you send me your code? I'm probably missing something small.
-
It still seems to give me the same result as before where most are red. Should I be removing String.Format? I'm not to sure...
Thanks,
Sean
-
Sorry about that..
Red dates are suppose to be weekends
-
I attached my code.. thats all I have though!
-
Like the code? Or a screenshot of the excel file and what it actually looks like?
-
This is what I currently have. All the cells listed have a date in them and its displayed like March 10, 2010. For some reason after the 15th, all the cells become red. Am I doing something wrong?
...
-
Hey thanks sapator. I actually just came across that site and it worked perfect!
Thanks again though,
Sean
-
thank you for the reply Hack, but is there any other way that this can be done? like running a macro from an excel doc from a vb.net application.
-
I have an excel document that has a button that i need to activate through vb.net. Anyone have any idea?
Thanks,
Sean
-
This works..
Dim lines() As String
Dim string1 As String
string1 = TextBox1.Text
lines = string1.Split(":")
Dim Result As String
-
Look into regular expressions. That should help you obtain the exact information you need every time you execute the program. As long as the webpage is updated, you will be to :p
...
-
Thanks for the reply guys,
cicatrix, I am looking more for the WEEKDAY() as I knew it exsisted but didn't know how to use it :p thanks though!!
Koolsid, in my excel sheet I have dates going...
|
Click Here to Expand Forum to Full Width
|