Search results for query: *

Hello, Tried that and it did not record each step. I am just stuck...

I can make an org chart manually (using the data from excel) through the "Org Chart Wizard" and it works fine. Now, I want to do the same using VBA. I have written the following code but it is not working as expected. Private Sub CommandButton1_Click() Dim TxtFileName As String Dim NameField...

This had to come up before? Any help would be appreciated.

I found this code but and it opens up visio not sure how to use it to incorporate my excel workbook. Any help would be greatly appreciated. Sub Main() 'Read the command line Dim strCommand As String strCommand = Command$ 'Check if the add-on exists On Error GoTo OrgDoItErrHandler Dim...

Hi mintjulep - thanks for the feedback. One more thing I forgot to mention in the post yesterday senior manager and then sub managers. Any help would be greatly appreciated. Director Manager Employee Business Unit John Adams Mike Huss Joe Smith Accounting Mike Huss...

Hello All, I am trying to automate multi-page visio document. I am familiar with the Business Organization Chart Wizard, but it is very time consuming given I have 10 reporting line managers and my org chart is constantly changing. Is it possible using VBA based on Excel data to create a...

Hi SkipV, It works great. Thank you for your help.

Thanks Andy for updating. Can anyone assist in modifying VBA code?

Fair point. OLD Person System Delivery Joe PC 1/10/2015 Mo Mac 2/15/2020 Allan Mobile 5/18/2015 Sam PC 12/31/2015 New Person System Delivery Joe PC 1/10/2015 Allan Mobile 11/1/2015 Sam PC 12/31/2015 Results of VBA code: Diff Ref. OLD NEW A3 Mo Allan B3 Mac Mobile C3 2/15/2020 11/1/2015 A4...

Hi SkipV, Sorry about not responding back sooner. I am not familiar with using SQL in VBA code. I was not sure how to ask the question so I found some code on the site that thought would help resolve my issue. I think the SQL will help identify my deletes and new items but it will not...

Hi, I am trying identify what cells changed month over month, what rows are deleted month over month and what new rows have been added. I am thinking it maybe best to show diffs in another tab Thanks

Hello All, Hoping to get your input on a compare excel worksheet problem. I have two tabs (OLD and NEW), the OLD tab contains data from the previous month and NEW tab contains data from the current month. Each tab has 2000 plus rows and 25 columns. Data in OLD tab can be in NEW tab. Also...

Hello, Actually it is - Please see code below Sub Unzip1() Dim FSO As Object Dim oApp As Object Dim Fname As Variant Dim FileNameFolder As Variant Dim DefPath As String Dim FileName As String Call DeleteExample1 Fname =...

Hi All, I am trying to find VBA code that will unzip the last saved zip file in a folder and rename the csv file in the zipped folder and save it in another folder. Is that possible?

I am not sure how to manipulate the following code to loop through visible cells. I currently have a filter, but the For loop is checking every cell instead of visible (filtered data): lRow = ActiveCell.Row For lRow = LasrRowMax To 2 Step -1 If Cells(lRow, "DP").Value = "YES" Or...

Hi SkipVought, It work perfectly. I did something silly in the code. Thank you for your help!

sorry, I was not clear. I need to round up.For example if table value is less than the value in sheet 1. Hope that clearer.

Yes, I have a numeric value in the table that exceeds the sum in sheet 1.

Hi SkipVought, One twist I forgot about. If the value in the table is greater than the total of a cells in column B in sheet one then change the all text in column C to "NO". Thanks for the help!

Thanks!