Search results

So In theory (if I understand everyone right), once I click the .exe file on my desktop, it will basically be like running the same working excel module code within Excel, ....only except for the fact that Excel won't be open at all (it will instead just simply reference the Excel internal gears...

VBSEdit ! That's it ! Luke, vasKov17 Thanks a mill! I'm guessing though that for everytime I used "With Application" in my code that it will throw an error (because of course I will be outside of Excel)?

I'm thinking I would have to use a compiler? (am I on the right track with thinking Visual Studio can do this)? My working code module works on an Excel worksheet activated by user input. My guess is if this is in fact possible, then I would have to make this a UserForm first? Lastly...

Simple Question... I'm simply looking to select from a START POINT in the row to an END POINT in the active row (i.e. whichever row the active cell happens to be in of course). A straight line selection on the active cell row is all I'm needing help with, but the tricky part I'm running...

I'm using Private Sub TextBox1_Change() But it processing too much code for every letter I type. I was thinking perhaps using TextBox1_Activate() but nothing happens. I just thought it'd be nice to run my code from box to box instead of refreshing the code after every single key stroke...

Something I've been trying to do for long time now is opening the VBA editor to go in directly to a specific line of code. I've been using the 3 codes beneath (but my codes have been so lengthy it would really be helpful for me to jump in exactly at a specified line). Sub Open_VBA_Editor01()...

I figured it out. I had the code in initialize when it should've been in activate.

I believe I have to place my code in the userform initialize section, but I'm not sure how to call it exactly? I'm simply trying to open a userform while simultaneously executing a code, and then hide (or unload the userform) after the code finishes.

I'm using a macro that kicks one out to transmit files. Just wanted to make sure I knew what it was -to assess whether I needed or not.

I found it was File Scripting Object stuff that was locking my folder. If you use this at the very end of your code to distract it away from other folder you're good. Dir ("c:temp*.*") Resolved ; ) I hope this helps someone out.

I'm using: Kill "C:my_folder*.*" RmDir "C:my_folder" My question and problem is you can still see the folder visible after this code is ran (even though it's deleted), but after I close the workbook it finally disappears. How do I release the folder so that it instantly deletes and...

Hui!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I thought you abandoned me : ) Good to hear from you again man. How's Australia life? Anyway, you pointed me in the right direction. This basically writes a batch file down and launches it to terminate all open folders. It refreshes Windows...

Shell "explorer C:Windows" will open a folder. But surprisingly I'm a little troubled finding something to close a folder. I need to ensure a particular folder is closed before running a code. I was going to add it to the beginning of code.

Okay I know I'm super close, but for one reason or another when I test the code above (the latest one you provided) my MsgBox is empty?

Perfect thanks Luke : )

So based on your response and the reference link, my code should look like... Dim xName as String Dim xNumber as Integer Option Explicit Function Chandoo() xName = Range("A1").Value xNumber = Range("A2").Value End Sub Sub FirstSub() MsgBox = xName & xNumber End Sub Sub SecondSub()...

Is there a way I can create a worksheet UDF, or some kind of function that would Dim all the Subs for the workbook? I have about 40 Dims, and I need them to work for all of the subs. Right now I'm copying & pasting all of the Dim data for each sub (which is lengthy and excessive), is there a...

I frankensteined some things around I found online. It's working. I hope this helps someone. Sub Check_Compied_Completion() Application.ScreenUpdating = False ''''''''''''''''''''''''''''''''''''''''''''''''' Dim FIRSTFILECOPIEDCHECK01 As String Dim FIRSTFILECOPIEDCHECK02 As String Dim...

How do you add a wait until file finishes being copied script? Set Fobj = CreateObject("Scripting.FileSystemObject") Fobj.CopyFolder ThisWorkbook.Path & "Example.txt", _ ThisWorkbook.Path & "Copied2Example.txt" Just trying to figure out a way to loop a wait until it finishes copying (I'm...

yeehawl! : ) lol Got it figured it (got lucky to be quite honest didn't really know what I was doing). Print #lInt_FreeFile01, "MkDir ExtSubFolder" Print #lInt_FreeFile01, "MkDir ExtSubFolder/ExtSubFolder02a" Print #lInt_FreeFile01, "MkDir ExtSubFolder/ExtSubFolder02b" Print...

For anyone not familiar with this code below it's awesome and works perfectly. It enables you to upload files without the hassle of constantly opening and logging in to FileZilla or whichever FTP client you might be currently using. The only problem I'm running into is I would like to upload...

I've been using Sheet2.Visible = True, and then setting it back to False after I write the data. But is there any way to bypass the true false visibility statements?

AAaah : ) Thank Luke I think that's it.

Why is it when I run this code the shade of gray color is not what's it's supposed to be? (in Excel it's the shade of gray in the far most bottom left corner of the theme colors). With Selection.Font .Name = "Kozuka Gothic Pro L" .FontStyle = "Bold" .Size = 20 .ThemeColor =...

Very very interesting... So you mean Excel will read my data from A1 to Z1.. drop down to the next line, and then calculate B2 to Z2 so on and so forth?