No announcements
-
0 Votes
write a function that can create a new list, from which it only picks data with >0 values.
0 (as shown ...Unanswered | 2 Replies | 174 Views | Created by Niznet - Monday, December 9, 2019 9:19 PM | Last reply by OssieMac - Tuesday, December 10, 2019 11:27 AM -
0 Votes
Convert a serie of specific tabs of my excel file into separate CSV files
Hi everyone, I currently work on an excel file with 13 tabs among which 8 only must be exported into separate CSV files. I managed to find a macro which converts ...Unanswered | 6 Replies | 213 Views | Created by charliecoch - Wednesday, December 4, 2019 9:32 AM | Last reply by charliecoch - Monday, December 9, 2019 8:42 AM -
0 Votes
Shortcut F8 for debug step into is not working
Hi All, Thanks for looking into it. Shortcut F8 for debug step into is not working. When I press F8 nothing happens. The screen is ...Unanswered | 8 Replies | 286 Views | Created by Shrinivas Iyer - Wednesday, December 4, 2019 9:41 AM | Last reply by Shrinivas Iyer - Monday, December 9, 2019 1:24 AM -
0 Votes
Is VB6 SP6 required to use MSWinsck.,ocx?
I have Excel 2016 on Win8.1. I'm trying to use MSWinsck.ocx but cannot add it to a VBA Form. I get "Subject not trusted for specified operation" error. I've checked the Killbits and cleared ...Answered | 18 Replies | 634 Views | Created by StupinIs - Tuesday, November 26, 2019 12:59 AM | Last reply by StupinIs - Sunday, December 8, 2019 11:34 PM -
0 Votes
Create a memento of Word 365 Advanced Options
I need to insert Code to record the Advanced Options settings (used to be called Edit Options in previous versions of Word) and then restore them afterwards. Can anyone offer code ... -
0 Votes
VBA Macro Outlook export email + Sender name
" & oitem.Subject 'MsgBox "Sender Email Address -> " & oitem.SenderEmailAddress 'MsgBox "Sender Name -> " & ... -
0 Votes
VBA to move ppt object to a specific location
I am using VBA to push calculations from Access into charts, graphs and tables in a template powerpoint presentation. The objects are manipulated with tables within Access for specific ...Unanswered | 1 Replies | 244 Views | Created by Stacy0609 - Monday, October 7, 2019 3:08 PM | Last reply by William Sessums - Friday, December 6, 2019 3:56 AM -
2 Votes
Error 3340, La consulta " esta dañada. VBA Access 2010
Al ejecutar el codigo: Currendb.Execute "Update Empleados Set Activo=true Where id=5" asi como en todos los ...Answered | 17 Replies | 7813 Views | Created by Luis Carlos H - Thursday, November 14, 2019 12:56 AM | Last reply by XDDDD2 - Thursday, December 5, 2019 12:12 PM -
0 Votes
Dynamic Range VBA
Hi team, i try to create this on VBA excell the source data is other sheet A which has auto refresh ON based on interval time on external resources, so no ...Unanswered | 1 Replies | 176 Views | Created by HARDI.ID - Thursday, December 5, 2019 3:57 AM | Last reply by Hans Vogelaar MVP - Thursday, December 5, 2019 8:52 AM -
0 Votes
Thisworkbook no longer works in UDF but Activeworkbook does?
Can anyone tell me why all of a sudden my Public Functions no longer work and come up with "Automation Error". to Fix it all i need to do is change Thisworkbook to ...Unanswered | 1 Replies | 181 Views | Created by Rob Sizer - Monday, December 2, 2019 5:56 AM | Last reply by Hans Vogelaar MVP - Monday, December 2, 2019 8:47 AM -
0 Votes
Issue: "Variable uses an Automation type not supported in Visual Basic"
Hello, In order to keep the hyperlinks active when hiding the other worksheets I'm trying in VBA to switch from "(General)" to "Worksheet" and then to change ... -
0 Votes
Microsoft Search Feature
The Excel 365 desktop application new has the new microsoft search feature https://docs.microsoft.com/en-us/microsoftsearch/overview-microsoft-search. Is there an idMSo or VBA object ... -
0 Votes
acViewPreview Clears Form - Access VBA
Hi, first time poster, so apologies if I have broken any rules etc. I have a database I am working on in Access 2010, and I populate a form using VBA and DLookup based on a ...Unanswered | 1 Replies | 772 Views | Created by m4rkb4 - Monday, March 31, 2014 10:19 AM | Last reply by The wondere - Monday, November 25, 2019 11:58 AM -
0 Votes
Audit Trail in Excel
I have set up an audit trail in Excel where it tracks changes in the cells of my spreadsheet but I would like for it to also track whether cells or whole rows/columns are inserted or deleted. Can ...Unanswered | 1 Replies | 296 Views | Created by kndusek - Wednesday, November 20, 2019 6:12 PM | Last reply by Ashidacchi - Friday, November 22, 2019 7:05 AM -
0 Votes
Outlook BCC script from certain email accounts only
I have been driven mad by this problem. I have three email accounts. I only want to bcc someone if I am using my primary account. I had this script, which was working fine, ...Unanswered | 4 Replies | 268 Views | Created by Swizylstik - Tuesday, November 19, 2019 6:02 PM | Last reply by Swizylstik - Thursday, November 21, 2019 8:17 PM -
0 Votes
VBA (Office) - MSTSCLib - Remote Desktop Services aka Terminal Services on Server 2008
I need to code an application through Microsoft's Office VBA, most likely through excel. The purpose of the code will be to loop through all current terminal/remote desktop sessions on a ...Unanswered | 2 Replies | 991 Views | Created by Gerneio - Friday, March 25, 2016 4:24 AM | Last reply by OptimuS_Prime_000 - Tuesday, November 19, 2019 9:01 AM -
0 Votes
Recording macro _without starting vba_
Since at least Word 2007, and still in 2019, starting to record a macro _without_ starting the vba editor first will _very_ often result in the macro recorder _not_ purring in the initial sub ... -
0 Votes
Why does a saved photo disappear after a few moments when it is opened?
1. I save a transparent picture in png format. 2. Open the photo (with Microsoft photos) by clicking on ...Unanswered | 3 Replies | 302 Views | Created by Saulius LT - Saturday, November 16, 2019 6:55 AM | Last reply by Ashidacchi - Sunday, November 17, 2019 12:49 AM -
1 Votes
Variables in Wsh Shell and cmd.exe commands
In Excel, I would use variables in a wsh.run command (it should launch a batch file), instead of local path, but I got an error in the dos console: "The file name, directory name or volume label ...Answered | 4 Replies | 317 Views | Created by giangis - Friday, November 15, 2019 5:00 PM | Last reply by giangis - Friday, November 15, 2019 8:36 PM -
0 Votes
Transfer data from worksheet to User Form
I have a project that saves information to a workbook. I added a user form to show the data in specific sheet. ex get the data from worksheet(1) to fill the text Boxes in My user ...Unanswered | 1 Replies | 305 Views | Created by Shakkaray - Friday, November 15, 2019 4:09 PM | Last reply by Hans Vogelaar MVP - Friday, November 15, 2019 7:26 PM - Items 1 to 20 of 16824 Next ›
No announcements