Announcement

Collapse
No announcement yet.

Forums

Collapse
  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
No content found
Show More
  • Filter
  • Time
  • Show
  • New Topics
Clear All
new posts
Please log in to your account to view your subscribed posts.
Directory Topics Posts Last Post
Pick the APPROPRIATE category below to post your question and/or answer questions.
Topics: 108,232 Posts: 597,005
108,232 597,005
Sub-Forums:
Excel VBA / Macros (4,092/20,469)
Excel Formulas (752/3,720)
Excel General (103,168/572,482)
Excel FAQ (165/175)
Code Review (15/58)
By using this HIRE HELP forum, you agree in full to the Terms & Conditions
Topics: 1,423 Posts: 16,346
1,423 16,346
Topics: 6,446 Posts: 28,453
6,446 28,453
Sub-Forums:
Excel and/or Word Help (1,253/5,218)
Excel and/or Access Help (2,603/11,474)
Excel and/or Email Help (1,266/5,462)
Excel and/or SQL Help (823/3,823)
No questions in this forum please.
Topics: 596 Posts: 2,410
Last Post: Locked File error
596 2,410
Topics: 985 Posts: 6,529
Last Post: Cross posting
985 6,529
Shezmo1
Cross posting
by Shezmo1
Sub-Forums:
Newsletters (4/4)
Competitions (3/13)
HAV-A-CHAT (495/4,039)
Test Area (460/2,381)
Links to Excel sites and Excel specific search engines powered by Google. Try it now!
Topics: 16 Posts: 16
16 16
Dave Hawley
$139.00 of FREE Software
Sub-Forums:
Newsletters (0/0)
Excel Blogs (0/0)
Charts (0/0)
Pivot Tables (0/0)
Solver (0/0)
Games (0/0)

What's Going On & Who's Online?

Collapse

There are currently 2070 users online. 19 members and 2051 guests.

Most users ever online was 13,741 at 02:14 on February 3rd, 2012.

Free Excel\VBA Help Forum Statistics

Collapse

Topics: 122,377   Posts: 666,761   Members: 313,986   Active Members: 660
Welcome to our newest member, rcdenman.

Welcome to OzGrid!

Collapse

Welcome to the community! Please take a moment to:

and if you have any questions - drop by in the HAV A CHAT forum!


Latest Topics

Collapse

  • rcdenman
    Userform Code for Search Function Not Working
    rcdenman
    I found a website that shows how to create a userform to search, edit, delete or add new info to your spreadsheet. Everything worked great when i used their template and followed the instructions to add the code. I have added this code to my worksheet and the add part works but the search function (and possibly the delete and edit function since I can't get past the search part) will not work. I have combed the code at least 4 times, even going so far as pulling the original code and my modified code into a spreadsheet side by side but I cannot find a problem. It just acts like there is nothing to find. I have attached the workbook. If anyone could show me where the problem is I would be very grateful!...
    14 minutes ago
  • PieterGrove
    Refering to multiple sheets
    PieterGrove
    I have the following code as listed below, no issues.

    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    
    Dim sh2 As Worksheet, a As Long, lr2 As Long
    
    Set sh2 = Sheets("Sheet 5")
    
    lr2 = sh2.Cells(Rows.Count, 1).End(xlUp).Row
    
    If WorksheetFunction.CountIf(sh2.Range("A1:A" & lr2), Cells(Target.Row, Target.Column).Value) <> 0 Then
    
    Select Case Target.Column
    
    Case 1, 2, 3, 4, 5, 6, 7
    
    a = sh2.Columns(1).Find(Target.Value, , , 1).Row
    
    With Cells(Target.Row, Target.Column)
    
    If Not .Comment Is Nothing Then .Comment.Delete
    
    .AddComment
    
    .Comment.Text Text:=sh2.Cells(a, 2).Value & vbLf & _
    ...
    41 minutes ago
  • wakandoo
    consolidate date from different excel files with same headers
    wakandoo
    Hello all,

    Can you guys help me with a macro that can consolidate data from differrent excel files with similar headers?

    My headers start from A3-K3

    Column A and B will always be filled but the rest may or may not be filled up completely.

    the excel files will all be saved in the same folder.

    the excel files in question may or may not have other sheets in their workbook

    the sheet that I need for the excel will be similarly named and it is " Tracker".



    I hope you can help me with this since I have searched for days for something similar that I need but I can't find any that works for me
    4 hours ago

Recent Blog Posts

Collapse

There are no results that meet this criteria.

Trending on OzGrid

Collapse

  • adygelber
    Insert string into Explorer address bar or solve ShellSearch issue
    adygelber
    Hello friends,

    Is there any possibility to insert a string into the Windows Explorer's address bar?

    To be more clear I want to search a folder, using Windows Find built-in function, by a keyword. To do this, I want to insert the following string into Explorer address bar:

    search-ms:displayname=My%20Search&crumb=Anyintegernumber%3A%3D" & "my string" & "%20OR%20System.Generic.String%3A" & "my string" & "&crumb=location:C%3A%5CTemp

    This will search c:\Temp for "my string" but unfortunatelly I don't know how to insert this into the address bar.

    Maybe you will ask why I don't use ShellSearch...I tried this but due to an unsolved issue it searches the same directory...
    September 3rd, 2015, 00:07
  • aton
    VBA to open Network drive without mappping the drive
    aton
    Hi,

    I am using the below 2 lines to open a mapped network drive:

    ChDrive ("V:")
    ChDir "V:\Folder1\folder2\folder3"

    My problem is that every user have a different letter on their machine as it's a mapped network drive. I have tried changing code to Can ChDrive ("\\") , ChDir "\\Folder1\folder2\folder3" but unfortunately it didn't work.

    Can anyone please advise on a code that map/search for network drive based on a drive name instead of letter?

    Thank you in advanced.

    Regards
    Aton
    January 7th, 2016, 05:41
  • AndrewAfresh2
    Playing a sound file in windows 7 using VBA
    AndrewAfresh2
    Does the method to play a sound in VBA described here: http://www.cpearson.com/excel/PlaySound.aspx work in windows 7? It uses winmm.dll which doesn't come up when I search my pc. Windows explorer IS showing hidden files and protected operating system files. Thank you
    January 15th, 2018, 05:50
  • eae
    Error 438 when opening a workbook
    eae
    I am still learning VBA, but I know this is most likely a simple mistake. The variable "isum" that I created to replace a workbook that daily changes its name is getting an error 438. I cannot open it using 'filepath & wb' because of the '&' so I made a variable for them both. I am trying to copy a section on a sheet from one workbook, pasting to another sheet area on a different workbook. Here is my code:

    Code:
    Sub Summary()
    Application.ScreenUpdating = False
    
    'create variables
    Dim wb As String
    Dim filepath As String
    Dim isum As Workbook
    Dim CBD As Workbook
    
    'variables for file with changing date in name title
    filepath = "\\main\stuff\Summary"
    wb = "Today Summary " & Format(Date,
    ...
    3 weeks ago
  • Magdoulin
    Word Formatting by Excel VBA
    Magdoulin
    Hi guys,
    How is everything?
    I hope youíll be able to assist me with the following
    Iím trying to write a code which will open for me an existing word file, create for me a new one, and make the background colour of this newly created file as black and its font colour as automatic.
    So far Iíve accomplished the first and the second step with the following code;
    Code:
    Sub TrialHere()
    Dim wkb As Workbook
    Dim WordApp As Object
    Dim WordDoc As Object
    Dim objWord
    Dim objDoc
    Set WordApp = CreateObject("word.Application")
    Set WordDoc = WordApp.Documents.Open(Filename:="File Path", ReadOnly:=False)
    Set objWord = CreateObject("Word.Application")
    Set objDoc = objWord.Documents.Add
    objWord.Visible
    ...
    4 days ago
Working...
X