vba & excel 2003

Hello My question is: Is there a possibility to populate Data in a Listbox, where X Rows and Y columns are met, but only show the columns where columns are not empty? As you see on the picture, your see there are some rows without data in columns. So my Aim is to populate the rows and DELETE...

Hello. I'm fairly new to VBA and not sure whether this could be done or not. I want to paste two rows data of data into an already opened workbook. I'll try to explain what i want in a bit more with an example. Consider a workbook "A" where data is entered manually by other people. Workbook...

Hello All, I am attempting to automatically plot scatter plots on each tab in an excel workbook. I wanted some help in scanning each worksheet to see if data is present, then plot the scatter plot based on the number of valid data found. For example, in this spreadsheet: There is 2 valid...

Hello Guys I have in my excel spreadsheet a high number of pivot tables and a worksheet called "Data". I would like to know if is possible after delete some lines in this Data tab, if the all pivot tables can be refreshed automatically. Can you pls help me?

Hi All, I need VBA Macro to read worksheet and output 10% each category from one column. Data like this Name IDs A 1 A 22 A 33 A 444 A 555 A 666 A 777 A 888 A 999 A 1000...

Hi to all. I'm facing a strange issue. I have an excel and i use the code in the bottom to create some other excel files using copy and paste. (The first copy is for the headers and the second is for the data) The problem is: If i open any of the file i had create excel freeze and i had to make...

Hi! My customer has an XLS excel files with third part add-in for get market data and with macros with calls to a .Net dll for read and write on sql server tables. My customer would put the XLS excel file and .net dll in a intranet web page under authorization control because only some people...

Hi to all. I would like to know if it is possible to copy a range in a string and after paste the string in a excel sheet. This is the range i need to copy...... Set rHdr = Range("A" & i & ":" & "P" & i) Set rDtl = Range("A" & i & ":" & "K" & i) Set r0 = Range("Q" & i &...

Hi Board, Am a little out of practise with VBA. I'm getting a 438 error on the macro below. I'm trying to copy the content of column A, in blocks of 5 rows and transpose into 5 columns on sheet 3. Sub Macro4() Dim x As Integer Dim y As Integer Dim z As Integer Dim lastRow As Long x = 1 y =...

March 2018 Windows 10 update has scrambled Excel 2003, both the spreadsheet and also the vba. I use vba, among other things, to 'compile' javascript into closure-compiled form. It appears to have lost the ability to understand classes. For example, I have a js class which includes...

Hi to all. I would like to know what i have to do with a cell where i want to type a password. I want when the user type a letter or number to show lets say dot's Thanks and regards.

Right off the bat, if this should be broken out into 2 separate threads, I apologize and will adjust accordingly (if possible). I just see the two issues somewhat related and so thought that perhaps I could get them both done in one swing. Part 1: The two workbooks I am using are: WorkbookA &...

Hi Team, I have written the below mentioned code. Problem - every time code is executed, its successfully login in SAP and show me the first screen for 1 second and then, its gets closed automatically. Can you please help Code:- Set app = CreateObject("Sapgui.ScriptingCtrl.1") Set Connection...

I have this code,i want to short sheets in excel by name cane anyone improve this code. Sub Select_Sheet() Dim sh As Worksheet, shNam As String If IsEmpty(Sheets("Sum").Range("P9")) Then Exit Sub shNam = Sheets("Sum").Range("P9").Value If SheetExists(ActiveWorkbook.Name, shNam) Then...

I'm learning VBA with Bill Jelen book. The code don't work and the problem is about CreateModelConnection. I need to help. Sub Tabela_Dinamica() <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono"...

Hi to all I use this code to open multiple Excel files and taske the vaslue of a specific cell Function OpenExcelFile(PathFolderName) As String Dim XL As Excel.Application Dim WBK As Excel.Workbook Set XL = CreateObject("Excel.Application") Set WBK =...

Hi to all I want to open a specific folder, find all Excel and from a specific Sheet take a parm cell value The problem is i cant open the specific sheet and i need your help All the others work without issues The code (Function) i use to open the other excel and copy the specific cell is...

Hello, I have a list of part numbers in column B10:B15000 file C:\Shares\ENG-LOT\EngData.xls sheet named "Eng.Log". I want to do in file located S:\Shares\MAT-LOT\MatData.xls sheet named "Mat.Log" and useVB special formula to INDEX/MATCH first file C:\Shares\ENG-LOT\EngData.xls sheet named...

Hi all, I have a pivot table reading data from an excel file an a folder. This excel file is auto-saved daily from outlook. Issue is, the file name is dynamic and changes with some kind of a code in the end so I have to updated the link manually in the pivot table to read from the recent file...

Hello Everyone, I'm writing a function to calculate confidence bands for a linear regression of some data. I currently have my function set so that I can choose what range I show my bands over and what % Confidence is used for each fit. As of right now I have successfully made these two...