Is there any way to attach an image to the clipboard? Specifically, am I able to attach the filepath of the image into the clipboard so that I can paste it, such as in Paint?

Thanks for reading.

When I tested the IfDirExists function on a shared folder path, like this: IfDirExists>\\192.168.1.0 MessageModal>I can access this server EndIf It will return the True indicator, even though the directory doesn't exist for the user. Is there a way to determine of a certain shared folder directory i...

If I run a DBExec, and in the event that the SQL script has an error, how do I disable the error message so that the script can run till the end? The script is intended to be run at an interval, and there might be an event where an SQL data error could occur. Problem is, I don't want the error messa...

When I want to separate a string by the amount of lines it has, what is the best way to do it? Currently, Separate is based on delimiters to determine the separation, but as far as I know, it's based on the character, which means that it's difficult to properly use a new line character. Thanks for r...

When I want to separate a string by the amount of lines it has, what is the best way to do it? Currently, Separate is based on delimiters to determine the separation, but as far as I know, it's based on the character, which means that it's difficult to properly use a new line character. Thanks for r...

That might be the reason. I haven't tried it since I don't have a need to now.

I am not sure what I am doing wrong, but I could not pass commands to Task Scheduler. For example, I want to click on the commands on the Task Scheduler window, but Task Scheduler doesn't seem to register the commands I passed. Eventually I decided to run a specific task through CMD, but one thing I...

OK, thank you for the advice.

The situation now is this: apparently a customer's Task Scheduler is not working as intended (namely, tasks cannot run on the scheduled time), so a temporary solution is to run a certain program after every 5 hours using Macro. What I am thinking of doing is to set a Macro application on a loop to r...

There are a series of PDF files I would like to convert into table data. The proposed format is SQL, but Excel is OK also, if the former is harder to do. Attached is one sample file.

Is it possible to do this?

Thanks for reading.

This seems to work. Thank you!

Also, I noticed that xlSum, xlCount and xlAverage are assigned negative numbers. How do you get those numbers for those specific functions?

I have highlighted the fields in the Pivot table, and there is a Sum (in addition to Average and Count). Moreover, when I attempt to manually adjust the Values item, it can be converted from Count to Sum. Isn't there a way to change a column from Sum to Value within the code?

Thank you for the information, hagchr, but there's one thing I need to know: how do you convert the column values to SUM? Right now the value is in COUNT, and from what I see the VBA in Excel works differently from the VB code in Macro.

When I substituted the VB portion of my script, I got an error on this line: The error message is: PivotTableWizard method of Worksheet class failed. Do you know why I got this error?

I am doing a Macro that involves creating a Pivot Table, but I am having some trouble with the implementation. These are the configurations I want to make in the Pivot Table: Report Filter: DESCRIPTION Row Labels: STORE Values: BUDGET (Sum), ACTUAL (Sum) Filter: DESCRIPTION = TOTAL GROSS SALES The t...