I have no idea about PtrSafe keyword. Just did Google about this a while ago.
I am trying to know if use of PtrSafe has advantage or disadvantage in the coding.
Also, is PtrSafe required for 64 but machine.
Or are there any constraints or mandates to use or not to use PtrSafe while using...
I am running below code.
This code is run on two different locations.
On one location code runs fine.
However at another location macros face bug at 'T_Sht.AutoFilterMode = False' line.
Also this bug is not permanent, sometimes macro will face bug and sometime macro will not face any issue...
This is a MS Access Query.
My apologies if this is not allowed.
I want to use where clause in query from Excel VBA.
I am not able to do it, I tried various options from Google but could not succeed.
I want to select data WHERE Name = 'ThrottleWorks'.
I can do it in MS Access but not able...
I am facing an issue while creating an e-mail item from Excel VBA.
This particular code is working fine at my system.
However facing issues at user’s desk while trying to create e-mail.
I have copied the code for creating e-mails for Ron De Bruin’s site.
And this code is working fine for...
I am running a macro from Excel.
This macro involves working with Excel, Word, PDF and Outlook.
In short, my macro is exporting e-mails to PDF.
Please see below link for your reference.
Macro takes time to...
How do we filter date and time values such as ‘1/15/2019 4:08:48 PM’ from a range.
I have a range, in this range we have a column for dates.
And I have stored date be filtered in a cell, let us say, cell A1.
And range to filter the dates is B1:B50.
How do I filter value from cell A1 in...
I am using below mentioned to code to get latest e-mail.
I am able to get latest e-mail but not able to do a ‘reply to all’ for the particular e-mail.
I am able to ‘Display’ it.
How do I do ‘Reply to all’ for the particular e-mail in the loop.
Please note, rest of the code is working...
I am using below mentioned code to get filenames from a folder.
However, I am facing a bug at ‘With Application.FileSearch’ line.
The code is copied from ‘https://www.automateexcel.com/vba/list-all-files/’.
Can anyone please help me in this...
I am using below mentioned code to add “CustomDocumentProperties.Add Name”.
My code is skipping “objWordApp.ActiveDocument.CustomDocumentProperties.Add Name:="YourName", LinkToContent:=False, Value:="thename", _
As soon as code hits this line, macro...
I need to export e-mail as PDF and save.
User has shared Outlook.
In one of the shared account he will have one particular folder.
This folder might have n number of e-mails, let us say 500.
From this 500, I need to export each e-mail as PDF and save.
One more condition is, if the subject...
I have one excel file.
This file may have n number of worksheets.
For example, 50. Out of these there will be 4 pre-defined worksheets.
I need to exclude these 4 worksheets and export remaining 46 worksheets as PDF files.
So I will have 46 different PDF files saved from one file.
I have a folder.
This folder will have excel file with different extensions.
XLS, XLSM or XLSB. Files can be of any excel extension.
How do I open each file from the folder.
Can anyone please help me in this.
I am trying below mentioned formula in a worksheet.
Last row of the worksheet in 70,000 +.
I tried applying this formula at one go with usual method.
For example, Range(“A2:A” & TempLr) .FormulaR1C1 =...
I am facing issue while opening or saving excel file with macro.
I am using below line to open excel file in my code.
Once macro tries to execute this line, I get pop-up with below message.
Downloadig (message header)
Downloading: file path and...