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: 9666
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: 3 years ago.
Category: Microsoft Office
Expert:  John D replied 3 years 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 3 years ago.

 


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


 


Thank you :)


 

Expert:  John D replied 3 years 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 3 years 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 3 years 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 3 years ago.

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

Expert:  John D replied 3 years ago.

No problem.

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

 

 

 

 

 

 

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

Are we done with this question?
Customer: replied 3 years 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 3 years 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 3 years 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 3 years 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 3 years 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 3 years 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 3 years 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 3 years 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 3 years 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 3 years 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 3 years 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