How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9659
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

Hi John DIn relation to the recent job for BT and CIVILS

Customer Question

Hi John D

In relation to the recent job for BT and CIVILS schedules: I know you said the initial xls was a formatting pig so wondering if we can add some very basic formatting to the exports via the macro:


1. simple border outer and inner.

2. bolded titles.

3. Text alighnment left top.

4. 100% width on the whole table so all text fits in screen so it readable in one hit.

5. Text wrap where required (usually NOTES row).


Thank you
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  John D replied 1 year ago.
Hi Michael

There are so many files related to that question. Please send me the file that you would like me to work on

 

 

Customer: replied 1 year ago.

 


https://www.dropbox.com/s/3g2pdozpf9v25jv/BT%20VICTORIA%205b.xlsm


 


Thank you :)


 

Expert:  John D replied 1 year ago.

Ok here you go

 

http://www.ge.tt/2zhxlgU/v/0?c

 

The formatting is applied to the excel file prior to converting it to html so I am not sure if all the formatting will be retained when saved to an html file.

 

Here is the formatted excel file "BT Pending.xlsx" prior to converting it to html so you can see how the new macro formats the excel file

 

http://www.ge.tt/6VTXmgU/v/0?c

 

Hope this is ok. Let me know if you have any questions

 

Customer: replied 1 year ago.

I'll give it a rip. Thank you.


 


I saw the other 'large job' question is closed. Is there an issue?


 


Thank you for all your help.

Expert:  John D replied 1 year ago.
Not that I know of. It still looks open to me. Here is the link

http://www.justanswer.com/microsoft-office/7fhgh-hi-made-spreadsheet-back-helping.html

Let me know if you're not able to access it
Customer: replied 1 year ago.

No worries. I can access it, it just says closed. No problem, just checking. :]

Expert:  John D replied 1 year ago.

No problem.

Let me know if the formatting solution that I gave you in my above answer is ok

 

 

 

 

 

 

Expert:  John D replied 1 year ago.
I am almost done with that main program. Should have it ready today.

Are we done with this question?
Customer: replied 1 year ago.

Hello, unfortunately it does not work at all. Doesn't fit and resize nicely like the table in the email does as per example below. Also no border.


 


 


 


Expert:  John D replied 1 year ago.

Hi Michael,

 

Didn't know that you wanted it formatted in that manner. Also in your last image you only have 4 columns as opposed to the 6 columns we had before

 

Anyway here is the modified code which formats the file as per you last image

 

http://www.ge.tt/6UqqYpU/v/0?c

 

The file will be formatted as shown in the image below

 

graphic

 

 

Hope this is ok. Let me know if you have any questions

 

Customer: replied 1 year ago.

Run time error unfortunately.

 

 

 

https://www.evernote.com/shard/s235/sh/375ba446-29cd-444c-ae95-29ca7794c9fb/8c86d80d292d91953fe67bbc4481b775
https://www.evernote.com/shard/s235/sh/0bdacc84-1c5e-48a2-b744-ba23bc35b6cb/77005a102273561bae9e70a036de4ff4

 

Expert:  John D replied 1 year ago.

The problem is there are some commands that work on the PC version but are not compatible with the Mac, and apparently the 'TextToColumns' command is one of them

 

Here, I have used an alternative method hope it will work

 

http://www.ge.tt/6Mkv52V/v/0?c

 

Please check it and let me know if you still have any issues

 

 

I will be working on the other question today

 

 

 

 

Customer: replied 1 year ago.

Hi John


 


I have gone back to this question hoping for a solution. Unfortunately nothing has really worked so far as HTML solutions. Now that I have Windows up and running I see that the isssue really is OSX and Safari as the outputs are as you have originally specified and do work in IE.

Is it possible for the macro to go between excel and outlook?

The idea would be excel creates the required table(s), cuts and pastes into outlook and sends to a specified mail group.

Possible?
Expert:  John D replied 1 year ago.
Glad it worked.

A macro can be written in Excel which will send the content of a specific sheet in that workbook as an email attachment using Outlook to a specified recipient. That I can help with but not sending data from html files or other web sources

Thank you

Customer: replied 1 year ago.

This is what we do at the moment:


 


http://www.evernote.com/shard/s235/sh/7f91a7b8-a16b-486e-aca7-12ba2b3b832f/570e0eaec6b1b99b1df84cac53a2066e


 


Ignore everything after the table as it is me manually doing things.


 


I don't want to have the email with the xls attached, more I would prefer to cut and paste the pending parts of the two tables into the emails.


 


I would also like to be able to specify the two email groups from within excel so I could add/subtract email addresses in a separate sheet on the work book and then fire the macro.


 


It would then set up the email in outlook so it could be quickly scanned over and then I would manually press the send button.


 


 

Expert:  John D replied 1 year ago.

Will review your comments/file and get back to you

 

Did you have a chance to test the other program?

 

 

 

 

 

 

 

 

 

 

Expert:  John D replied 1 year ago.
Hi Michael,

I have reviewed your comments and the screenshot image but unfortunately I will not be able to help further with this question. As you know I have given several solutions/answers over the past two weeks but apparently none was useful. So I will opt out of this question in order to open it to all experts hoping someone will be able to help

Awaiting your response to the new macro in the other question
Customer: replied 1 year ago.

Hi John


 


I ask that you reconsider on three counts:


 


1. the technical aspect of the issues, from my perspective were the limitations of OSX and IOS.


 


2. I am quite prepared to pay for failed attempts where I have caused the issue(s), whether it be poor explanations on my behalf or excessive limitations bought on by my situation (ie. attempting to keep everything mac compatible). I understand the 'contractor' situation as I am one also.


 


3. I feel that this requested solution will work fine now that the limitations have been removed.


 


4. If/when this solution is successful I would like to implement it elsewhere for reporting and therefore create more work/$ for you, if you are interested.


 


if the answer is still no, thank you for your help with it, otherwise would really like it if you re-consider the abort.


 


Thank you again

Expert:  Rachel-Mod replied 1 year ago.

Hello,

I’m a moderator for this topic. It seems the Professional has left this conversation. This happens occasionally, and it's usually because the Professional thinks that someone else might be a better match for your question. I've been working hard to find a new Professional to assist you with your question, but sometimes finding the right Professional can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!

Rachel

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions

Chat Now With A Microsoft Office Technician
John D
John D
385 Satisfied Customers
Bachelor of Science - Engineering Consultant