Problem with printer name while using executeexcel4macro

G

Grimgrim

Joined
Jul 7, 2011
Messages
1
Reaction score
0
Hello,

I got a problem with a macro outlook :

The command to print so far was :
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,"\\server.com\IMPA sur Ne06:",,,,FALSE)"

The macro was used on two different PC and worked fine on both of them.

Suddenly this stopped on one PC : after some test, it worked only if the 'Ne06' was changed to 'Ne07'.

Having two different macros (one with Ne06, the other with Ne07) for the same thing in a excel file works but is a little stupid.

After some check, I wasn't able to see what 'NeXX' stands for and how to alter it so that both PC can use the same macro again.


Is someone can help me ?

Thanks in advance for your answers.


EDIT : Just in case, it's on Excel 2007 and Windows XP SP3
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB help with ExecuteExcel4Macro 7
Help with my macro 8
Change to different active printers on different PC's 3
Macro for all Excel Workbooks to print to PDF 2
Open file with variable date name based on current date 1
Excel 2007 Chart Update While Macro Is Running 4
Two macros with same name in different workbooks 3
Run code from another workbook 7

Top