No announcements
-
17 VotesHow to ask a question efficiently in MSDN Visual Basic for Applications forum?
Thank you for visiting the MSDN Visual Basic For Applications (VBA) forum! :) The online problem solving can be relatively time consuming because it may ...Sticky | 3 Replies | 15959 Views | Created by danishani - Wednesday, March 14, 2012 12:19 AM | Last reply by Joohny - Wednesday, April 24, 2013 6:44 AM
-
0 Votes
Crash when viewing interface exposing array in watch window
Hi, My main problem is that when ever I have an interface that exposes an array as a property and try to view it through the watch window it causes an ...Unanswered | 1 Replies | 62 Views | Created by NickBlick - Sunday, May 13, 2018 3:35 PM | Last reply by HarveyEllis - 2 hours 46 minutes ago -
0 Votes
A combination class?
How would you create a class clsAll which is the combination of: 1. a class clsCat made up of a single string named ...Unanswered | 0 Replies | 25 Views | Created by pi3.141592653589793238462643383279 - 4 hours 47 minutes ago -
0 Votes
How to set up a class like this?
How would you create a class <b>clsBlock</g> which is the combination of: 1. a class clsCat made up of a single string named Category 2: a ...Unanswered | 0 Replies | 28 Views | Created by pi3.141592653589793238462643383279 - 4 hours 57 minutes ago -
0 Votes
Class inheritance?
I've got a string Category and a record Rec: ID(integer),Name(string),Stuff(string) I'd ...Unanswered | 0 Replies | 34 Views | Created by pi3.141592653589793238462643383279 - 11 hours 22 minutes ago -
0 Votes
Write protecting a text file created in VBA
I have a text file which is created using VBA in Access. I want the user to be able to access the file to upload it to our bank, but I don't want them to be able to edit the file using notepad or ...Unanswered | 1 Replies | 22 Views | Created by ADG_01 - Thursday, July 19, 2018 3:50 PM | Last reply by mogulman52 - 20 hours 59 minutes ago -
0 Votes
How to concatenate column headers into a string with comma separated delimiter - VBA
Hi, I have a small requirement where I need to write a macro which concatenates all the headers of the current worksheet into a string with comma delimiter. can anyone help me in ...Unanswered | 2 Replies | 34 Views | Created by Rahul 11 - Thursday, July 19, 2018 4:37 PM | Last reply by Luca Brasi - Friday, July 20, 2018 6:36 AM -
0 Votes
Prevent moving a sheet using vba
is there a way to prevent a user from moving a sheet without having to protect the workbook. I would like to prevent users from moving a worksheet to another workbook, but don't ...Unanswered | 3 Replies | 58 Views | Created by James N San - Wednesday, July 18, 2018 3:36 AM | Last reply by Luca Brasi - Friday, July 20, 2018 6:26 AM -
0 Votes
Need write a VBA code to scan the imported excel files and should give a pop up window if any of the columns are missing in the imported files.
Hi All, I am new to VBA, and I am working on the excel tool, where we are importing bunch of files and the tool has other macors which are doing the calculation to generate output ... -
0 Votes
VBA code to open workbook that changes filename every single time
Hello VBA developers! Hoping you can help me update this code. Basically, its objective is that each time there is a quote created, it will log all the details into a master ...Answered | 2 Replies | 42 Views | Created by IamJackie - Tuesday, July 17, 2018 11:33 PM | Last reply by IamJackie - Wednesday, July 18, 2018 4:37 PM -
0 Votes
VBA code copy and paste to the next blank cell
Dear VBA delvelopers! Appreciate your help in advance. Will need to update code below. What it is doing is that it copies data from a workbook then pastes it to ...Answered | 2 Replies | 48 Views | Created by IamJackie - Tuesday, July 17, 2018 11:45 PM | Last reply by IamJackie - Wednesday, July 18, 2018 4:36 PM -
0 Votes
vba security problem - pwd is easily cracked
Hi, As you know vba passwords are easily cracked or removed by a few methods and it seems there is no a way to secure password in ...Unanswered | 7 Replies | 196 Views | Created by k_turhan - Monday, May 21, 2018 6:02 AM | Last reply by Peter Thornton (Excel MVP 2008-13) - Wednesday, July 18, 2018 9:01 AM -
3 Votes
Webbrowser control loads outside the VBA userform in excel
We have a VBA form in Excel, which will load a URL to show the login page, when the page is loaded the form opens separately and browser control loads the page in a separate ...Unanswered | 6 Replies | 298 Views | Created by Rajeev6006 - Friday, June 8, 2018 4:49 AM | Last reply by Rajeev6006 - Wednesday, July 18, 2018 8:48 AM -
0 Votes
Copy Columns 1 through x from Sheet1 and stack on each other on Column A of Sheet2
Hi Team - I have a need where I need copy the data in Row 2 and below across however many columns there are from "Action Script" and then paste in Column A of ...Unanswered | 1 Replies | 42 Views | Created by cdtakacs1 - Tuesday, July 17, 2018 8:15 PM | Last reply by cdtakacs1 - Wednesday, July 18, 2018 1:11 AM -
0 Votes
Automate remainder emails Outlook VBA
Hi, i am new to outlook macros, i am trying to create a outlook VBA without using excel to send automatic remainder to the particular recipient when the flagged date is met using ...Unanswered | 1 Replies | 72 Views | Created by Deena102 - Thursday, June 28, 2018 8:43 PM | Last reply by Deena102 - Tuesday, July 17, 2018 5:19 PM -
1 Votes
Accessing Windows Portable Devices (WPD) through Access 2010 VBA
I am trying to code a button in Access that will allow me to automatically transfer pictures and video from a digital camera to my hard drive. After transferring, I want to automatically delete ...Proposed | 5 Replies | 1492 Views | Created by Jeff9445 - Monday, April 27, 2015 9:34 PM | Last reply by PTSDan - Tuesday, July 17, 2018 4:14 PM -
0 Votes
Using ADOMD.Cellset to create a pivot table
Hello, I really want to create a pivot table with row grouping (dimensions) and column grouping. When i create my mdx (using crossjoin) in the cube i get a cellset back, that result ... -
1 Votes
Excel 2010 VBA - VBProjects without ExcelObjectWorksheet
Hello to everybody. i have Excel2010 over Windows 7. After I have enabled the Developer tab, I enter in VB and the classic window is open. I ...Answered | 3 Replies | 122 Views | Created by m.bonelli - Wednesday, February 28, 2018 2:50 AM | Last reply by m.bonelli - Monday, July 16, 2018 8:56 AM -
0 Votes
For filtered value in column A(unique values), find the duplicates on each columns and write if it is true or false at the end of the column
Hi, I'm working on the below requirement Data: I have a data of 10,000 rows with 15 columns 1. For Each Filtered value in Column ...Unanswered | 0 Replies | 32 Views | Created by Jayakumar Krishnamoorthy - Monday, July 16, 2018 7:59 AM -
0 Votes
Using DCount function in a Report group footer
Hi, I'm having trouble getting a DCount function to work on an MSAccess 2003 report. I'm using a text box ...Unanswered | 7 Replies | 7012 Views | Created by LizF_ - Monday, October 15, 2007 5:27 AM | Last reply by MackW - Sunday, July 15, 2018 1:23 AM -
0 Votes
Concatenate multiple cells
Hello, I have a lot of data that has been generated randomly. Now I need to unify the information. Two records on a different row that need to be unified, if they ...Unanswered | 5 Replies | 111 Views | Created by Cdilenes - Friday, July 13, 2018 11:37 PM | Last reply by Cdilenes - Saturday, July 14, 2018 10:11 PM - Items 1 to 20 of 14806 Next ›
No announcements
