-
Re: HELP WITH VBA MACRO
The file is created with 2017. You can simply debug the macro line by line and you're bound to finding what's causing the error.
Press F8 to run line by line.-
Re: HELP WITH VBA MACRO
i will give that a try, but i think the error is on the excel side, it may not show the error in sw2017
-
Re: HELP WITH VBA MACRO
I'm not able to get this macro working. I do not see anything that would open up the template part file. Also you have set excel to invisible and it is also not set to close/exit at end of the task. So it is simply running without user come to know about that. And since it doesn't work all time, user might be running it over and over and hence multiple instances of the excel.
Here is one thing you can use. Instead of Set xlApp = New Excel.Application use
Set xlApp = GetObject("", Excel.Application)
If xlApp Is Nothing Then Set xlApp = New Excel.Application
To quit and release excel, you can use
xlApp.Quit
Set xlApp = Nothing
-
Re: HELP WITH VBA MACRO
Hi Deepak,
I probably did not explain this correctly.
the template part has to be opened first in sw, then the user will run macro, it will prompt user for folder of excel.
Also the excel template has to be in the format as the example I attached( no blank lines in row one), and it reads column D thru H, rows 1 untill it sees a blank row.
I will give those 2 a try
Thank you for your help.
-
-
-
-
-
