Search results for query: *

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...

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...

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...

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...

Hello All, I am not sure if this is possible and I have not been able to find something in the the threads that would help me. My question is the following: I have 4000 rows of data, one row contains text (column A) and another with numbers (column B) and a third column with text (column C)...

Hello All, I am not sure if this is possible and I have not been able to find something in the the threads that would help me. My question is the following: I have 4000 rows of data, one row contains text (column A) and another with numbers (column B) and a third column with text (column C)...