AnsweredAssumed Answered

HELP WITH VBA MACRO

Question asked by Francisco Martínez on Jan 20, 2017
Latest reply on Jan 25, 2017 by Ivana Kolin

Like • Show 0 Likes0
Comment • 8

I am looking for some help with a macro we created here in house, well the other sw guy here created most of it.

it takes data from a excel sheet and creates parts with the associated cell values as part name, size ect.

we do have a location set for the template part on the :C, but it calls out for the location of the folder that has the excel sheet.

the problem is it only works sometimes and it opens up 10 or more excel.exe. I have to start task manager and shut them down.

the other sw/programmer is stumped as well.

Thanks

Attachments

Macro12.22.zip162.6 KB

No one else has this question

Outcomes

8 Replies

Amen Allah Jlili Jan 20, 2017 4:58 PM
Mark Correct
Correct Answer
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.
Like • Show 2 Likes2
Actions
- Francisco Martínez @ Amen Allah Jlili on Jan 20, 2017 6:23 PM
  Mark Correct
  Correct Answer
  i will give that a try, but i think the error is on the excel side, it may not show the error in sw2017
  Like • Show 0 Likes0
  Actions
  - Deepak Gupta @ Francisco Martínez on Jan 21, 2017 1:54 AM
    Mark Correct
    Correct Answer
    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
    Like • Show 1 Like1
    Actions
    - Francisco Martínez @ Deepak Gupta on Jan 21, 2017 9:51 AM
      Mark Correct
      Correct Answer
      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.
      Attachments
      9550-6450-PHOENIX.xlsx12.2 KB
      Like • Show 0 Likes0
      Actions
Ivana Kolin Jan 24, 2017 3:21 AM
Mark Correct
Correct Answer
try this
Attachments
- IBAMacro.zip27.6 KB
Like • Show 1 Like1
Actions
- Francisco Martínez @ Ivana Kolin on Jan 24, 2017 10:30 AM
  Mark Correct
  Correct Answer
  I will take a look, thank you
  Like • Show 0 Likes0
  Actions
  - Francisco Martínez @ Francisco Martínez on Jan 25, 2017 10:57 AM
    Mark Correct
    Correct Answer
    if anyone could help with the creation of this macro I am open for quotes
    Like • Show 0 Likes0
    Actions
    - Ivana Kolin @ Francisco Martínez on Jan 25, 2017 1:12 PM
      Mark Correct
      Correct Answer
      is it not working? What do you need?
      Like • Show 0 Likes0
      Actions

HELP WITH VBA MACRO

Attachments

Outcomes

Attachments

Attachments

Related Content

Recommended Content